Overview

Microsoft Power BI gives you a wide range of methods to analyze your data and generate insights to support business decisions.

In this course, you will learn how to write DAX expressions to create calculated Tables, Calculated columns and measures.


You will also learn how to perform complex analysis and computations using DAX.

  • Perform Time intelligence calculations such as running totals, year over year growth, month over month growth and prior period analysis.
  • Create tables using Table functions such as VALUES, DISTINCT, FILTER and ADDCOLUMNS
  • Create Date Tables using CALENDAR and CALENDARAUTO.
  • Master DAX Concepts such as Evaluation Context, Filter Context and Row Context.
  • Perform HR Analytics using DAX.


Who should take this course

This course is perfect for all Power BI users who want to take their data analysis in Power BI to the next level. This course is recommended for both beginners and advanced Power BI users.







Benefit of this course:

  • Highly practical and hands-on.
  • Q and A section to ask questions and get feedback
  • Lifetime access to course and materials
  • Certificate of completion
  • Downloadable exercise files and DAX guide











Course Content

  Welcome to the course
Available in days
days after you enroll
  Introduction
Available in days
days after you enroll
  Calculated Tables
Available in days
days after you enroll
  Calculated Columns
Available in days
days after you enroll
  Measures and Aggregate Functions
Available in days
days after you enroll
  Context
Available in days
days after you enroll
  Iterators
Available in days
days after you enroll
  The CALCULATE Function
Available in days
days after you enroll
  Ranking Functions
Available in days
days after you enroll
  Time Intelligence Calculations
Available in days
days after you enroll
  Working with relationships
Available in days
days after you enroll
  HR Analytics Case study
Available in days
days after you enroll
  Certificate of accomplishment and review
Available in days
days after you enroll