Tecflix

Mastering DAX Workshop (2nd Ed) Purchase the entire course

26 October 2020 · 828 views

Loading the video player...

If this message stays on please ensure you are using a supported browser with JavaScript enabled.

See our device support page.

Watch 1-min Overview

This 2nd edition of the DAX workshop is a complete video course focused on Data Analysis Expressions language. DAX is the native language of Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services. Our course is aimed at users and developers who want to master data analytics and BI.

You will learn all the features of DAX and how to write formulas for common and advanced business scenarios. The course is made of more than 16 hours of lectures, and over 10 hours of additional videos explaining how to complete individual exercises, making a grand total of 26 hours of video material alone. Of course, you can take as long as you need to while you practice with us! Use the convenient “Jump to chapter” links to quickly rewind the videos to relevant sections, or where you left off.

Alberto Ferrari and Marco Russo are world’s undisputed authorities on the subject of DAX. Their books, numerous conference presentations, and live courses, are regarded as the best. This course gives you a chance to experience their mastery first-hand, and at your own pace.

When you purchase access to this course, you will also get access to over 700M of lab file data, workbook, and a PDF containing all presentation slides.

Course content

  • Introduction to Mastering DAX 2nd Edition 5-min Free—Watch Now

  • Introduction to DAX 1-hour 46-min Watch with Free Subscription

  • Exercises, Labs, Demos, and Presentation Slides 52-min

  • Exercises for: Introduction to DAX 52-min Watch with Free Subscription

  • Table Functions 1-hour 9-min

  • Exercises for: Table Functions 44-min

  • Evaluation Contexts 57-min

  • Exercises for: Evaluation Contexts 29-min

  • The CALCULATE Function 1-hour 4-min

  • Exercises for: The CALCULATE Function 49-min

  • Advanced Evaluation Contexts 56-min

  • Exercises for: Advanced Evaluation Contexts 1-hour 5-min

  • Iterators 41-min

  • Exercises for: Iterators 39-min

  • Building a Date Table 37-min

  • Time Intelligence in DAX 1-hour 20-min

  • Exercises for: Time Intelligence in DAX 46-min

  • Hierarchies in DAX 37-min

  • Querying with DAX 1-hour 58-min

  • Exercises for: Querying with DAX 47-min

  • Data Lineage and TREATAS 13-min

  • Expanded Tables 34-min

  • Exercises for: Expanded Tables 15-min

  • Segmentation 36-min

  • Exercises for: Segmentation 14-min

  • Many-to-many Relationships 35-min

  • Exercises for: Many-to-Many Relationships 13-min

  • Advanced Filtering 49-min

  • Relationships at Different Granularities 1-hour 20-min

  • Additional Exercises 27-min

  • Calculation Groups 1-hour 27-min

  • Exercises for: Calculation Groups 57-min

Purchase a Full Access Subscription

 
Individual Subscription

$480/year

Access all content on this site for 1 year.
Purchase
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase
 
  • You can also redeem a prepaid code.
  • Payments are instant and you will receive a tax invoice straight away.
  • We offer sales quotes/pro-forma invoices, and we accept purchase orders and bank transfers.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.
  • See pricing FAQ for more detail.
In collaboration with
Project Botticelli logo Oxford Computer Training logo SQLBI logo Prodata logo