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

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: Getting Started with Power Query


Overview of Power BI Query
Power Query Interface

Lesson 2: Get Data from Data Sources


Identify and Connect to Data Sources
Change data source settings
Storage Modes (Import vs DirectQuery)
Dataverse

Lesson 3: Prepare the Data


Building Master and Source Tables
Query Editor Transformations
Date Tables
Modeling View & Features

Lesson 4: Model Data – Creating a Data Model


DAX Measures
Creating Measures
Best Practices

Lesson 5: DAX Calculated Columns and Measures


Review of Calculated Columns
Power BI Measures
Evaluation Context
Optimize model performance

Lesson 6: Power BI Functions – M Language


Power BI Functions: M Language
Basic M Language Queries
M Language Syntax
Adding Columns