Analyzing Data with DAX
Overview
Introduces you to the art of creating a data model and DAX language at professional level on
which you can base your interactive dashboards and reports. DAX: the Power BI Desktop
language that you use to advance and tailor your analysis. You will use this language to create
the metrics for your business intelligence.
Duration
2 Days
Prerequisites
The participants should have experience working with Power BI or attended 20778 Microsoft
course.
Analyzing Data with DAX
Course Topics
CREATING A DATA MODEL IN POWER PIVOT
• Data Modeling in PowerBI Desktop Environment
• Data Model or Query?
• The PowerBI Desktop Data View Ribbons
• Managing PowerBI Desktop Data
• PowerBI Desktop Data Types
• Formatting PowerBI Desktop Data
Module 1 • Preparing Data for Dashboards
• Sorting Data in PowerBI Desktop Tables
• Adding Hierarchies
• Creating and Modifying Groups
• Deleting a Group
• Designing a PowerBI Desktop Data Model
• Creating Relationships
• Advanced Relationship Options
• Managing Relationships Between Tables
EXTENDING THE DATA MODEL
• Types of Calculations
• Adding new Columns
• Concatenating Column Contents
Module 2 • Tweaking Text
• Simple Calculation
• Calculating Across Tables
• Cascading Column Calculations
• Using Functions in New Columns
• The IF() Function
Analyzing Data with DAX
ADDING MEASURES
• Basic Aggregations
• Using Multiple Measures
• Cross-Table Measures
• More Advanced Aggregation
• Filter Context
Module 3 • Filtering data in Measures
• Simple Filters
• More Complex Filters
• Calculating Percentages of Totals
• Filtering on Measures
• Displaying Rank
• Calculation Options
ANALYZING DATA OVER TIME
• Simple Date Calculations
• Adding Time Intelligence to be a Data Model
• Creating and Applying a Date Table
Module 4 • Calculating the Difference Between Two Dates
• Applying Time Intelligence
• Comparisons with Previous Time Periods
• Comparisons with a Parallel Period in Time
• Rolling Aggregations over a Period of Time
