Logo

Maxtrain.com - [email protected] - 513-322-8888 - 866-595-6863

TLG-PBICAL

Introduction to DAX for Power BI Desktop Users – Level 3

Description

Power BI for Excel 2019/2016 Part 3 DAX Functions

 

 

This 2-day course Power BI for Excel 2019/2016 Part 3 DAX Functions is the third course in our Power BI using Excel series and is for Excel Designers who will be responsible for taking basic PowerPivot data models and turning them into power business intelligence solutions. 

 

 

This course takes an in-depth approach to the DAX language, teaching designers how to build models that extend the capabilities of source data for more in-depth, customized business intelligence solutions. Specific topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with complex time intelligence calculations, creating advanced DAX dashboards and report elements using Slicers. 

DAX stands for Data Analysis Expressions, and is the formula language used throughout Power BI (it’s also used by Power BI behind the scenes). DAX is also found in other offerings from Microsoft, such as Power Pivot and SSAS Tabular.

What is DAX?

DAX is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. Stated more simply, DAX helps you create new information from data already in your model.

Why is DAX so important?

It’s easy to create a new Power BI Desktop file and import some data into it. You can even create reports that show valuable insights without using any DAX formulas at all. But, what if you need to analyze growth percentage across product categories and for different date ranges? Or, you need to calculate year-over-year growth compared to market trends? DAX formulas provide this capability and many other important capabilities as well. Learning how to create effective DAX formulas will help you get the most out of your data. When you get the information you need, you can begin to solve real business problems that affect your bottom line. This is the power of Power BI, and DAX will help you get there.

Outline

Course Outline

1. DAX Functionality Review

  • Review Of Calculated Column
  • PivotTable Function
  • Review Of Measure
  • Rules Of DAX Measure
  • Evaluation Context
  • Formatting DAX Code

2. Controlling Content & Values

  • Controlling Values
  • Switch Function
  • Error Handling
  • Page Break

3. Context Control Functions

  • Filter Function
  • All Function
  • Iterative Functions
  • Earlier Function
  • Calculate Function
  • Additional Uses Of The All Function

4. Contexts In Relationships

  • Working With Many Tables
  • Row Context & Relationships
  • Filter Context & Relationships
  • Values Function

5. Advanced Concepts

  • Circular Dependencies
  • Controlling Totals
  • Advanced Hierarchy Concepts

6. Time Intelligence Calculations

  • Working With Date Tables
  • Calculating Operating Periods
  • Working With Missing Periods
  • DAX Date Functions
  • Advanced Date Functions
  • Prior Year Functions
  • Moving Averages

7. DAX Dashboard Techniques

  • Parameter Tables
  • Banding
  • Ranking
  • Advanced Slicer Techniques

PreRequisites

Excel Levels 1, 2 and 3 including PivotTable and Pivot Chart skills plus a basic understanding of database concepts. Power BI for Excel Part 2 Data Model Designer or equivalent skillset is also recommended.

Starting From

$1075.50

$1195.00 List Price

2 Days Course

Class Dates

Early Bird Saving
Good To Go
$1075.50
Remote Live

This class runs from 10:00 AM to 06:00 PM EDT

MAX Educ. Savings
Categories: , ,
Loading ...