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
|