Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
uk : +44-20-3287-2021
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Wednesday... 26-07-2017
Search Course Here




Live Chat
Support
SQL Server 2008 MDX  Online Training

SQL Server 2008 MDX

overview

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

Corporate
  • It is a 3 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
Classroom
    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
Videos
SQL Server 2008 MDX videos will be updated soon
To Watch More Videos Click Here

Flash News


AngularJS New Batch Start From 14th JULY & 15th JULY.


Hadoop Dev New Batch Start From 15th JULY & 16th JULY.


IBM COGNOS TM New Batch Start From 16th JULY & 17th JULY.


Informatica Dev New Batch Start From 17th JULY & 18th JULY.


Mean Stack New Batch Start 18th JULY & 19th JULY.

SAP BODS new Batch Starting From 19th JULY & 20th JULY.

SAP S/4 HANA New Batch Start From 20th JULY & 21st JULY
.

Tableau New Batch Start From 21st JULY & 22nd JULY

PUBLIC DEMO


(1) Workday Technical Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th JULY & 07:00A.M IST on 14th JULY

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings