* Please note that this is an online course, delivered remotely by a live instructor through Microsoft Teams *

Course: PBIDAX

Duration: 2 Days

Overview

This 2-Day course is designed to lay solid foundations before diving deep into complex DAX functions. This is achieved by focusing on 2 key elements i.e. engagement, and practicality. Participants will be spending their time writing hands-on DAX functions, looking at the result, discussing what works, and especially what does not work and WHY? Additionally, all the modules and concepts are reinforced by real-life, scenario-based examples to solidify the learnings.

After this course, participants should be able to write DAX expressions to address their specific business needs, leverage available resources to tackle complex problems, debug and optimize using available tools and the right techniques. Moreover, the entire course walks through a single data set so participants can concentrate on mastering the concepts rather than worrying about the specifics of the dataset.

This 2-day course covers the latest functionalities and updates in Power BI while diving deep into practical solutions of the common challenges faced by a business user while performing analytics. During this course, students will learn how to perform more sophisticated data manipulations, best practices and do’s and don’ts of data modelling, AI-enhanced features and visuals and managing the security to build an enterprise-level solution.

Audience

This course is for business users (Finance, Marketing, Operations etc.) or SQL Server report creators who want to take their reports and dashboards to a next level by writing custom calculations using DAX functions to address specific business requirements.

Prerequisites

This DAX course is suitable for people who have either completed the Power BI Essentials course or have a reasonable understanding of data modeling concepts. To benefit most from this course, participants must have some expertise in using excel functions or SQL.

Module List

Module 1: Getting to know Data Analysis Expression (DAX) Language
Module 2: Data Modelling Recap
Module 3: Calculated Columns and Measures
Module 5: Evaluation Contexts in DAX
Module 6: Table Functions
Module 7: Creating Date Table
Module 8: Basic Iterators
Module 9: Variables in DAX
Module 10: Advance Filtering in DAX
Module 11: Context Transition
Module 13: Conditionals in DAX
Module 14: Hierarchies In DAX

Click here for the full 'Power BI DAX Essentials' course outline