Advanced DAX Queries - தமிழில்
Become a DAX expert with our comprehensive, hands-on course designed to take you from beginner to pro in Power BI and DAX Studio.
₹999.00 ₹1999.00 50% OFF
/CourseBundles(51826)/3627281-Advanced_DAX_-_Tamil.png)
Master Advanced DAX Like a Pro!
Unlock the full potential of DAX with our world’s first Hybrid Course! Learn at your own pace with recorded lessons and get real-time guidance in live Q&A sessions.
Learn Advanced DAX Techniques
Dive deep into powerful DAX functions, calculations, and optimizations
Solve Real-World Business Problems
Apply DAX to real-world datasets and enhance your analytical skills.
Live Q&A with Experts
Get your doubts cleared instantly in interactive live sessions.
Dedicated Placement Support
Exclusive Career Guidance with Job & Internship Opportunities
Course Syllabus
1 Subject
Advanced DAX (Pre-Booking)
298 Learning Materials
Introduction to DAX & DAX Studio
Pre-requisites
DAX Introduction
DAX Studio - Introduction
Course Data - AdventureWorks Sales - Microsoft
Connecting to Power BI Data Model
DAX Queries - Foundation
EVALUATE
Query - EVALUATE
ORDER BY
Query - ORDER BY
START AT
Query - START AT
ROW
Query - ROW
VAR - Introduction
Query - VAR Introduction
DEFINE VARIABLES
Query - DEFINE VARIABLES
DAX Operators
Arithmetic Operations
Query - Arithmetic Operators
Comparison Operators
Query - Comparison Operators
Text Concatenation Operator
Query - Text Concatenation Operator
Logical Operators
Query - Logical Operators
Table Manipulation Functions
Data for Table Manipulation
Distinct Function
Query - DISTINCT
Add Columns
Query - ADDCOLUMNS
Generate Series
Query - GENERATE SERIES
Creating Data Table
Query - DATATABLE
Cross Join or Cartesian Join
Query - CROSSJOIN
Generate - Combining Tables based on LEFT Table
Query - Generate
Generate All
Query - Generate All
Natural Inner Join
Query - Natural Inner Join
Natural Left Outer Join
Query - Natural Left Outer Join
Summarize
Query - Summarize
Rollup
Query - Rollup
Rollup Group
Query - Rollup Group
Summarize Columns
Query - Summarize Columns
Rollup Add Is SubTotal
Query - Rollup Add Is Subtotal
Add Missing Items
Query - Add Missing Items
Rollup Is SubTotal
Query - Rollup Is SubTotal
SET Operations - Except, Union & Intersect
Query - SET Operations - Except, Union & Intersect
Top N
Query - Top N
Aggregate Functions
Practice Data for Aggregate Functions
Count and CountX
Query - Count and CountX
CountA and CountAX
Query - CountA and CountAX
Counting Blank Values
Query - Counting Blank Values
Counting Rows
Query - Counting Rows
Counting Distinct Values
Query - Counting Distinct Values
Finding Minimum Values
Query - Finding Minimum Values
Finding Minimum Values with Expression
Query - Finding Minimum Values with Expression
Finding Maximum Values
Query - Finding Maximum Values
Sum Operations
Query - SUM Operations
Product Operations
Query - Product Operations
Average Function
Query - Average Function
Logical Function
Data For Logical Function
AND Operation
Query - AND Operation
OR Operation
Query - OR Operation
NOT Operation
Query - NOT Operation
IF Condition
Query - IF Condition
True and False
Query - True and False
IF.Eager Function
Query - IF.Eager Function
If Error
Query - If Error Function
COALESCE Function
Query - COALESCE Function
Switch with Exact Match
Query - Switch with Exact Match
Switch with Numerical Value Comparison
Query - Switch with Numerical Value Comparison
Information Function
Data For Information Functions
Analyze Column Statistics
Query - COLUMNSTATISTICS
Contains
Query - CONTAINS()
Contains ROW
Query - CONTAINSROW
Contains String
Query - CONTAINSSTRING() & CONTAINSSTRINGEXACT()
Filter and Slicer Simulation
Query - Filter and Slicer Simulation
Has One Filter
Query - HASONEFILTER
Has One Value
Query - HASONEVALUE
Check the Column has Applied Filters
Query - ISFILTERED
Check the Table Filtered by Other Tabular Column
Query - ISCROSSFILTERED
Text and Non-Text Values
Query - ISTEXT() and ISNONTEXT()
Number, Odd or Even
Query - ISNUMBER, ISODD, ISEVEN
Find Missing Values
Query - ISBLANK
Find Error Values
Query - ISERROR
Find out Logical Values
Query - ISLOGICAL
Find Empty Tables
Query - ISEMPTY
Find sub total rows
Query - ISSUBTOTAL
Find the scope of hierachy w.r.t rows
Query - ISINSCOPE
Math & Trig Functions
Data For Practice
Division and Modulus
Query - Divide and Modulus
Ceiling and Floor
Query - Ceiling and Floor
Rounding
Query - Rounding
Rounding Up and Down
Query - Rounding Up and Down
Truncate
Query - Truncate
Rounding to Even
Query - Rounding to Even
Power
Query - Power
Square Root
Query - SQRT
Exponential Growth
Query - Exponential Growth
Sign and Absolute Value
Query - Sign and Absolute Value
Factorial
Query - Factorial
GCD & LCM
Query - GCD & LCM
Logarithm
Query - Logarithm
Text Functions
Data For Practice - Text Functions
Concatenate and Combine Values
Query - Concatenate and Combine Values
ConcatenateX
Query - CONCATENATEX
Exact Comparison
Query - EXACT
Find and Search
Query - Find and Search
Fixed
Query - FIXED
Formatting Text
Query - FORMAT
VALUE
Query - VALUE
Left, Mid and Right Split
Query - LEFT, MID and RIGHT
Length of Text
Query - LENGTH
Trimming White Spaces on Prefix and Suffix
Query - TRIM
Replace and Substitute
Query - REPLACE and SUBSTITUTE
Upper and Lower Case Conversion
Query - UPPER and LOWER
Repeat Text
Query - REPT
Date & Time Functions
Practice Data for Date Time Functions
Date and Time
Query - DATE and TIME
Calendar
Query - Calendar
Calendar Auto
Query - Calendar Auto
Date Difference
Query - Date Difference
Date Value
Query - Date Value
Date Extraction
Query - Date Extraction
EDate and EOMonth
Query - EDate and EOMonth
Total Working Days
Query - NETWORKDAYS
Current Values
Query - Current Date and Time
Week Day
Query - Weekday
Time Intelligence Functions
Data For Practice - Time Intelligence
DateTable for Time Intelligence
Query - DateTable for Time Intelligence
Closing and Opening Balance of the Month
Query - Closing and Opening Balance of the Month
Closing and Opening Balance of the Quarter
Query - Closing and Opening Balance of Quarter
Closing and Opening Balance of the Year
Query - Closing and Opening Balance of the Year
Dates Between Two Given Dates
Query - Dates Between
Dates From a Given Date and A Period
Query - DATESINPERIOD
Shifting Dates Forward and Backward
Query - DATESADD
Start and End of Month
Query - Start and End of Month
Start and End of Quarter
Query - Start and End of the Quarter
Start and End of the Year
Query - Start and End of the Year
First and Last Date
Query - First and Last Date
Previous and Next
Query - Previous and Next
Same Period and Last Year
Query - Same Period Last Year
Parent & Child Functions
Practice Data
Path
Query - PATH
Path Length
Query - Path Length
Path Item and Path Reverse Item
Query - PATHITEM, PATHREVERSEITEM
Path Contains
Query - Path Contains
Relationship Functions
Data for Practice - Relationship Functions
Cross Filter
Query - Cross Filter
Cross Filter - OneWay Vs Both
Query - ONEWAY, BOTH
Related Column Values
Query - RELATED
Related Table Values
Query - RELATED TABLE
Use Relationship
Query - Use Relationship
Filter Functions
Data for Practice - Filter Functions
Calculate
Query - CALCULATE
Treat As
Query - TREATAS
Calculate Table
Query - CALCULATETABLE
All Values From the Column or Table
Query - ALL
All Values Ignoring Cross Filters
QUERY - ALLCROSSFILTERED
All Except
Query - ALLEXCEPT
All Selected
Query - ALLSELECTED
All but No Blank Rows
Query - ALLNOBLANKROWS
Earlier
Query - EARLIER / EARLIEST
Filter Rows
Query - FILTER
Keep and Remove Filters
Query - KEEPFILTERS, REMOVEFITLERS
Lookup Value
Query - LOOKUPVALUE
Window Functions
Data For Practice - Window Functions
Index
Query - INDEX | ORDERBY | PARTITIONBY
Offset
Query - OFFSET | ORDERBY | PARTITIONBY
Window
Query - WINDOW | ORDERBY | PARTITIONBY
Rank
Query - RANK
Acknowledgment Form
Acknowledgment Form
Real-Time Technical Support
Experience seamless technical support like never before with our dedicated Discord platform
Connect directly with trainer, fellow learners, and industry experts in real-time.
Why it works for you?
Our Advanced DAX program provides in-depth knowledge of each function using real-world datasets for practical understanding. Plus, our placement support helps you land your dream job.
Learn everything from foundational concepts to advanced techniques, giving you the skills to confidently write complex DAX queries in தமிழ் (Tamil) Language
Study at your own pace, anytime and anywhere, with lifetime access to recorded lessons and resources
We provide real-world practice datasets and queries, giving you hands-on experience to reinforce your learning and build confidence.
With our dedicated placement guidance, we support and refer committed students to secure their dream jobs.
Become a Confident Business Analyst!
Writing DAX queries is not simple, and that's why it's a primary requirement for many Business Analyst jobs.
Learning DAX in the right order helps you understand how to solve complex problems, and with out placement guidance you can easily reach your destination which is why you must take this course.
Ratings & Reviews
4.9 /5
8 ratings
●
7 reviews
5
4
3
2
1
Frequently asked questions
Have questions? We’ve got you covered! Explore the most common queries about the course, from prerequisites to certification, and get all the details you need to start your journey toward mastering Advanced DAX.
Who is this course for?
Do I need prior knowledge of DAX to take this course?
Do I get Placement Support?
How can I clear my queries during the course?
How long will I have access to the course materials?
Will I get a certificate after completing the course?
Is this course suitable for someone switching careers?
How can I enroll in the course?
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy