#Sql business intelligence training how to#

Monitoring and Analysing Analysis Services.

Monitoring and Optimising the Data Warehouse.

Module 10: Monitoring and Optimising a BI SolutionĪt the conclusion of this module, delegates will be able to optimise and monitor a BI solution. Lab: Implementing PerformancePoint Services Lab: Implementing a SharePoint Server BI Solution

Planning Reporting Services Configuration.

Planning Security for a SharePoint Server BI Solution.

Introduction to SharePoint Server as a BI Platform.

This module introduces the use of SharePoint Server as a BI solution. Module 9: Planning a SharePoint Server BI Solution Lab: Designing and Excel Reporting Solution

Using Excel for Data Reporting and Analysis.

#Sql business intelligence training how to#

In this module, delegates will learn how to design a reporting solution using Excel.

Module 8: Designing an Excel-based Reporting Solution Lab: Designing a Reporting Services Solution This module describes how to design a reporting services solution. Module 7: Designing a Reporting Services Solution This module describes how to choose an appropriate delivery solution for a given scenario. Module 6: Planning a BI Delivery Solution Lab: Designing Dimensions and Hierarchies This module describes how to design analytical data models for specific BI scenarios. Module 5: Designing Analytical Data Models This lesson describes how to design an extract, transform, and load (ETL) solution.

Lab: Designing a Data Warehouse Logical Schema This module describes how to design a data warehouse given a set of user requirements. This module describes how to use plan appropriate BI Infrastructure given a set of BI Parameters. Module 2: Planning SQL Server Business Intelligence Infrastructure This module enables delegates to plan the components of a BI Solution. This course includes the following modules: Designing Business Intelligence Solutions with Microsoft SQL Server 2014 Course Outline | M20467