| 1. Overview of Data Warehousing and OLAP
|
| 2. Preparing, building and processing a cube
|
| 3. Understanding Analysis Services Architecture
|
| 4. Building shared, private and standard dimensions
|
| 5. Working with levels, hierarchies and time dimensions
|
| 6. Working with cubes and measures
|
| 7. Creating and updating the store expense cube
|
| 8. Managing storage and optimisation
|
| 9. Processing dimensions and cubes
|
| 10.Using partitions to improve both processing and query performance
|
| 11.MDX Foundations
|
| 12.Using MDX Expressions
|
| 13.Retrieving Values from a Cube
|
| 14.Creating Simple MDX Queries
|
| 15.Creating and Manipulating Sets
|
| 16.Using Aggregation Functions
|
| 17.Using Calculated Cells
|
| 18.Implementing calculations using Multi-Dimensional Expressions (MDX)
|
| 19.Working with virtual cubes
|
| 20.Using Excel as an OLAP Client
|
| 21.Using actions, drill through and write back
|
| 22.Implementing security
|
| 23.Deploying an OLAP solution
|
| 24.Introduction to Data Mining |
Top