MDX Training

In-depth understanding and examples for Microsoft SQL Server Analysis Services (SSAS) Multidimensional Expressions (MDX) Language - to query Multidimensional and Tabular Cubes. The MDX Training course includes over 100 MDX Functions with real-world examples and Report Integrations.

MDX Training Highlights

100+ MDX Functions Nested SubQueries Real-time Scenarios
Common Calculations Time Intelligence Advanced MDX

Pre-requisites: Particiant needs to have (working) knowledge on SSAS

Trainer : Mr Sai Phanindra (11+ Yrs Exp)


Course Fee : 6000/-

Duration : 2 Weeks (Mon - Thu)

 

MDX Training Course Contents:

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 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 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 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 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 and TIME Functions * Using Time Functions with MDX Joins * MEMBERTOSTR * NAMETOSET * ROOT * SETTOSTR * STRTOMEMBER * STRTOSET * STRTOTUPLE * STRTOVALUE * TUPLETOST *

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, 2017 *******

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 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