Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

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.

Click here to print this page »

Prerequisites


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
DAX

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


DAX
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