Professional Skills Self Paced

Data Analysis Expressions (DAX)

This course help you to write powerful DAX queries with confidence, work with 150+ DAX functions across real-world scenarios, and build professional-grade Power BI reports — making you job-ready as a Data Analyst or BI Developer.

5.0 (136 ratings)
427 enrolled 10 hours Professional Tamil

What You'll Learn

  • Master DAX Fundamentals & Query Writing
  • Manipulate & Transform Tables Like a Pro
  • Perform Advanced Calculations & Aggregations
  • Unlock Time Intelligence for Business Insights
  • Control Relationships & Filter Context with Confidence
  • Build Job-Ready Skills with 150+ DAX Functions

Requirements

  • Basic Power BI Knowledge
  • Understanding of Data Tables
  • Excel Familiarity
  • Basic Math & Logic

Tools & Technologies

Power BI Power BI
DAX Studio DAX Studio

Course Description

This comprehensive course takes you from the fundamentals of DAX syntax and DAX Studio setup all the way through advanced topics like Time Intelligence, Filter Context, Window Functions, and Relationship Management. With 10+ hours of structured content, you’ll gain hands-on experience with table manipulation, aggregations, logical and text functions, date/time operations, and more — everything you need to write powerful, efficient DAX queries for real-world Power BI data models.

Right for You?

Who This Course is For

  • Aspiring Data Analysts & BI Developers
  • Power BI Users Looking to Level Up
  • Excel Professionals Transitioning to Power BI
  • Business Intelligence & Reporting Professionals

Course Curriculum

15 modules • 144 lessons
Module 1: Introduction to DAX & DAX Studio 3 lessons • 10m 15s
  • Introduction to DAX 3m 35s
  • Introduction to DAX Studio 3m 42s
  • Connect Power BI Data Model 2m 58s
Module 2: DAX Queries Foundation 6 lessons • 44m 7s
  • Evaluate and Select Columns 10m 56s
  • Order By 5m 17s
  • Start At 8m 14s
  • Row 3m 53s
  • Var 8m 25s
  • Define Variable 7m 22s
Module 3: DAX Operators 4 lessons • 48m 6s
  • Arithmetic Operators 12m 45s
  • Comparison Operators 8m 31s
  • Text Concatenation Operator 3m 19s
  • Logical Operator 23m 31s
Module 4: Table Manipulation Functions 19 lessons • 1h 44m
  • Distinct 2m 39s
  • Add Columns 11m 44s
  • Generate Series 2m 7s
  • Data Table 9m 17s
  • Cross Join 4m 22s
  • Generate 8m 8s
  • Generate All 2m 17s
  • Natural Inner Join 3m 27s
  • Natural Outer Join 2m 38s
  • Summarize 4m 44s
  • Rollup 4m 59s
  • Rollup Group 3m 31s
  • Summarize Columns 3m 46s
  • Rollup Is Add SubTotal 4m 7s
  • Add Missing Items 3m 59s
  • Rollup Is SubTotal 5m 46s
  • Summarize 4m 44s
  • Set Operations 14m 9s
  • TopN 7m 53s
Module 5: Aggregate Functions 11 lessons • 32m 23s
  • Count and CountX 4m 45s
  • CountA and CountAX 3m 8s
  • Counting Blank Values 1m 32s
  • Counting Rows 1m 2s
  • Counting Distinct Values 2m 44s
  • Minimum Values 5m 10s
  • Minimum Expression 1m 33s
  • Maximum Values 3m 7s
  • Sum Operations 2m 25s
  • Product Operations 2m 41s
  • Average Operations 4m 16s
Module 6: Logical Functions 10 lessons • 40m 11s
  • AND Operation 3m 12s
  • OR Operation 2m 17s
  • NOT Operation 1m 24s
  • IF Condition 4m 54s
  • True and False 2m 35s
  • If Eager 8m 47s
  • If Error 3m 8s
  • Coalesce 4m 51s
  • Switch with Exact Match 3m 19s
  • Switch with Numerical Comparison 5m 44s
Module 7: Information Functions 17 lessons • 1h 8m
  • Column Statistics 3m 56s
  • Contains 6m 55s
  • Contains Row 1m 41s
  • Contains String 6m
  • Filter and Slicer Simulation (Treat As) 11m 39s
  • Has One Filter 9m 16s
  • Has One Value 1m 28s
  • Is Filtered 4m
  • Is Cross Filtered 4m 6s
  • Text and Non-Text Column 2m 14s
  • Number Odd Even 3m 10s
  • Is Blank 2m 29s
  • Is Error 2m 14s
  • Is Logical 1m 29s
  • Is Empty 1m 11s
  • Is SubTotal 3m 9s
  • Is InScope 3m 50s
