Duration 5 days – 35 hrs
Overview
The DAX (Data Analysis Expressions) Training Course is designed to provide participants with a comprehensive understanding of DAX, the powerful formula language used in Power BI, Excel, and SQL Server Analysis Services. This course covers the essential concepts, functions, and techniques required to create advanced calculations and complex data models.
Objectives
• Learn the skills you need to use Power Pivot and DAX Language.
• Be able to write DAX to address specific business needs.
• Create calculate fields and measures using DAX.
• Have comprehensive understanding of creating data models and developing DAX formulas in Power BI.
• Learn to create hierarchies and data groups for better data analysis.
Audience
• Business Analysts: Those who need to create advanced calculations and analytical models to support business decisions.
• Data Analysts: Professionals tasked with data manipulation, analysis, and reporting using Power BI or Excel.
• BI Developers: Individuals involved in designing and developing business intelligence solutions, particularly those using Power BI, Excel, or SQL Server Analysis Services.
• Financial Analysts: Professionals who need to perform complex financial calculations and analysis within Power BI or Excel.
• IT Professionals: Those responsible for managing and implementing BI tools and data models.
• Data Scientists: Individuals who want to leverage DAX to create more sophisticated data models and analytics.
• Students and Academics: Learners in the field of data analytics, business intelligence, or related disciplines who want to enhance their skills in data modeling and analysis.
Prerequisites
• Basic understanding of data analysis and Excel functions.
• Familiarity with Power BI or Excel’s data modeling features is helpful but not required.
Course Content
Day 1 DAX Part 1
• Pre-Test #1 – DAX Part 1
• Data Modelling
• Loading Data
• Measures
• DAX Calculations
• SUM()
• COUNT()
• COUNTROWS()
• MIN()
• MAX()
• COUNTBLANK()
• DIVIDE()
• Post-Test #1 – DAX Part 1
Day 2 DAX Part 2
• Pre-Test #2 – DAX Part 2
• Filter Propagation
• Lookup Tables
• Data Tables
• Basic Iterators
• SUMX()
• AVERAGEX()
• Calculated Columns
• Post-Test #2 – DAX Part 2
Day 3 DAX Part 3
• Pre-Test #3 – DAX Part 3
• CALCULATE()
• Evaluation Context and Context Transition=
• IF(), SWITCH() and FIND()
• VALUES(), HASONEVALUE(), SELECTEDVALUE() and CONCATENATEX()
• Post-Test #3 – DAX Part 3
Day 4 DAX Part 4
• Pre-Test #4 – DAX Part 4
• ALL(), ALLEXCEPT() and ALLSELECTED()
• FILTER()
• Time Intelligence
• RELATED() and RELATEDTABLE()
• Post-Test #4 – DAX Part 4
Day 5 Dax Part 5
• Pre-Test #5 – DAX Part 5
• Disconnected Tables
• Multiple Data Tables
• Using Analyze in Excel and Cube Formulas
• Transferring your skills to Excel
• Post-Test #5 – DAX Part 5
