IMPLEMENTING DATA MODEL AND REPORT WITH MICROSOFT SQL SERVER® 2014

Modular Course (Select your Modules)

   This course describes how to creates 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.

Introduction (0.5 day)

• Introduction to Business Intelligence and Data Modeling

Multidimensional Model (2 days)

• Creating Multidimensional Databases

• Working with Cubes and Dimensions

• Working with Measures and Measure Groups

• Introduction to MDX

• Customizing Cube Functionality

• Implementing Reports with SQL Server Reporting Services

• Automating Report Execution and Delivery

Reporting Services (1 day)

Tabular Model (1 day)

• Implementing an Analysis Services Tabular Data Model

• Introduction to Data Analysis Expression (DAX)

Additional Topics (0.5 day)

• Delivering BI with SharePoint PerformancePoint Services

• Performing Predictive Analysis with Data Mining