Module 8: Math Functions 13 lessons • 22m 6s
  • Division and Modulus 3m 21s
  • Ceiling and Floor 2m 43s
  • Rounding 3m 21s
  • Rounding up and Rounding Down 2m
  • Truncate 1m 13s
  • Rounding to Even 1m 3s
  • Power 1m 28s
  • Square Root 33s
  • Exponential Growth 44s
  • Sign and Absolute Value 1m 13s
  • Factorial 1m 17s
  • GCD and LCM 1m 57s
  • Logarithm 1m 13s
Module 9: Text Functions 13 lessons • 42m 42s
  • Concatenate 8m 29s
  • ConcatenateX 2m 20s
  • Exact 2m 44s
  • Find and Search 3m 48s
  • Fixed 2m 43s
  • Format 6m 37s
  • Value 2m 36s
  • Left, Mid, and Right 3m 12s
  • Length 52s
  • Trim 3m 5s
  • Replace and Substitute 3m 53s
  • Upper and Lower 1m 15s
  • Repeat 1m 8s
Module 10: Date and Time Functions 10 lessons • 25m 56s
  • Date and Time 2m 24s
  • Calendar 2m 25s
  • Calendar Auto 3m 53s
  • Date Difference 3m 3s
  • Date Value 1m 18s
  • Date Extraction 2m 25s
  • Send Notification and Set Due Date 2m 23s
  • Networkdays 4m 16s
  • Current Values 1m 42s
  • Week day 2m 7s
Module 11: Time Intelligence Functions 13 lessons • 52m 3s
  • Date Time Intelligence 6m 7s
  • Closing and Opening Balance of the Month 7m 2s
  • Closing and Opening Balance of the Quarter 2m 31s
  • Closing and Opening Balance of the Year 5m 1s
  • Dates Between 1m 47s
  • Dates in Period 2m 11s
  • Date Add 9m 13s
  • Start and End of Month 3m 37s
  • Start and End of Quarter 2m 39s
  • Start and End of Year 2m 35s
  • First and Last Date 1m 10s
  • Previous and Next 6m 4s
  • Last Year Same Period 2m 6s
Module 12: Parent and Child Functions 4 lessons • 8m 41s
  • Path 2m 21s
  • Path Length 1m 25s
  • Path Item and Reverse 3m 28s
  • Path Contains 1m 27s
Module 13: Relationship Functions 5 lessons • 25m 43s
  • Cross Filter 7m 46s
  • One Way Vs Both 5m 23s
  • Related Column 1m 40s
  • Related Table 4m 36s
  • User Relationship 6m 18s
Module 14: Filter Functions 12 lessons • 1h 8m
  • Calculate 3m 56s
  • Treat As 2m 33s
  • Calculate Table 1m 49s
  • All Voice Update 12m 8s
  • All Cross Filtered 7m 34s
  • All Except 6m 57s
  • All Selected 10m 36s
  • All No Blank Rows 3m 43s
  • Earlier 7m 57s
  • Filter 2m 8s
  • Keep and Remove Filters 7m 15s
  • Lookup Value 1m 57s
Module 15: Window Functions 4 lessons • 36m 10s
  • Index 8m 57s
  • Offset 5m 13s
  • Window 6m 18s
  • Rank 15m 42s
Our Advantage

Why Choose This Course

  • Hands-On Learning with Real Power BI Data Models
  • 150+ DAX Functions Covered in One Place
  • Structured from Beginner to Advanced Level
  • Practical, Job-Ready Skills from Day One

Your Instructor

Parthiban Kannan

Parthiban Kannan

Co-founder & Manager

17 Courses

14+ years of experience in digital transformation, leading teams of 15+ members and delivering 160+ projects for organizations like Lakshmi Machine Works, Milacron, Schneider Electric, Aatomz Research, and Variablz Technologies. AI innovator with a patent approved by the Government of India, with strong expertise in Data Science, Data Analysis, Business Intelligence, and Software Development.

FAQ

Frequently Asked Questions

Do I need prior DAX experience?

No, this course starts from the basics and gradually moves to advanced concepts.

What tools do I need?

Power BI Desktop and DAX Studio u2014 both are free to download.

How many DAX functions are covered?

150+ DAX functions across 14 categories.

Is this course suitable for Excel users?

Yes, Excel users can easily transition into DAX with this course and it helpful to apply on Power Pivot

How long is the course?

Over 10 hours of structured, hands-on content.

Will I learn Time Intelligence functions?

Yes, Time Intelligence is covered in depth including MTD, YTD, and period comparisons.

Is DAX Studio mandatory for this course?

It is highly recommended as the course uses DAX Studio for query practice. But the 95% operations can be done in Power BI also.

Will this help me get a job?

Yes, the course is designed to build job-ready skills for Data Analyst and BI Developer roles.