Applied DAX with Power BI

Applied DAX with Power BI

Power BI promotes rapid personal BI for essential data exploration and analysis. Chances are, however, that in real life you might need to go beyond just simple aggregations. Business needs might require you to extend your model with calculations. Data Analysis Expressions (DAX) gives you the needed programmatic power to travel the “last mile” and unlock the full potential of Power BI!

Data Analysis Expressions (DAX) is the expression language of Power BI, Power Pivot, and Analysis Services Tabular. It’s very powerful but it’s usually perceived as complex requiring a steep learning curve. Taught by an established expert, this two-day class is designed to help you become proficient with implementing business calculations with Data Analysis Expressions (DAX). You’ll learn practical skills that will help you tackle a wide range of reporting requirements. We’ll start with DAX fundamentals, such as calculated columns and basic measures and then progress to more advanced concepts, such as variables, filters, time intelligence, advanced relationships, and query optimization. Use the remaining hours of the second day to brainstorm your DAX puzzles!

Attend this class onsite and get a free paper copy (e-book version for international students) of the book “Applied DAX with Power BI” by Teo Lachev! Supplementing what you’ve learned in the class, this book will help you to unleash the full power of DAX!

Audience

  • Data analysts working with Power BI or Power Pivot
  • BI developers working with Power BI or Analysis Services Tabular
  • In general, anyone interested in learning DAX

Prerequisites

  • Experience in data modeling with Power BI, Power Pivot, or Tabular
  • Basic experience with programming concepts

Hardware and software requirements

  • Windows 7 or above
  • Power BI Desktop
  • Detailed software setup instructions will be sent before the event