Power BI – M and DAX Languages

The Key to Complex
Data Modeling

(2 days)

 

Hands-On Workshop
  • Participants must bring their own laptop.
Learning Outcomes
  • Use advanced functionalities in Power Query Editor and M language
  • Understand the different relationship types in data modelling
  • Build a DAX Reference Tool: understand and use DAX most common functions
  • Develop strategies to pursue M and DAX learning
Training Location

123 Slater Street, Ottawa ON K1P 5G4

$1,200.00

Clear
Focus on advanced functionalities in Power BI Desktop Application to build more complex data models. Learn key concepts to define relationships between data tables. Use M language to transform data in Power Query. Create yourself a reference tool on most common DAX functions and their application.
Prerequisite
  • Power BI Foundations course (1 Day) is a prerequisite.
  • Participants must master the Power BI Service functionalities to properly use the Desktop application.
  • Participants must master navigation in Power BI Desktop, including the Power Query Editor.

 

Target Audience

Analysts, Accountants, Report Builders, data analytics professionals

 

Bring Your Own Device

Each participant must bring his/her laptop with Power BI Desktop application.

Or add Laptop Rental to your cart.

 

Microsoft Certified Instructor

Our Ottawa-based instructor is certified by Microsoft, as a skilled professional in Business Intelligence Reporting.

 

Quality Service

Workshops are limited to a maximum of 6 attendees to address each participants questions and requests.

Training is delivered in a modern environment: offering a comfortable and bright workplace, centrally located.

 

Training Schedule

Training takes place from 9 a.m. to 4 p.m.

Learning Outcomes

  • Use advanced functionalities in Power Query Editor and M language
  • Understand the different relationship types in data modelling
  • Build a DAX Reference Tool: understand and use DAX most common functions
  • Develop strategies to pursue M and DAX learning

 

Topics

1. Power Query and M language

  • Connect to a folder and combine files
  • Explore Power Query Editor environment: Menus, Applied Steps, Advanced Editor
  • Explore M language syntax
  • Edit a query: remove columns, extract text after delimiter, add a conditional column, filter, unpivot columns, group by, drill down
  • Manage an error message
  • Edit an Applied Step using M language
  • Create Values, Lists and tables from blank queries
  • Use M functions: List.Dates, #date, Duration.Days, #duration, DateTime.LocalNow(), Date.AddYears(), Date.EndOfYear(), Date.From()
  • Create a dynamic date list
  • Search the web to resolve issues
  • Explore recommended web resources

2. Understand relationship types in data modelling

  • Explore data model and table relationships concept
  • Visualize the impact of wrong relationships
  • Create relationships: edit type and filter direction
  • Use and understand the impact of Many-to-Many relationships
  • Edit model queries to eliminate Many-to-Many relationship

3. Build a DAX reference tool

  • Understand DAX basic concepts and syntax
  • Differentiate measures and calculated columns
  • Use DAX functions: TODAY, YEAR, MONTH, DAY, FORMAT, COMBINEVALUES, COUNTA, COUNTBLANK, COUNTROWS, DISTINCTCOUNT, SUM, SUMX, FILTER, CALCULATE, ALL, ALLEXCEPT, DIVIDE, USERELATIONSHIP, IF, AND, OR, TOTALYTD, SAMEPERIODLASTYEAR
  • Use CALCULATE function to override relationship
  • Use Variables in DAX formulas
  • Use the What If Parameter
  • Deal with an inactive relationship
  • Search the web to resolve issues
  • Explore recommended web resources

You may also like…

Laptop Rental

Laptop rental for the entire training duration (1, 2 or 3 days).



View Details