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.
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.
Excellent presentation skills, subject matter knowledge, and command of the environment.
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect.
Click here to print this page »
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
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
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
Optimize Model Performance
Lesson 6: Introduction to the M Language
Power BI Functions: M Language
M Language Syntax
Storage Modes (Import vs DirectQuery)
Power Query and Query folding