Course Details
Module 1 - Introducing Microsoft SQL Server Analysis Services Multidimensional
This module describes Microsoft SQL Server Analysis Services and the concepts of data warehouses and business intelligence.
The following will be coverd:- Data Warehouses and Data Marts
- Describing Microsoft SQL Server Analysis Services
- Installing Microsoft SQL Server Analysis Services
Module 2 - Microsoft SQL Server Analysis Services Solutions and Projects
This module introduces SQL Server Data Tools and Microsoft SQL Server Analysis Services multidimensional solutions. Data Sources and Data Source Views is also introduced and discussed in this module.
The following will be coverd:- Microsoft SQL Server Analysis Services Mulridimensioan Solutions ini SQL Server Data Tools
- Data sources
- Data Source Views
- Creating a simple Cube
Module 3 – Working with Dimensions
This module describes how to create and configure dimensions and dimension hierarchies in an Microsoft SQL Server Analysis Services multidimensional data model.
The following will be coverd:- Creating Dimensions
- Attributes
- Hierarchies
- Attribute Relationships
Module 4 – Measures and Measure Groups
This module describes measures and measure groups. It also explains how you can use them to define fact tables and associate dimensions with measures.
The following will be coverd:- Measures
- Measure Groups
- Additive, Semi-additive and Non-additive measures
- Advanced Data modelling
Module 5 – Calculations with MDX
This module describes the fundamentals of MDX and explains how to build calculations, such as calculated members and named sets.
The following will be coverd:- MDX Fundamentals
- Simple Calculations
- Named Sets
Module 6 – Enhancing a Cube
This module describes how to enhance a cube with Key Performance Indicators (KPIs), actions, and perspectives, and how to use these in client tools.
The following will be coverd:Module 7 - Storage and Processing
This module describes multidimensional storage and processing. Proactive caching, designing aggregations, and partitioning is also discussed.
The following will be coverd:- MOLAP, ROLAP and HOLAP
- Proactive Caching
- Designing Aggregations
- Partitions
- Processing
Module 8 – Planning and implementing Security
This module describes the Microsoft SQL Server Analysis Services security framework. The module describes how to implement security on different levels in a multidimensional data model.
The following will be coverd:- Introducing Security in Microsoft SQL Server Analysis Services
- Security on the Server Level
- Database Roles
- Security on Dimension and Cell Level
- Dynamic Security
Module 9 - Deployment and Management
This module describes the process of deploying Microsoft SQL Server Analysis Services solutions from the development environment to the production environment. Managing the deployed solution is also described.
The following will be coverd:- Tools for deployment
- Backup/Restore
- Automating and scheduling Management