10988A: Managing SQL Business Intelligence Operations

Module 1: Introduction to Microsoft SQL Server BI Solution
This module introduces key features of a self-service BI solution.
Lessons
- Overview of self-service BI
- Considerations of self-service BI
- Microsoft tools for self-service BI
Lab : Exploring an enterprise BI solution
After completing this module, you will be able to:
-
Describe the concept of self-service BI
-
Explain when you would use self-service BI
-
Describe the Microsoft tools for self-service BI
Module 2: SQL Server BI Features with Microsoft SharePoint
This module describes the key capabilities of SQL Server BI in a SharePoint environment.
Lessons
- Capabilities of Power BI with SharePoint
- SharePoint with analysis services
- SharePoint with reporting services
- Deploying SQL server BI in a SharePoint environment
Lab : Design a SQL Server BI infrastructure
After completing this module, you will be able to:
-
Describe the capabilities of Power BI with SharePoint
-
Describe the use of SharePoint with analysis services
-
Describe the use of SharePoint with reporting services
-
Deploy SQL Server in a SharePoint environment
Module 3: Operating Analysis Services
This module describes common analysis services operational tasks.
Lessons
- Configuring an analysis services server
- Tuning an analysis services server
- Analysis services security
- Analysis services high availability and disaster recovery
Lab : Configuring analysis services
After completing this module, you will be able to:
-
Configure the analysis services server
-
Tune the analysis services server
-
Describe the analysis services security
-
Implement analysis services high-availability and disaster recovery
Module 4: Supporting Analysis Services
This module introduces PowerPivot for SharePoint server.
Lessons
- Testing analysis services cubes
- Tuning analysis services
- Maintaining analysis services
Lab : Supporting Analysis Services
After completing this module, you will be able to:
Module 5: Operate and Support Reporting services
This module introduces users to Power Query. They will use this more in subsequent modules.
Lessons
- Installing a native mode report server
- Installing reporting services with SharePoint
- Reporting services with Microsoft Azure virtual machines
- Reporting services errors
Lab : Installing reporting services
After completing this module, you will be able to:
-
Install a native mode reporting server
-
Install reporting services with SharePoint
-
Implement reporting services with Microsoft Azure virtual machines
-
Describe reporting services errors
Module 6: Share PowerPivot Workbooks in SharePoint Server
This module introduces PowerPivot for SharePoint.
Lessons
- PowerPivot for SharePoint
- Install and configure PowerPivot for SharePoint
Lab : Install PowerPivot for SharePoint
After completing this module, you will be able to:
Module 7: Operate and Support Power BI
This module introduces Windows Azure HDInsight.
Lessons
- Power BI desktop
- PowerBI.Com
- Mobile Power BI
Lab : Using Power BI
After completing this module, you will be able to: