Data Model Design using Power BI Desktop – Level 2

1 Day

Description

This is the second course in our custom Power BI for the Cloud training series. What makes Power BI for the Cloud such a vast improvement over simple Excel worksheets is the Power BI Data Model, which allows data to be pulled together 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 Builders.

Power BI Series:
Part 1
Part 3

Upcoming Classes

Virtual Classroom Live
November 18, 2020

$595.00
1 Day    7:00 am PST - 3:00 pm PST
view class details and enroll
Virtual Classroom Live
December 18, 2020

$595.00
1 Day    7:00 am PST - 3:00 pm PST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

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

Upcoming Classes

Virtual Classroom Live
November 18, 2020

$595.00
1 Day    7:00 am PST - 3:00 pm PST
view class details and enroll
Virtual Classroom Live
December 18, 2020

$595.00
1 Day    7:00 am PST - 3:00 pm PST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

Power BI for the Cloud - Part 1 Report Builder

Upcoming Classes

Virtual Classroom Live
November 18, 2020

$595.00
1 Day    7:00 am PST - 3:00 pm PST
view class details and enroll
Virtual Classroom Live
December 18, 2020

$595.00
1 Day    7:00 am PST - 3:00 pm PST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Comments

This is Part 2 of a 3 Part Exclusive Power BI Cloud Learning Series

Part 1 Report Builder
Part 3 Advanced Languages

For small to large group training

 

Upcoming Classes

Virtual Classroom Live
November 18, 2020

$595.00
1 Day    7:00 am PST - 3:00 pm PST
view class details and enroll
Virtual Classroom Live
December 18, 2020

$595.00
1 Day    7:00 am PST - 3:00 pm PST
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date