This two-day course empowers business analysts to design, develop, and publish robust Power BI Desktop models. It focuses on import data model design theory and development, and foundational DAX theory and practice.
Attendees learn to:
- Work productively with Power BI Desktop to create import data models
- Use Power Query, DAX, and manually entered data to create model tables
- Configure model relationships
- Enhance model designs with date tables, hierarchies, calculations, and reporting properties
- Publish models, configure dataset properties and data refresh
- Apply DAX to create common and useful model calculations
Duration
2 days
Products
This course is based on the current offering of Microsoft Power BI, with a focus on business analyst experiences with Power BI Desktop for the Power BI service, or Power BI Report Server.
This course does not cover the basics of the Power BI service, or Power BI report development. These topics are covered in the one-day Power BI for the Business User course, which is considered prerequisite training.
Prerequisites
Ideally, attendees have:
- A general knowledge of data storage technologies and formats, including relational databases
- Proficiency with Excel
- Power BI report development skills
Attendees are required to have their own computer that must meet minimum requirements:
- A Windows 7 computer, or later, network-enabled for Internet access
- The latest version of Power BI Desktop, 32- or 64-bit
- A PDF viewer (like Adobe Acrobat Reader, or a web browser)
Delivery Format
A classroom delivery includes:
- Instructor presentation and demonstrations
- Course book
- Labs and activities
Course Outline
Module 01: Introducing Power BI Desktop
- Introducing Power BI Desktop
- Development Modes
Lab 01A – Creating the Power BI Desktop File
Module 02: Developing Model Tables
- “Getting Data”
- Introducing Power Query
- Configuring Queries
- Managing Queries
- Recommended Practices
Lab 02A – Developing Queries (Part 1)
Lab 02B – Developing Queries (Part 2)
Lab 02C – Managing Queries
Module 03: Configuring Model Relationships
- Describing Relationships
- Configuring Relationships
- Recommended Practices
Lab 03A – Configuring Model Relationships
Module 04: Enhancing Model Designs
- Configuring the Model
- Configuring Tables
- Configuring Columns
- Creating Hierarchies
- Creating Simple Calculations
- Configuring Measures
- Advanced Model Design Features
- Recommended Practices
Lab 04A – Enhancing the Model Design
Lab 04B – Adding Advanced Model Features
Module 05: Managing Publication
- Publishing Models
- Configuring Dataset Properties
- Configuring Data Refresh
- Change Management
Module 06: Introducing DAX
- Introducing DAX
- Describing Calculation Types
- Introducing Formula Basics
- Describing Data Types
- Introducing Common Functions
- Defining Variables
- Implementing Error Handling
The class with progress through up to 23 intructor-led activities which have been designed to introduce and practice key theory. The pace of the activities will be set to one that is appropriate for the entire class, and so it may not be possible to complete all activities.
Module 07: Manipulating DAX Context
- Describing Context
- Manipulating Context
- Inspecting Context
- Recommended Practices
Module 08: DAX Iterator Functions
- Introducing Iterator Functions
- Common Scenarios
- Recommended Practices
Module 09: DAX Time Intelligence
- Introducing Time Intelligence Functions
- Common Scenarios
- Recommended Practices
Module 10: Case Studies
- On-time Performance (OTP)
- Net Promoter Score (NPS)
- General Ledger Transaction Analysis
Time permitting, the case studies provide an opportunity to apply the DAX theory to real-world scenarios.
Certification
This course has not been designed to prepare attendees for Microsoft certification. However, the course content can serve as a useful resource for introducing theory, products, capabilities and recommended design practices that are assessed by Microsoft certification exams.
