Developing Data Models using SQL Server Analysis Services

This course is intended for end users, Database Administrators, Database Developers, and BI professionals. 

Module 1: Introduction to Business Intelligence and Data Modeling

•  
• Lesson: Introduction to Business Intelligence
• Lesson: The Microsoft business intelligence platform
• Lab: Exploring a Data Warehouse

Module 2: Creating Multidimensional Databases

•  
• Lesson: Introduction to multidimensional analysis
• Lesson: Creating data sources and data source views
• Lesson: Creating a OLAP cube
• Lesson: Overview of cube security
• Lab: Creating a multidimensional database

Module 3: Working with Cubes and Dimensions

•  
• Lesson: Configuring dimensions
• Lesson: Define attribute hierarchies
• Lesson: Sorting and grouping attributes
• Lab: Working with Cubes and Dimensions

Module 4: Working with Measures and Measure Groups

• Lesson: Working with measures
• Lesson: Working with measure groups
• Lab: Configuring Measures and Measure Groups

Module 5: Introduction to MDX

• Lesson: MDX fundamentals
• Lesson: Adding calculations to a cube
• Lesson: Using MDX to query a cube
• Lab: Using MDX

Module 6: Customizing Cube Functionality

• Lesson: Implementing key performance indicators
• Lesson: Implementing actions
• Lesson: Implementing perspectives
• Lesson: Implementing translations
• Lab: Customizing a Cube

Module 7: Implementing a Tabular Data Model by Using Analysis Services

• Lesson: Introduction to tabular data models
• Lesson: Creating a tabular data model
• Lesson: Using an analysis services tabular model in an enterprise BI solution
• Lab: Working with an Analysis services tabular data model

Module 8: Introduction to Data Analysis Expression (DAX)

• Lesson: DAX fundamentals
• Lesson: Using DAX to create calculated columns and measures in a tabular data model
• Lab: Creating Calculated Columns and Measures by using DAX

Module 9: Performing Predictive Analysis with Data Mining

• Lesson: Overview of data mining
• Lesson: Using the data mining add-in for Excel
• Lesson: Creating a custom data mining solution
• Lesson: Validating a data mining model
• Lesson: Connecting to and consuming a data mining model
• Lab: Perform Predictive Analysis with Data Mining

• Describe the components, architecture, and nature of a BI solution
• Create a multidimensional database with Analysis Services
• Implement dimensions in a cube
• Implement measures and measure groups in a cube
• Use MDX Syntax and customize a cube
• Implement a Tabular Data Model in SQL Server Analysis Services
• Use DAX to enhance a tabular model
• Use data mining

• SQL language
• Basic knowledge of the Microsoft Windows operating system

Classrooms are equipped with high-performance computers with Internet access and the possibility of wireless connection.

All participants will receive internal OKsystem materials.