MDX & DAX Training

This course includes In-depth understanding and examples for MDX (Multidimensional Expression Language) and Data Analysis Expressions (DAX) applicable for Microsoft SQL Server Analysis Services (SSAS) and Power BI.

Trainer : Mr. Sai Phanindra T (11+ Yrs EXP). Profile

Timings (IST) Free Demo Start Date Register
1 8 PM to 9:30 PM Sep 20th Sep 21st Register
 
If above schedule does not work for you, then please find below options :

Option 1: On-demand Training Videos from latest LIVE Training. Details

Option 2: Interactive Training from other experienced faculty (Click here)

PROGRAM & COURSE HIGHLIGHTS


Daily Tasks & Lab Real-time Examples
Common Calculations Time Intelligence
Gateways Resume Guidance
Total Course Fee: USD 100, payable in two equal installments.

All Trainings are completely practical and real-time.
 

MDX & DAX Training Course Contents:

Module I : MDX Course Training

Module II : DAX Course Training

DAY 1

  • MDX Fundamentals
  • Real-time Usage of MDX Language
  • MDX Queries,MDX Expressions,MDX Constructs
  • MDX Implementations with OLAP Databases
  • Internal Working of MDX Queries
  • Multidimensional Mode and Tabular Mode Cubes
  • Furmula Engine and Straige Engine Components for MDX Query Processing
  • MDX Query Parser
  • Attribute Store and Hierarchy Store
  • Fact Data and Aggregations
  • Vertipaq Storage for MDX Processing (SSAS Tabular Mode)
  • Client libraries for MDX Query Executions
  • ADOMD.NET, SMOP and OLE DB (MSOLAP.dll)
  • Protocol Usage for MDX Queries in SSMS and SSDT Tools
  • Basic MDX Query Format * AXIS Options and Usage
  • Axis Aliases : Columns, Rows, Pages,
  • Section and Chapter
  • MDX Quries with MEMBERS, CHILDREN, All, PARENT,ORDERBY, BETWEEN, EXCEPT, CROSSJOIN Options and Cube Slice

DAY 1

  • DAX Syntax Specification for Power Pivot
  • DAX Operator Reference for Power Pivot
  • Parameter-Naming Conventions
  • Understanding Functions for Parent-Child Hierarchies in DAX
  • DAX Function Reference
  • DAX Queries
  • DAX Query Syntax Reference
  • Parameters for DAX Queries
  • Date and Time Functions
  • Time Intelligence Functions
  • CLOSINGBALANCEMONTH Function
  • CLOSINGBALANCEQUARTER Function
  • CLOSINGBALANCEYEAR Function
  • DATEADD Function,DATESBETWEEN Function
  • DATESINPERIOD Function,DATESMTD Function
  • DATESQTD Function,DATESYTD Function
  • ENDOFMONTH Function,ENDOFQUARTER Function
  • ENDOFYEAR Function,FIRSTDATE Function
  • FIRSTNONBLANK Function
  • LASTDATE Function,LASTNONBLANK Function

DAY 2

  • Dimension Types : Private and Shared Dimensions
  • Dimension Usage with MDX
  • WHERE versus FILTER
  • TUPLE and SET Representations with Examples
  • Members and Member Sets
  • Named Sets,Member Names,UNION and SET Operations
  • UNION with ALL Flag
  • NON EMPTY and NONEMPTY Functions
  • Granular Control
  • ORDER with FILTER, LEFT and TOP Functions
  • Member Validity with Slices, Filters and Axis
  • ROOT Function,Tuple Expressions
  • DESCENDANTS Function,Level Expressions
  • Member Sets with Numeric and Distance Attributes
  • SELF, AFTER, BEFORE,SELF_BEFORE_AFTER
  • SELF_AFTER_BEFORE, SELF_AND_BEFORE
  • SELF_AND_AFTER, TOP, HEADCOUNT, TOPCOUNT

