Data Model Design using Power BI Desktop – Level 2 Virtual Classroom Live January 08, 2025

Price: $650

This course runs for a duration of 1 Day.

The class will run daily from 7:00 AM PST to 3:00 PM PST.

Class Location: Virtual LIVE Instructor Led - Virtual Live Classroom.

Enroll today to reserve your spot!

Space is limited. Enroll today.

Enroll Now

Description

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

Lesson 1: Understanding Power BI Data Queries

Overview of Power BI Queries
Power Query
Data Sources

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
Refreshing 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
Evaluation Context
Optimize Model Performance
Date Tables

Lesson 6: Introduction to the M Language

Power BI Functions: M Language
M Language Syntax
Adding Columns

Appendices

Storage Modes (Import vs DirectQuery)
Dataverse
Power Query and Query folding

Prerequisites

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

Course Comments

Knowledge Transfer Consulting Services Inc. is a single-source solution provider offering a full range of Training Delivery and Training Management solutions from concept to delivery. Learn more