Data Model Design using Power BI Desktop – Level 2

Course Duration

1 Day

Audience

Employees of federal, state and local governments; and businesses working with the government.

Prerequisites

No prerequisites required.

Course Description

This is the second course in the 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.

Course Outline

• Unit 1: Understanding Power BI Data Queries
• Unit 2: Creating and Transforming Data Models
• Unit 3: Data Transformations
• Unit 4: Accessing Additional Data Sources
• Unit 5: DAX Calculated Columns and Measures
• Unit 6: Introduction to the M Language