Available 24/7
Professional Instruction
Free Training Materials
Course Details
Section 1: Introduction to Microsoft SQL Server BI Solution
This section covers key features of a self-service BI solution.
Topics
Overview of self-service BI
Considerations of self-service BI
Microsoft tools for self-service BI
Lab: Exploring an enterprise BI solution
Section 2: SQL Server BI Features with Microsoft SharePoint
This section discusses the key capabilities of SQL Server BI in a SharePoint environment.
Topics
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
Section 3: Operating Analysis Services
This section discusses common analysis services operational tasks.
Topics
Configuring an analysis services server
Tuning an analysis services server
Analysis services security
Analysis services high availability and disaster recovery
Lab: Configuring analysis services
Section 4: Supporting Analysis Services
This section covers PowerPivot for SharePoint server.
Topics
Testing analysis services cubes
Tuning analysis services
Maintaining analysis services
Lab: Supporting Analysis Services
Section 5: Operate and Support Reporting services
This section covers users to Power Query. They will use this more in subsequent sections.
Topics
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
Section 6: Share PowerPivot Workbooks in SharePoint Server
This section covers PowerPivot for SharePoint.
Topics
PowerPivot for SharePoint
Install and configure PowerPivot for SharePoint
Lab: Install PowerPivot for SharePoint
Section 7: Operate and Support Power BI
This section covers Windows Azure HDInsight.
Topics
Power BI desktop
PowerBI.Com
Mobile Power BI
Lab: Using Power BI
Please check the course description to find prerequisite information.
MOC On-Demand: 10988-Managing SQL Business Intelligence Operations
On-Demand Training Course
90/month licence
- 24/7 Access
- Hands-On Practice Exercises
- Free Repeats
- Professional Instruction
Testimonials
This was the class I needed.
The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don't know about the rest of the students, but was very pleased with this experience.
I finally understand how to use Excel.
-Amanda T (Yale New Haven Hospital).
Great class!
We were able to cover a lot of information in one day without getting overwhelmed.
-Maria R (Microsoft).
Free Repeats
Learn At Your Pace
No Travel
Professional Instruction
Affordable Pricing
Group Discounts
