TLGPBICDM - Data Model Design using Power BI Desktop - Level 2

This is the second course in TLG Learning’s custom Power BI Desktop training series. 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. 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 BI Data


Business Intelligence Data
Data Source Types
Power BI Data Sources

Lesson 2 : Creating Data Models


Power BI Query Import Options
Planning a Data Model - Flat File
Planning Power BI Data Queries
Planning a Data Model - Database
Planning a Data Model - Hybrid

Lesson 3 : Customizing Data Models


Query Editor Transformations
Applied Steps
Merging & Appending Queries
Understanding the Data Modeling Tool

Lesson 4 : Power BI Functions - DAX Measures


DAX Measures
Creating Measures
Best Practices

Lesson 5 : Using Dates Correctly


Building Data Tables
Building Hierarchies