MOC 20466 Implementing a Data Model and Reports with Microsoft SQL Server

Kurz Implementace datových modelů a reportů v Microsoft SQL Server 2014 je zaměřen na návrh a nasazení BI infrastruktury v podnikovém prostředí. Jednotlivá témata obsahují postupy pro návrh, instalaci a nasazení služeb jako SQL Server Analysis a Reporting Services včetně spolupráce s Microsoft SharePoint Server.

Obsah školení

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.

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.