Analyzing Data with DAX
Overview
This course is designed to provide participants with the skills and knowledge to create robust data models and perform advanced data analysis using DAX (Data Analysis Expressions) in Power BI. By the end of the course, participants will be able to develop interactive dashboards, apply time intelligence functions, create complex calculations, and build insightful business intelligence solutions through effective use of DAX.
Course Objective
This course teaches the participants to:
• Support cyber security planning with leading frameworks, such as NIST
• Ensure the participants to understand the need for effective cyber security risk
management
• Assess and understand the roles and responsibilities of management and board members
• Apply Governance Policy to ensure minimum exposure for the organization and
themselves
Who Should Attend
This course is ideal for data analysts, business intelligence professionals, and Power BI users who want to elevate their data modeling and analytical capabilities using DAX. It is also suitable for professionals involved in creating reports and dashboards who need to derive more meaningful insights from their data.
Prerequisites
Training Calendar
Intake
Duration
Program Fees
Module
Module 1 - CREATING A DATA MODEL IN POWER PIVOT
• Data Modeling in PowerBI Desktop Environment
• Data Model or Query?
• The PowerBI Desktop Data View Ribbons
• Managing PowerBI Desktop Data
• PowerBI Desktop Data Types
• Formatting PowerBI Desktop Data
• Preparing Data for Dashboards
• Sorting Data in PowerBI Desktop Tables
• Adding Hierarchies
• Creating and Modifying Groups
• Deleting a Group
• Designing a PowerBI Desktop Data Model
• Creating Relationships
• Advanced Relationship Options
• Managing Relationships Between Tables
Module 2 - EXTENDING THE DATA MODEL
• Types of Calculations
• Adding new Columns
• Concatenating Column Contents
• Tweaking Text
• Simple Calculation
• Calculating Across Tables
• Cascading Column Calculations
• Using Functions in New Columns
• The IF() Function
Module 3 - ADDING MEASURES
• Basic Aggregations
• Using Multiple Measures
• Cross-Table Measures
• More Advanced Aggregation
• Filter Context
• Filtering data in Measures
• Simple Filters
• More Complex Filters
• Calculating Percentages of Totals
• Filtering on Measures
• Displaying Rank
• Calculation Options
Module 4 - ANALYZING DATA OVER TIME
• Simple Date Calculations
• Adding Time Intelligence to be a Data Model
• Creating and Applying a Date Table
• Calculating the Difference Between Two Dates
• Applying Time Intelligence
• Comparisons with Previous Time Periods
• Comparisons with a Parallel Period in Time
• Rolling Aggregations over a Period of Time
FAQs
General Questions:
Q: What is the Analyzing Data with DAX course about?
This course introduces participants to creating data models and using DAX (Data Analysis Expressions) in Power BI to develop interactive dashboards and perform advanced data analysis for business intelligence.
Q: Who should attend this course?
Data analysts, business intelligence professionals, and Power BI users who want to enhance their data modeling and analytical capabilities using DAX.
Q: What are the prerequisites for this course?
Participants should have experience working with Power BI or have completed Microsoft course 20778: Analyzing Data with Power BI.
Q: How long is the course?
The course lasts for 2 days.
Q: What key topics are covered in this course?
Creating a data model in Power BI
Extending the data model with calculations and functions
Adding and using measures for advanced analysis
Applying time intelligence and analyzing data over time
Q: Will I receive a certification after completing the course?
No formal certification is provided, but participants will acquire professional-level DAX and data modeling skills applicable to real-world business scenarios.
Program Content & Skills:
Q: What foundational data modeling and DAX concepts will I learn in this course?
You’ll learn how to build effective data models in Power BI, create relationships between tables, and apply DAX functions to perform calculations and enhance data analysis for dashboards and reports.
Q: How does the course prepare me to align data modeling with business intelligence goals?
The course teaches you to use DAX to create dynamic metrics, perform time-based analysis, and design data structures that support strategic decision-making and meaningful business insights.
Q: What skills will I develop in analyzing and transforming data?
You’ll gain hands-on skills in creating calculated columns and measures, managing filter context, formatting and sorting data, building hierarchies, and writing expressions using DAX for complex calculations.
Q: Will I learn how to apply DAX across different tables and time periods?
Yes. The course covers cross-table calculations, comparisons over previous and parallel time periods, rolling aggregations, and time intelligence functions using custom date tables.
Q: How does the course address real-world reporting and dashboard needs?
You’ll learn to prepare and structure data for interactive dashboards, apply advanced filters, rank and percentage calculations, and use Power BI features to support flexible and dynamic reporting.
Submit your interest today !