DAY 2

  • NEXTDAY Function,NEXTMONTH Function
  • NEXTYEAR Function,OPENINGBALANCEMONTH Function
  • OPENINGBALANCEQUARTER Function
  • OPENINGBALANCEYEAR Function
  • PARALLELPERIOD Function
  • PREVIOUSDAY Function
  • PREVIOUSMONTH Function
  • PREVIOUSQUARTER Function
  • PREVIOUSYEAR Function
  • SAMEPERIODLASTYEAR Function
  • STARTOFMONTH Function
  • STARTOFQUARTER Function,BLANK Function
  • CONCATENATE Function,EXACT Function
  • FIND Function,FIXED Function,FORMAT Function
  • Pre-Defined Numeric Formats for the FORMAT Function
  • Custom Numeric Formats for the FORMAT Function
  • Pre-defined Date and Time formats for the FORMAT Function

DAY 3

  • ADDCALCULATEDMEMBERS
  • Set Level and Member Level Functions
  • BOTTOMSUM and TOPSUM Functions
  • BOTTOMCOUNT and TOPCOUNT Functions
  • TOPPERCENT and BOTTOMPERCENT Functions
  • NONEMPTY and CROSSJOIN Functions
  • NONEMOTYCROSSJOIN Function
  • EXTRACT with NONEMPTY FUNCTIONS
  • ASCENDANTS and DESCENDANTS Functions
  • UNION and INTERSECT Functions
  • EXISTS,EXCEPT,EXTACT
  • FILTER HIERARCHIZE FUNCTIONS
  • Descendants Distinct
  • HEAD and TAIL Functions
  • GENERATE ORDER
  • STRIPCALCULATEDMEMBERS
  • MEASUREGROUPMEASURES
  • STRIPCALCULATEDMEMBERS
  • SUBSET and UNORDER Functions
  • MEMBERTOSTR and STRTOSET

DAY 3

  • Custom Date and Time formats for the FORMAT Function
  • LEFT Function,LEN Function
  • LOWER Function,MID Function
  • REPLACE Function,STARTOFYEAR Function
  • TOTALMTD Function,TOTALQTD Function
  • TOTALYTD Function,DATE Function
  • DATEVALUE Function,DAY Function
  • EDATE Function,EOMONTH Function
  • HOUR Function,MINUTE Function
  • MONTH Function,NOW Function
  • SECOND Function,TIME Function
  • TIMEVALUE Function,TODAY Function
  • WEEKDAY Function,WEEKNUM Function
  • YEAR Function,YEARFRAC Function
  • Filter Functions,ALL Functionv
  • ALLEXCEPT Function
  • ALLNOBLANKROW Function
  • ALLSELECTED Function
  • CALCULATE Functionv
  • CALCULATETABLE Function

DAY 4

  • KPI FUNCTIONS : KPIGOAL,KPIVALUE,KPISTATUS,KPITREND
  • NON KPI MEAUSRES WITH KPI MEASURES IN A SET
  • METADATA FUNCTIONS : AXIS SetToStr COUNT (Dimension)
  • COUNT (Hierarchy Levels)
  • COUNT (Tuples),HIERARCHY,LEVEL,LEVELS,NAME
  • UNIQUENAME, ORDINAL,ANCESTOR
  • ANCESTORS,ASCEDANTS,CHILDREN
  • COUSIN,CURRENT,CURRENTMEMBER,CURRENTORDINAL
  • DATAMEMBER,DEFAULTMEMBER
  • FIRSTCHILD,FIRSTSIBLING,ISANCESTOR
  • ISGENERATION,ISLEAF,ISSIBLING,LAG
  • LASTCHILD,LASTSIBLING,LEAD,LINKMEMBER
  • LOOKUPCODE,NEXTMEMBER
  • PARENT,PREVMEMBER,PROPERTIES
  • SIBLINGS,UNKNOWNMEMBER Functions

