Managing SQL Business Intelligence Operations

Master SQL Business Intelligence operations with our comprehensive course designed for BI professionals eager to enhance their capabilities in data analysis and sharing using SQL Server and SharePoint.

Course Thumbnail

Essential Skills Gained

Checkmark

Design self-service BI solutions leveraging key Microsoft tools.

Checkmark

Implement SQL Server BI capabilities within SharePoint environments.

Checkmark

Configure and tune analysis services for high availability and security.

Checkmark

Operate and support Power BI and PowerPivot solutions effectively.

Format

  • Instructor-led
  • 3 days with lectures and hands-on labs.

Audience

  • Business Intelligence Professionals
  • Data Analysts
  • Database Administrators
  • IT Managers

Description

This three-day instructor-led course is aimed at database professionals who manage Business Intelligence (BI) operations. This course looks at various options that provide the ability of business users to analyze data and share their findings, starting with managed BI data sources and expanding to personal and external/public data sources.  

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Module 1: Introduction to Microsoft SQL Server BI Solution

  1. Overview of self-service BI

  2. Considerations of self-service BI

  3. Microsoft tools for self-service BI

Module 2: SQL Server BI Features with Microsoft SharePoint

  1. Capabilities of Power BI with SharePoint

  2. SharePoint with analysis services

  3. SharePoint with reporting services

  4. Deploying SQL server BI in a SharePoint environment

Module 3: Operating Analysis Services

  1. Configuring an analysis services server

  2. Tuning an analysis services server

  3. Analysis services security

  4. Analysis services high availability and disaster recovery

Module 4: Supporting Analysis Services

  1. Testing analysis services cubes

  2. Tuning analysis services

  3. Maintaining analysis services

Module 5: Operate and Support Reporting services

  1. Installing a native mode report server

  2. Installing reporting services with SharePoint

  3. Reporting services with Microsoft Azure virtual machines

  4. Reporting services errors

Module 6: Share PowerPivot Workbooks in SharePoint Server

  1. PowerPivot for SharePoint

  2. Install and configure PowerPivot for SharePoint

Module 7: Operate and Support Power BI

  1. Power BI desktop

  2. PowerBI.Com

  3. Mobile Power BI

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.