20466, Implementing Data Models and Reports with Microsoft SQL Server

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

This course is intended for database professionals who need to fulfill a Business Intelligence Developer role to create analysis and reporting solutions.Primary responsibilities include:

• Implementing analytical data models, such as OLAP cubes.
• Implementing reports, and managing report delivery.
• Creating business performance dashboards.
• Supporting data mining and predictive analysis.

Before attending this course, the student should have:

• 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.

 This course helps people prepare for exam 70-466.

After completing this course, students will be able to:

• 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.
• Customize a cube.
• Implement a Tabular Data Model in SQL Server Analysis Services.
• Use DAX to enhance a tabular model.
• Create reports with Reporting Services.
• Enhance reports with charts and parameters.
• Manage report execution and delivery.
• Implement a dashboard in SharePoint Server with PerformancePoint Services.
• Use Data Mining for Predictive Analysis.

Module 1: Introduction to Business Intelligence and Data Modeling

Elements of an Enterprise BI Solution
The Microsoft Enterprise BI Platform
Planning an Enterprise BI Project

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 Dimensions

Configuring Dimensions
Defining Attribute Hierarchies
Sorting and Grouping Attributes

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: Enhancing a Cube

Working with Key Performance Indicators
Working with Actions
Working with Perspectives
Working with Translations.

Module 7: Implementing an Analysis Services Tabular Data Model

Introduction to Analysis Services Tabular Data Model
Creating a Tabular Data Model
Using an Analysis Services Tabular Data Model in the Enterprise

Module 8: Introduction to DAX

DAX Fundamentals
Enhancing a Tabular Data Model with DAX

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
Publishing and Viewing a Report

Module 10: Enhancing Reports with SQL Server Reporting Services

Showing Data Graphically
Filtering Reports by Using Parameters

Module 11: Managing Report Execution and Delivery

Managing Report Security
Managing Report Execution
Subscriptions and Data Alerts
Troubleshooting Reporting Services

Module 12: Delivering BI with SharePoint PerformancePoint Services

Introduction to SharePoint Server as a BI Platform
Introduction to PerformancePoint Services
PerformancePoint Data Sources and Time Intelligence
Reports, Scorecards, and Dashboards

Module 13: Performing Predictive Analysis with Data Mining

Overview of Data Mining
Creating a Data Mining Solution
Validating a Data Mining Model
Consuming a Data Mining Data

Infero Training Ltd is based in the Lace Market in Nottingham. Training courses take place at the following locations including Nottingham, Derby, Loughborough, Mansfield, Chesterfield, Burton-on-Trent, Lincoln, Leicester, Sheffield, Stoke-on-Trent, Tamworth, Wolverhampton, Walsall, Birmingham, Solihul, Coventry, Nuneaton, Peterborough, Grantham.