Data Model Design using Power BI Desktop – Level 2

This is the second course in the Power BI Desktop training series. Using fundamental concepts of Self-Service Data Model Design, students will use Power Query to extract, transform, and load data to create manageable and scalable data models.Students will also be receive an introduction to the M Language as well as Data Analytic eXpressions (DAX).

What is Power BI?

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Whether your data is a simple Excel spreadsheet or a collection of data from different data sources, Power BI lets you easily connect to your data sources, visualize (or discover) what’s important, and share that with anyone or everyone you want.

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

Data Analysis using Power BI Desktop – Level 1 – Report Builder

This course is for Business Analysis/User responsible for creating Reports using Power BI with Excel.