Course Objectives
Business intelligence (BI) is becoming increasingly important for companies of many different sizes and types because of the competitive edge it can help to give them. The combined capabilities of Microsoft SQL Server 2012 and Microsoft SharePoint 2010 make it easier than ever for companies to develop a BI solution that meets their specific needs, provides reduced total cost of ownership (TCO), and achieves a faster time to solution.
Describe the components, architecture, and nature of a BI solution.
Create reports with Reporting Services.
Create reusable report items that simplify self-service reporting.
Manage a reporting infrastructure.
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 PowerPivot.
Use DAX to query a tabular model.
Implement a Tabular Database.
Use Power View to create interactive data visualizations.
Use Data Mining for predictive analysis.
The 10778: Implementing Data Models and Reports with Microsoft SQL Server 2012 Course prepare students for the following Exams
70-466 : Implementing Data Models and Reports with Microsoft SQL Server 2012