Course Outline 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: - Test analysis services
- Tune analysis services
- Maintain analysis services
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: - Describe the capabilities of PowerPivot for SharePoint
- Install and Configure PowerPivot for SharePoint
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: - Install and Configure Power BI desktop
- Implement Power BI dashboards
- Describe mobile power BI
|