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

Workday HCM Demo New Batches Starting from Wednesday... 14-12-2016
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 09th DEC & 10th DEC.


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


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


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


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

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

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

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

PUBLIC DEMO


(1) Workday Technical Demo Training

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

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