DAY 4

  • DISTINCT Function,EARLIER Function
  • EARLIEST Function,FILTER Function
  • FILTERS Function,HASONEFILTER Function
  • Math and Trig Functions,ABS Function
  • CEILING Function,CURRENCY Function
  • EXP Function,FACT Function,FLOOR Function
  • INT Function,ISOCEILING Function,LN Function
  • LOG Function,LOG10 Function,MOD Function
  • MROUND Function,PI Function,POWER Function
  • RANKX Function,ROW Function,STDEVS Function
  • STDEVP Function,STDEVXS Function,STDEVXP Function
  • SUMMARIZE Function,TOPN Function,VARS Function
  • VARP Function,VARXS Function,VARXP Function
  • Text Functions,RIGHT Function,SEARCH Function
  • SUBSTITUTE Function,TRIM Function,UPPER Function

DAY 5

  • MDX TIME FUNCTIONS : OPENINGPERIOD
  • PARALLELPERIOD
  • PERIODSTODATE
  • CLOSINGPERIOD
  • LASTPERIODS,QTD,WTD,YTD,MTD
  • Calculating Running Totals using PERIODSTODATE and Aggregates
  • MDX concepts SIBLING, PARALLE PERIODS AND CHILDREN
    (FIRST CHILD, LAST CHILD, FIRST MEMBER, LAST MEMBER)
  • AGGREGATE,SUM,AVG
  • COALESCEEMPTY,CORRELATION
  • COUNT (SET),DISTINCTCOUNT
  • MAX,MIN,RANK,MEDIAN,this Scope
  • USERNAME MDX Sub Queries with Aggregations & TIME Functions
  • Using Time Functions with MDX Joins
  • MEMBERTOSTR,NAMETOSET,ROOT
  • SETTOSTR,STRTOMEMBER,STRTOSET
  • STRTOTUPLE,STRTOVALUE,TUPLETOST

DAY 5

  • VALUE Function,Formula Compatibility in DirectQuery Mode
  • HASONEVALUE Function,ISCROSSFILTERED Function
  • ISFILTERED Function,KEEPFILTERS Function
  • RELATED Function,RELATEDTABLE Function
  • USERELATIONSHIP Function,VALUES Function
  • Information Functions,CONTAINS Function
  • CUSTOMDATA Function,ISBLANK Function
  • ISERROR Function,ISLOGICAL Function
  • ISNONTEXT Function,ISNUMBER Function
  • ISTEXT Function,LOOKUPVALUE Function
  • PATH Function,PATHCONTAINS Function
  • PATHITEM Function,PATHITEMREVERSE Function
  • PATHLENGTH Function,USERNAME Function
  • Logical Functions,AND Function
  • FALSE Function,IF Function 180
  • IFERROR Function,NOT Function
  • OR Function,SWITCH Function,TRUE Function,QUOTIENT Function

DAY 6

  • UserName,Leaves,This ClosingPeriod
  • LastPeriods,Mtd,OpeningPeriod
  • ParallelPeriod,PeriodsToDate,Qtd
  • Wtd,Ytd,KPICurrentTimeMember
  • KPIGoal,KPIStatus,KPITrend,KPIValue
  • KPIWeight,IIf,IsEmpty,MemberValue
  • ValidMeasure,Value

More details to be added by Sep 16th,

DAY 6

  • RAND Function,RANDBETWEEN Function,ROUND Function
  • ROUNDDOWN Function,ROUNDUP Function,SIGN Function
  • SQRT Function,SUM Function,SUMX Function,TRUNC Function
  • Statistical Functions,ADDCOLUMNS Function
  • AVERAGE Function,AVERAGEA Function,AVERAGEX Function
  • COUNT Function,COUNTA Function
  • COUNTAX Function,COUNTBLANK Function
  • COUNTROWS Function,COUNTX Function

Register Today

Register Today  Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses
All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and 24x7 LIVE Server.
 

MDX & DAX Training - Highlights :

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews, Certifications
  • Certification & Interview Guidance
 
 
  • Detailed Formula Engine with MDX
  • Basic to Advanced MDX Functions
  • MDX Integration with MSBI SSAS
  • MDX Integration with Power BI, Excel
  • MDX Constructs with Time Intelligence
  • Advanced MDX with Nested Sub Queries

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer: Mr. Sai Phanindra T