MS-20779 - Analyzing Data with Excel

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.

Student Testimonials

Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus. Student
Excellent presentation skills, subject matter knowledge, and command of the environment. Student
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect. Student

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
Loading Data

Module 4: Importing Data from Databases

Available Data Sources
Previewing, Shaping, and Transforming Data
Table Relationships and Hierarchies
Loading Data

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

Pivot Charts
Cube Functions
Charts for Cube Functions

Module 8: Using Excel with Power BI

Power BI
Uploading Excel Data to Power BI
Power BI Mobile A