Analyzing Data with Excel

ANALYZING AND VISUALIZING DATA WITH EXCEL COURSE OVERVIEW

Analyzing and Visualizing Data With Excel Workshop’s main goal is to teach students how to use BI techniques in Excel data analysis. The course uses Pivot Tables, the Excel Data Model to go beyond the capabilities of tables and charts.

KEY BENEFITS

1. Extend and explore a traditional Excel dashboard.
2. Extend and study an Excel data model.
3. Import CSV file that has been formatted.
4. Data from a SQL Server database is imported.
5. Data from a report can be imported.
6. Use advanced functions to create measures.
7. Create data visualizations.
8. Build a Power BI dashboard.

AUDIENCE

This course is for students who are familiar with Excel and want to learn more about business intelligence techniques.

ANALYZING AND VISUALIZING DATA WITH EXCEL COURSE OUTLINE

Module 1: Data Analysis in Excel

Firstly: Classic Data Analysis with Excel
Secondly: Excel Pivot Tables
Thirdly: Limitations of Classic Data Analysis
Finally: Building a Classic Excel Dashboard Lab

Module 2: The Excel Data Model

Firstly: Using an Excel Data Model
Secondly: DAX
Finally: Explore an Excel Data Model Lab

Module 3: Importing Data from Files

Firstly: Importing Data into Excel
Secondly: Shaping and Transforming Data
Thirdly: Loading Data
Finally: Importing Data Lab

Module 4: Importing Data from Databases

Firstly: Available Data Sources
Secondly: Previewing, Shaping, and Transforming Data
Thirdly: Loading Data
Fourthly: Table Relationships and Hierarchies
Finally: Importing Data from Multiple Sources Lab

Module 5: Importing Data from Excel Reports

Firstly: Importing Data from Excel Reports
Secondly: Transforming Excel Report Data
Finally: Importing Data from a Report

Module 6: Creating and Formatting Measures

Firstly: Data Analysis Expressions
Secondly: Measures
Thirdly: Advanced DAX Functions
Finally: Creating Measures by Using Advanced DAX Functions Lab

Module 7: Visualizing Data in Excel

Firstly: Using Pivot Charts
Secondly: Using Cube Functions
Lastly: Creating Charts for Cube Functions

See also more Courses and Workshops from HRIB.

Start learning with a wide range of best courses covering different subjects “ Talent Expert “