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

Prerequisites

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

• Some basic knowledge of data warehouse schema topology (including star and snowflake schemas)
• Some exposure to basic programming constructs (such as looping and branching)
• An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

• Familiarity with SharePoint Server and Microsoft Office applications ? particularly Excel