This course is designed to teach experienced SQL Server DBAs and database developers how to develop Business Intellegence (BI) solutions using Microsoft SQL Server Analysis Services (SSAS). The course shows how to use SQL Server Management Studio and Microsoft Visual Studio to develop BI solutions.
Analysis Services Concepts
Data Sources and Data Source views. Dimensions. Measures and Measure Groups. Cubes. The Unified Dimension Model (UDM). Upgrading and migrating to Analysis Services.
Analysis Services Projects
Using Business Intellegence Development Studio and the Visual Studio Integrated Development Environment. Creating a Data Source and a Data Source View. Using Data Source View properties.
Building a Cube
The Cube Wizard. Selecting a Build method. Specifying Fact and Dimension Tables. Specifying Time Periods. Measures. Using Dimension Hierarchies. Deploying a Cube.
Advanced Cube Features
Adding Business Intelligence to a Cube. Key Performance Indicators. Translations, Perspectives and Actions. User Defined Functions.
Roles, Groups and Permissions
User Authentication. Granting Administrative and User Access. Granting Permissions to Roles.
Managing Analysis Services
Configuration. Backing up and restoring an Analysis Services database. Processing a cube including Scheduling. Optimizing Analysis Services performance.
Partitions and Real-time BI
Creating a new Partition. Managing Partitions. Using Proactive Caching.
Multi-dimensional Expressions (MDX)
Overview of MDX scripts. Storing calculations within a cube. Scripting scope and context elements. Variables and Parameters. Handling Exceptions.
Other Programming Features
XML for Analysis (XMLA), ADOMD.NET and Analysis Management Objects (AMO). Analysis Services Scripting Language (ASSL).
Data Mining Models and DMX
Overview of different Data Mining Models. Creating a Data Mining Structure. The Data Mining Designer. Data Mining Extensions (DMX).
Questions and Answers
This is an advanced SQL Server course and is designed for existing SQL Server programmers, DBAs and IT Managers.
To understand the setup of Analysis services. To be able to work with the Cube wizard. To add Business Intelligence features to the cube wizard. To understand role and group permissions. To be able to back and restore the database.
