Facets Demo New Batches Starting from Saturday... 22-10-2016
Search Course Here

Live Chat
SQL Server 2008 MDX  Online Training

SQL Server 2008 MDX


SQL Server 2008 MDX training teaches attendees the core techniques for using MDX with Analysis Services to deliver high-performance business intelligence solutions.
  • All attendees should have prior experience with SQL Server 2008.
  • It is a 12 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

  • It is a 3 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • Welcome to MDX
    • The Business Intelligence Landscape
    • The Dimensional Model
    • Implementing the Dimensional Model
    • The MDX Language

  • Using the MDX Query Editor
    • SQL Server Management Studio
    • The MDX Query Editor
    • Building a Simple MDX Query
    • Exploring the Step-by-Step Cube
    • Building a More Complex Query

  • Understanding Tuples
    • N-dimensional Space
    • Cube Space
    • Accessing Data with Tuples
    • Understanding Cells
    • Working with Partial Tuples
    • Building Tuples with User-Hierarchies

  • Working with Sets
    • Set Basics
    • Understanding the SELECT Statement
    • Building Sets with Functions
    • Limiting Sets

  • Working with Expressions
    • Expression Basics
    • Calculated Members
    • Building Dynamic Expressions
    • Resolving Contextual Conflicts
    • Building Complex Expressions

  • Building Complex Sets
    • Assembling Ordered Sets
    • Retrieving the First or Last Tuples of a Set
    • Filtering Sets
    • Combining Sets
    • Performing Advanced Set Construction

  • Performing Aggregation
    • Performing Summation
    • Calculating Averages
    • Identifying Minimum and Maximum Values
    • Counting Tuples in Sets

  • Navigating Hierarchies
    • Accessing Immediate Relatives
    • Accessing Extended Relatives
    • Navigating within a Level

  • Working with Time
    • Understanding the Time Dimension
    • Calculating an Accumulating Total
    • Performing Period-over-Period Analysis
    • Combining Time-Based Metrics

  • Enhancing the Cube
    • Understanding the MDX Script
    • Constructing Calculated Members
    • Assembling Named Sets

  • Building Reports
    • Getting Started
    • Connecting to Analysis Services
    • Designing the Dataset
    • Adding Parameters to the Dataset
    • Presenting the Data in the Report
SQL Server 2008 MDX videos will be updated soon
To Watch More Videos Click Here

Flash News

AngularJS New Batch Start From 09th OCT & 10th OCT.

Hadoop Dev New Batch Start From 10th OCT & 11th OCT.

IBM COGNOS TM New Batch Start From 11th OCT & 12th OCT.

Informatica Dev New Batch Start From 12th OCT & 13th OCT.

Mean Stack New Batch Start 13th OCT & 14th OCT.

SAP BODS new Batch Starting From 14th OCT & 15th OCT.

SAP S/4 HANA New Batch Start From 15th OCT & 16th OCT

Tableau New Batch Start From 16th OCT & 17th OCT


Facets Demo Training

Demo Schedule : 08:30P.M EST / 07:30P.M CST / 05:30P.M PST on 21st OCT & 06:00A.M IST on 22nd OCT
Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :