Search OER Collection

ALL

PolyU OER

Internet Resource

Results for: Creator / Instructor Hermans, Felienne Keywords Microsoft Excel (Computer file)

Courseware

Data Analysis: Take it to the MAX

This course is for all of those struggling with data analysis. You will learn: - Overcome data analysis challenges in your work and research - Increase your productivity and make better business decisions - Enhance your data analysis skills using spreadsheets - Learn about advanced spreadsheet possibilities like array formulas and pivottables - Learn about Excel 2013 features like PowerPivot & PowerMap - Learn to organize and test your spreadsheets

Subjects:

Computing

Keywords:

Electronic spreadsheets -- Computer programs Visual analytics Python (Computer program language) Information visualization Microsoft Excel (Computer file)

Resource Type:

Courseware
Courseware

Data Analysis: Visualization and Dashboard Design

This course covers the main tasks required from data analysts today, including importing, summarizing, interpreting, analyzing and visualizing data. It aims to equip you with the tools that will enable you to be an independent data analyst. Most techniques will be taught in Excel with add-ons and free tools available online. You will learn: - How to make data come to life with well-known types of visualizations such as line and bar graphs and new types of visualizations such as spark lines, contour plots and population pyramids. - How to create dashboards in Excel based on live data that can meet managerial and business needs. - How to connect data from different sources, such as the web and exports from your CRM, ERP, SAP or data warehouse. - Some hands-on data science and how to use actionable analysis tools. - Deep dive into known tools like PivotTables and introduce new ones like the analysis toolpak

Subjects:

Computing

Keywords:

Visual analytics Information visualization Industrial management -- Data processing Dashboards (Management information systems) Microsoft Excel (Computer file)

Resource Type:

Courseware

Search OER Collection

ALL

PolyU OER

Internet Resource

Discipline

Keywords

Resource Type

Creator / Instructor

Affiliation

Year

Language

Data Analysis: Take it to the MAX

Data Analysis: Visualization and Dashboard Design

Search OER Collection

ALL

PolyU OER

Internet Resource

Search Constraints

Search Results