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




