fbpxl
Instructor-Led Online | 2 Days Classroom | Private Onsite

Advanced DAX Training: Understand and Optimize Power BI Data Models.

DAX language was created specifically for the handling of data models, through the use of formulas and expressions. DAX is used in several Microsoft Products such as Microsoft Power BI, Microsoft Analysis Services and Microsoft Power Pivot for Excel. These products all share the same internal engine, called Tabular/Vertipaq (xVelocity before).

With DAX we have the ability to include business logic in calculations in order to enrich our business intelligence models.

Upcoming Dates

Nov 2 – Stockholm-Kista Enroll here
Nov 4– Vienna Enroll here

Course Delivery Options

2-Day Course

The course will take place in a classroom with no more than 15 students in order to maintain a good level of interactivity.

View outline
Pre-requisites

Before attending this course, it is recommended that students have a desire to learn more about DAX and prior exposure to the DAX calculations. 

Understanding of dimensional modelling and knowledge about any functional programming language is recommended too, but not necessary.

 

After this Course

By the end of this course, you will be able to understand the key functions in DAX, the different elements that can be created with DAX and the different context involve in it. You could perform a variety of query´s using DAX, debugging and optimizing it.

 

     

    Instructors
    Lorenzo Vercellati
    Power BI architect, consultant and instructo, Lorenzo has twenty years experience on data platforms and business intelligence systems. As architect and consultant, he works always to provide innovative and performing solutions to customers. As trainer he shares Power BI knowledge by courses, webinars, speeches and Dashboard in A Day sessions He has an MCSE in BI Reporting certification and he is proud to be a speaker at SQL Saturday, Power Platform World Tour and Power Platform Bootcamp. He’s also one of the Power BI User Group Milano leaders.
    Riccardo Perico
    Back in 2010 Riccardo started working in Information Technology, and after a brief experience as ERP Consultant, he moved into Data Realm. He spent these years exploring Data world from different points of view, both as DBA and Business Intelligence Specialist. He’s a Microsoft Certified Professional (MCP), Microsoft Technology Associate (MTA) and Microsoft Certified Solution Associate (MCSA) in database and BI areas. You can usually find him in Azure and SQL Server conferences’ speakers lineups in Europe events.

    He’s an active user and speaker for Power BI User Group, he’s currently working hard to make the community bigger and stronger also in Italy. Proud to be speaker during the Power Platform World Tour and Power Platform Bootcamp stops in Italy.

    Paco González
    Paco, a Microsoft Data Platform MVP and SolidQ North America Managing Director, is the PASS Big Data Virtual Chapter Leader, SQL Saturday Barcelona Organizer and assistant at the PASS Atlanta BI User Group. He is finishing his PhD thesis about “Analyzing Social Data with Machine Learning.” He is an MCT and MCP on BizTalk Server and SQL Server. He is coauthor of Microsoft Training Kit 441.

    Paco is a frequent speaker at large and small conferences. SQL Saturdays, TechEd’s, PASS BA, PASS Summit, DevWeek London, and PAW Chicago and London.Paco, a Microsoft Data Platform MVP and SolidQ North America Managing Director, is the PASS Big Data Virtual Chapter Leader, SQL Saturday Barcelona Organizer and assistant at the PASS Atlanta BI User Group. He is finishing his PhD thesis about “Analyzing Social Data with Machine Learning.” He is an MCT and MCP on BizTalk Server and SQL Server. He is coauthor of Microsoft Training Kit 441.

    Paco is a frequent speaker at large and small conferences. SQL Saturdays, TechEd’s, PASS BA, PASS Summit, DevWeek London, and PAW Chicago and London.

    Brett Tomson
    Brett is Principal Architect, Managing Consultant and Mentor for multiple high visibility projects delivering a holistic view of critical business information and processes covering a variety of vertical markets.

    Brett is also Chapter Leader for the Triangle SQL Server User Group (TriPASS) and a published author of numerous articles and books

    Course Outline
    Module 1. Introduction to DAX
    • What is DAX?
    • What can you create with DAX?
    • Data types.
    • DAX and relationships.
    Module 2. DAX functions overview
    • DAX functions overview.
    • Filter and row context.
    • Scopes.
    • What-If and parameters.
      •  
    Module 3. Contexts and Advanced DAX.
    • CALCULATE and CALCULATETABLE.
    • More about Filter and Row contexts.
    • Time Intelligence.
    • Context transitions.
    Module 4. Internals and Optimization.
    • Debugging DAX code.
    • DAX Studio.
    • VertiPaq.
    • Query optimization.
    Contact us
    Do you want more info about these courses?
    • By submitting this information, you acknowledge that you have read the Privacy Policy and that you consent to our data processing in accordance with this Statement.
    • This field is for validation purposes and should be left unchanged.

    Invite & Earn

    X
    Signup to start sharing your link
    Signup
    Close