What makes Power BI for such a vast improvement over simple Excel worksheets is the Power Query engine in both Power BI and Excel. Power Query allows data to be pulled and transformed from multiple data sources. This course is designed for Report Builders who are ready to create custom data models for themselves and for other Power BI Report Users.
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 »
Prerequisites
Data Analysis using Power BI Desktop - Level 1 - Report Builder
Detailed Class Syllabus
Lesson 1: Understanding Power BI Data Queries
Overview of Power BI Queries
Power Query
Data Sources
Lesson 2: Creating and Transforming Data Models
Understanding a Basic Data Model
Creating the Initial Data Query
Converting Raw Data into a Data Model
Lesson 3: Data Transformations
Query Editor Transformations
Altering the Data
Creating new Data
Refreshing Data
Lesson 4: Accessing Additional Data Sources
Using an Access database
Creating a Hybrid Data Model
Working with Data
Lesson 5: DAX Calculated Columns and Measures
Review of Calculated Columns
Power BI Measures
Evaluation Context
Optimize Model Performance
Date Tables
Lesson 6: Introduction to the M Language
Power BI Functions: M Language
M Language Syntax
Adding Columns
Appendices
Storage Modes (Import vs DirectQuery)
Dataverse
Power Query and Query folding