MOC 10988 – Managing SQL Business Intelligence Operations

MOC 10988 – Managing SQL Business Intelligence Operations

This BI course, Microsoft course 10988: Managing SQL Business Intelligence Operations, teaches business users how to analyze data and share their findings. The course starts with managed BI data sources and then expands to personal and external/public data sources.

BI TRAINING OBJECTIVES

All students will be able to describe:

• Key features of a self-service BI solution
• The key capabilities of SQL Server BI in a SharePoint environment
• Common Analysis Services operational tasks
• PowerPivot for SharePoint server
• Power Query
• Windows Azure HDInsight

BI TRAINING PREREQUISITES

In addition to their professional experience, students 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

BI TRAINING MATERIALS

All SQL Server 2016 training students receive Microsoft official courseware.

SOFTWARE NEEDED FOR EACH PC:

Attendees will not need to install any software on their computer for this class. The class will be conducted in a remote environment that Accelebrate will provide; students will only need a local computer with a web browser with a stable Internet connection. Any recent version of Internet Explorer, Mozilla Firefox, or Google Chrome will be fine.

When you call us about purchasing this class, we will provide a live demo of the online lab environment so that you may explore the web browser interface in more detail.

For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.

BI TRAINING OUTLINE

• Introduction to Microsoft SQL Server BI Solution
  • Overview of self-service BI
  • Considerations of self-service BI
  • Microsoft tools for self-service BI
• SQL Server BI Features with Microsoft SharePoint
  • Capabilities of Power BI with SharePoint
  • SharePoint with analysis services
  • SharePoint with reporting services
  • Deploying SQL server BI in a SharePoint environment
• Operating Analysis Services
  • Configuring an analysis services server
  • Tuning an analysis services server
  • Analysis services security
  • Analysis services high availability and disaster recovery
• Supporting Analysis Services
  • Testing analysis services cubes
  • Tuning analysis services
  • Maintaining analysis services
• Operate and Support Reporting services
  • Installing a native mode report server
  • Installing reporting services with SharePoint
  • Reporting services with Microsoft Azure virtual machines
  • Reporting services errors
• Share PowerPivot Workbooks in SharePoint Server
  • PowerPivot for SharePoint
  • Install and configure PowerPivot for SharePoint
• Operate and Support Power BI
  • Power BI desktop
  • PowerBI.Com
  • Mobile Power BI
• Conclusion