MS-10778 - 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012 "Denali"
Course
MS-10778
Price:
$2,795.00
Software Assurance Value:
5
Duration:
5 Days
10778A TS: Implementing Reports and Data Models with Microsoft SQL Server 2012
Audience
The primary audience for this course are database professionals who need to fulfill
BI Developer role to create analysis and reporting solutions. Primary responsibilities
will include:
- Implement reporting solutions by using SQL Server Reporting Services
- Implementing multidimensional databases by using SQL Server Analysis Services
- Creating tabular semantic data models for analysis by using SQL Server Analysis
Services
- Create visualizations of data by using Crescent
-
Create data mining solutions by using SQL Server Analysis Services
Microsoft Certified Professional Exams
This will prepare the student for exam 70-466.
Abstract
This 5-day instructor-led course describes how to empower information workers through
self-service analytics and reporting. Students will learn how to implement PowerPivot
and tabular data models, create and deliver rich data visualizations with Project
Crescent and SQL Server Reporting Services, and discover business insights by using
data mining.
Course Pre-requisites
In addition to their professional experience, students who attend this training
should have technical knowledge equivalent to the following course:
-
10774A: Writing Queries with Microsoft SQL Server Transact-SQL
Content Outline
Module 1: Overview of Reporting and Data Modeling
Module Goal: Describe the components, architecture, and nature of a BI solution
Module 2: Implementing Reports with Reporting Services
Module Goal: Create reports with Reporting Services
Module 3: Supporting Self-Service Reporting
Module Goal: Create reusable report items that simplify self-service reporting.
Module 4: Managing a Reporting Infrastructure
Module Goal: Manage a reporting infrastructure.
Module 5: Creating Multidimensional Databases
Module Goal: Create a multidimensional database with Analysis Services.
Module 6: Working with Cubes and Dimensions
Module Goal: Implement dimensions in a cube.
Module 7: Working with Measures and Measure Groups
Module Goal: Implement measures and measure groups in a cube
Module 8: Introduction to MDX
Module Goal: Use MDX Syntax
Module 9: Customizing Cube Functionality
Module Goal: Customize a cube
Module 10: Implementing a PowerPivot for Excel Workbook
Module Goal: Implement a Tabular Data Model in PowerPivot
Module 11: Introduction to Data Analysis Expression (DAX)
Module Goal: Use DAX to create measures and calculated columns in a tabular data
model
Module 12: Implementing a Tabular Database
Module Goal: Implement a Tabular Database
Module 13: Creating Data Visualizations With Crescent
Module Goal: Use Crescent to create interactive data visualizations
Module 14: Performing Predictive Analysis with Data Mining
Module Goal: Use Data Mining for Predictive Analysis
