Microsoft 20466 – Implementing Data Models and Reports with Microsoft SQL Server

In this course you will learn how to create managed enterprise business intelligence solutions. You will also learn about data modeling by creating multidimensional databases, cubes and dimensions, measures and measure groups, MDX fundamentals, analysis services and Data Analysis Expressions.

Who needs to attend

Who needs to attend?
This course is aimed at database professionals that fill in the role of business intelligence role and database professionals who create analysis and reporting solutions.

what you will learn

What you will learn
Components, architecture and nature of a BI solution
Implement dimensions in a cube
Implement measures and measure groups in a cube
Multidimensional Expressions (MDX) syntax
Cube customization
Implement tabular data model in SQL Server Analysis Services
Enhance a tabular model using DAX
Reporting services
Report enhancement using charts and parameters
Report execution and delivery management
Implement a dashboard in SharePoint Server with PerformancePoint Services
Predictive analysis using data mining


Minimum two years experience with relational databases
Knowledge and skills that include:
Normalized database design
Creating tables and relationships
Querying with Transact-SQL
Data warehouse schema topology, including Star and Snowflake schemas
Basic programming constructs: looping and branching
Key business priorities for revenue, profitability, and financial accounting
Querying Microsoft SQL Server (M20461)
Implementing a Data Warehouse with Microsoft SQL Server (M20463)

Course outline

Course Outline

1. Introduction to Business Intelligence and Data Modeling
Elements of an Enterprise BI Solution
The Microsoft Enterprise BI Platform
Plan an Enterprise BI Project
2. Create Multidimensional Databases
Multidimensional Analysis
Create Data Sources and Data Source Views
Create a Cube
Cube Security
3. Work with Cubes and Dimensions
Configure Dimensions
Attribute Hierarchies
Sorting and Grouping Hierarchies
4. Work with Measures and Measure Groups
Define Fact Tables
Associate Dimensions with Measures
5. Multidimensional Expressions (MDX)
MDX Fundamentals
Add Calculations to a Cube
Using MDX to Query a Cube
6. Enhance a Cube
Implement Key Performance Indicators (KPIs)
Implement Actions, Perspectives, and Translations
7. Implement an Analysis Services Tabular Data Model
Analysis Services Tabular Data Models
Create a Tabular Data Model
Analysis Services Tabular Data Models in the Enterprise
8. Data Analysis Expression (DAX)
DAX Fundamentals
Enhance a Tabular Data Model with DAX
9. Implement Reports with SQL Server Reporting Services
Reporting Services
Create a Report with Report Designer
Grouping and Aggregating Data in a Report
Publish and View a Report
10. Enhance Reports with SQL Server Reporting Services
Show Data Graphically
Filter Reports Using Parameters
Visualizing Data with Power View
11. Manage Report Execution and Delivery
Manage Report Security
Manage Report Execution
Subscriptions and Data Alert
Troubleshoot Reporting Services
12. Deliver BI with SharePoint PerformancePoint Services
SharePoint Server as a BI Platform and PerformancePoint Services
PerformancePoint Data Sources and Time Intelligence
Reports, Scorecards, and Dashboards
13. Perform Predictive Analysis with Data Mining
Data Mining
Create a Data Mining Solution
Validate a Data Model
Consume Data Mining Data

Follow On
Designing Self-Service Business Intelligence and Big Data Solutions (M20467)

Certification Programs
MCSE: Business Intelligence