Power BI - Advanced DAX & Power Query
Unlock the full power of Power BI with advanced DAX and Power Query skills. Advanced DAX (Data Analysis Expressions) lets you build complex measures, time intelligence calculations, and dynamic filtering for insightful analytics. Power Query enables powerful data transformation—cleansing, merging, and reshaping data from multiple sources using M code. Together, they form the backbone of scalable, automated, and intelligent reporting. Ideal for analysts and BI professionals, mastering these tools turns raw data into actionable dashboards and interactive reports that drive real business decisions.
Outline
Module 1: Advanced Power Query (Data Transformation & Automation)
Objective:
Master Power Query to automate and streamline data preparation.
Modules 1:
• Introduction to M Language
• Advanced Data Transformation Techniques
• Unpivoting & Pivoting Data
• Concept of Conditional Column, Custom Column & Invoke custom function
• Merging & Appending Queries
• Parameterization for Dynamic Queries
• Handling Errors and Missing Data
• Working with APIs and Web Data
• Connecting with Multiple Excel files
Hands-On:
Learn how to convert a Messy and unstructured Data into Structured Data (Will try to cover most of the data transformation techniques)
Module 2: Advanced DAX (Data Modeling & Analysis)
Objective:
Deep dive into DAX for complex business logic and advanced calculations.
Modules 2:
• Row Context vs Filter Context
• Advanced Measures using:
• CALCULATE
• FILTER
• ALL / ALLSELECTED/ALL Except
• Time Intelligence Functions (Running Total, Rolling Averages, Dates Between, DatesinPeriod, Dateadd,SamePeriod Last Year, Previous Year, Parallel Month and more)
• RANKX
• TOPN
• SWTICH
• Dynamic Titles
• USE Relationship
Hands-On:
What-if analysis by using Parameter
Module 3: Custom Visuals (Overview)
Objective:
Understand the potential of custom visuals to enhance data storytelling.
• Introduction to AppSource and Importing Custom Visuals
• Overview of Use Cases for Custom Visuals
• Guidelines on When & Why to Use Them
Module 4: Live PSX Stock Market Dashboard (Real-Time Insights)
Objective:
Build a dynamic, real-time dashboard for the Pakistan Stock Exchange.
• Connecting to Web Data and APIs (e.g., PSX stock data)
• Data Cleaning and Transformation in Power Query
• Designing Dynamic KPIs and Visuals for:
• Historical Stock Trends
• Candlestick Charts
• Volume & Price Change Analysis
• Top Gainers, Losers, and Volume Leaders
• Implementing Real-Time Refresh Techniques
Hands-On:
Build and Publish a Live PSX Stock Market Dashboard
Course Fee
● Online
$10 or Rs. 2,800/- Total
- Once paid, the fee is non-refundable and non-transferable
Account Details
Bank: Habib Bank Limited
Account Title: AIN GenX
Account No: 5910-70000512-03
IBAN No: PK08 HABB 0059 1070 0005 1203
Faciliators
Irfan Bakaly
Data Analyst
25+ years of experience in Data Analysis
Noor Surani
Tech Entrepreneur
25+ years of experience in Data Analysis
Who this course is for:
Data Analysts, Business Intelligence (BI) Professionals, Excel Power Users Transitioning to Power BI, Data Engineers / ETL Developers, IT and Reporting Managers
Duration
● 1 Month (10 Hours)
Classes
● Online via Zoom
Schedule
- Day: Saturday's Only
- Timing: 02:30 - 05:00 pm (PST)
Starting From
● Saturday, 28 June, 2025
Participants from Top Organizations
Certificates
