Managing SQL Business Intelligence Operations (10988)

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

Now you can build Microsoft technical experience while balancing the demands of your schedule. MOC On-Demand combines high-quality video, reading, live hands-on labs and knowledge checks in a self-paced format to help you build skills on Microsoft technologies as you schedule allows – all at once or five minutes at a time. The modular, self-directed course structure adapts to your learning needs and learning style.

Brought to you by the people who write the software, Microsoft Official Courses On-Demand are only available through certified Microsoft Learning Partners like Tandem Solution.

Our On-Demand Solution Includes all of the following:

• 90-day access to training videos
• 90-day access to hands-on labs
• 90-day access to exercises
• Knowledge Checks

The benefits of our On-Demand solution are: 

• MICROSOFT OFFICIAL: The content is based on the same official courseware used in instructor-led training and maps to the MOC flow
• LIVE HANDS-ON LABS: Unlike other on-demand offerings that offer simulated labs, MOC On-Demand gives you a live, real-time environment for hands-on learning
• SELF-PACED LEARNING: With MOC On-Demand, you can build deep technical skills on a range of Microsoft technologies when you choose, where you choose
• HIGH-QUALITY CONTENT: The high-quality videos offer in-depth technical content delivered by engaging instructors
• IMMEDIATE FFEDBACK: Knowledge checks at the end of each module and each course tells you whether you’ve mastered the content and are ready to move on

On-Demand Add-ons:

• Lifetime eBook available at an additional cost
• 180 day access available at an additional cost

*SATV Vouchers are accepted