The focus of this five-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft® SQL Server® Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
At the end of the program, the participants will be able to :
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:
This program is 5 days of intensive training class.
This course requires that you meet the following prerequisites:
At the end of the program, the participants will be assessed with 2 hours of Implementing Data Models and Reports with Microsoft® SQL Server®Exam.
-
Lab : Exploring a BI Solution
Lab : Creating a Multidimensional Database
Lab : Working with Cubes and Dimensions
Lab : Configuring Measures and Measure Groups
Lab : Using MDX
Lab : Customizing a Cube
Lab : Implementing an Analysis Services Tabular Data Model
Lab : Creating Calculated Columns and Measures by using DAX
Lab : Creating a Report with Report Designer
Lab : Implementing Report Subscriptions
Lab : Implementing PerformancePoint Services
Lab : Using Data Mining to Support a Marketing Campaign