Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

MS-20466 - Implementing Data Models and Reports with SQL Server

This five-day instructor-led course teaches students how to design and implement a BI infrastructure for enterprise data models and reports. The course discusses design, installation, and operations of a BI platform, including Microsoft SQL Server Analysis Services, SQL Server Reporting Services, and Microsoft SharePoint Server.

Click here to print this page »

Prerequisites


This course requires that you meet the following prerequisites:
  • At least 2 years’ experience of working with relational databases, including:
  • Designing a normalized database.
  • Creating tables and relationships.
  • Querying with Transact-SQL.
  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

Detailed Class Syllabus


Module 1: Introduction to Business Intelligence and Data Modeling


Introduction to Business Intelligence
The Microsoft Enterprise BI Platform

Module 2: Creating Multidimensional Databases


Introduction to Multidimensional Analysis
Creating Data Sources and Data Source Views
Creating a Cube
Overview of Cube Security

Module 3: Working with Cubes and Dimensions


Configuring Dimensions
Defining Attribute Hierarchies
Sorting and Grouping Hierarchies

Module 4: Working with Measures and Measure Groups


Working with Measures
Working with Measure Groups

Module 5: Introduction to MDX


MDX Fundamentals
Adding Calculations to a Cube
Using MDX to Query a Cube

Module 6: Customizing Cube Functionality


Implementing Key Performance Indicators
Implementing Actions
Implementing Perspectives
Implementing Translati

Module 7: Implementing an Analysis Services Tabular Data Model


Introduction to Tabular Data Models
Creating a Tabular Data Model
Using an Analysis Services Tabular Data Model in an Enterprise BI Solution

Module 8: Introduction to Data Analysis Expression (DAX)


DAX Fundamentals
Using DAX to Create calculated Columns and Measures in a Tabular Data Model

Module 9: Implementing Reports with SQL Server Reporting Services


Introduction to Reporting Services
Creating a Report with Report Designer
Grouping and Aggregating Data in a Report
Showing Data Graphically
Filtering Reports Using Parameters

Module 10: Automating Report Execution and Delivery


Managing Report Security
Managing Report Execution
Delivering Reports with Subscriptions and Data Alerts
Troubleshooting Reporting Services

Module 11: Delivering BI with SharePoint PerformancePoint Services


Introduction to SharePoint Server as a BI Platform
Planning Security for a SharePoint Server BI Solution
Planning for PerformancePoint Services

Module 12: Performing Predictive Analysis with Data Mining


Overview of Data Mining
Using the Data Mining Add-in for Excel
Creating a Custom Data Mining Solution
Validating a Data Mining Model
Connecting to and Consuming Data Mining Data