| |
|
Cloud Accelerate
Partner
|
|
|
|
|
|
Solving Business Problems with MDX in SQL Server 2008
| | | | Course Number: | SQM-SQLMDX08 | | Length: | 3 Day |  | | Price: | $2,350.00 | | | |
Or Register by Phone 1-888-600-ALTO (2586) |
|
|
|
|
|
| There are no classes scheduled at this time. Please contact 1-888-600-2586 if you are interested in this class. |
|
|
|
|
| | | This hands-on, instructor led course will guide you step-by-step through the Analysis Service 2008 Multi Dimensional eXpression (MDX) OLAP query language. You will learn a practical approach to solve real-world problems using MDX expressions, calculations and queries, which will allow users to extract valuable information. |
|
|
|
|
|
Objectives
Day 1 - Introduction and Basics
Module 01: Introduction to MDX
- Basic Concepts
- Tuples as Address in Cube
- Sets
- LAB 01A: Using Management Studio to Query Data Use BI Development Studio to define Calculations
Module 02: Basic Queries
- Basic Query Syntax
- Basic Calculation
- LAB 02A: Basic Queries
- Basic Calculations
- Key difference to SSAS 2000 MDX (using
- Hierarchies/Attributes)
- Using Tuples
- LAB 02B: Tuples in Calculations
- Tuples in Sets (Dimensionality)
- Review MDX Syntax
Module 03: Navigation in Trees
- Relationships
- LAB 03A: Calculations using Tuples and Relative Tree Navigation
- Conditions using IIF
- Null Handling
- Real World Formulas (Ratios ...)
- Element Name, Uniquename ...
- Review
DAY 2
Module 04: Sets
- Introduction
- Set Functions
- Filter (Search for Items, Filter by values,…)
- TopCount / BottomCount (Show top Customers,...)
- Order
- Aggregation (Sum, Min, Max,...)
- Rank
- LAB 04A: Querying Sets
- Real World Examples
- LAB 04B: Real World Queries
- Speed Issues
- LAB 04C: Sets and Execution Speed
- Review
Module 05: Common Calculations
- Percent Contributions
- Allocations
- LAB 05A: Allocations
- Averages (simple, weighted, moving)
- Time Based References
- LAB 05B: Time Based References
- Aggregations
- Boundary Condition
- LAB 05C: Aggregations
Module 06: Reporting Services
- Introduction
- Limitation for MDX in Reporting Services
- Sub Selects
- Building MDX Based Reports
- Best Practice
- LAB 06A: Queries in Reporting Services
- Parameter Handling
- How To use Parameter / technical details
- depending Parameter
- Practice
- LAB 06B: Parameter Handling in Reporting Services
- Calculations in Reporting Services
Module 07: Security
- Introduction
- Roles
- Dynamic Security (based on UserName)
- LAB 07A: Security
Module 08: KPI
- Introduction
- Examples
- LAB 08A: Using and Defining KPI
Day 3 - Advanced Topics
Module 09: Advanced
- Date Calculation
- String Operations
- LAB 09A: Date and String Handling
- Visual Totals
- Dynamic MDX (STRTOSET() ,...)
- Solve Order / Calculation Pass
- LAB 09B: Dynamic MDX
- Autoexists
- Nonempty Handling
Module 10: Cell Calculations
- Introduction
- Scopes (Session, Query, Cube)
- Real World Solutions
- Planning with Cell Calculations
- LAB 10A: Using Cell Calculations
Module 11: MDX Scripting
- Scope / Sub Cube
- Special Aggregations
- LAB 11A: Using MDX Scripting
Module 12: Optimizing MDX
Module 13: Client Features
- Drill Through
- Actions
- Local Cubes
- Writeback
- LAB 13A: Using Client Features
|
|
|
|
| Or Register by Phone 1-888-600-ALTO (2586) |
|
|
|
|
|
|
|
|
|
|
|
| |
|