This 3-day instructor led course is designed to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.
Click here to print this page »
Before attending this course, students must have:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of relational databases.
- Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.
- Basic knowledge of data analytics equivalent to having attended course 10994.
Detailed Class Syllabus
Module 1: Data Analysis in Excel
Classic Data Analysis with Excel
Excel Pivot Tables
Limitations of Classic Data Analysis
Module 2: The Excel Data Model
Using an Excel Data Model
Module 3: Importing Data from Files
Importing Data into Excel
Shaping and Transforming Data
Module 4: Importing Data from Databases
Available Data Sources
Previewing, Shaping, and Transforming Data
Table Relationships and Hierarchies
Module 5: Importing Data from Excel Reports
Importing Data from Excel Reports
Transforming Excel report Data
Module 6: Creating and Formatting Measures
Advanced DAX Functions
Module 7: Visualizing Data in Excel
Charts for Cube Functions
Module 8: Using Excel with Power BI
Uploading Excel Data to Power BI
Power BI Mobile A