Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

MS-10988 - Managing SQL Business Intelligence Operations

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.

Click here to print this page »

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

Detailed Class Syllabus


Module 1: Introduction to Operational Management in BI Solutions


Rationale for BI Operations
Roles in BI Operations
Technologies Used in BI Operations
Environment and Operational Standards

Module 2: Configuring BI Components


The Importance of Standardized Builds
Configuration Considerations for BI Technologies
BI Architectures
SharePoint BI Environments

Module 3: Managing Business Intelligence Security


Security Approach to BI Solutions
Security Components
Security Approach for BI Components
The Security Approach in Different BI Environments

Module 4: Deploying BI Solutions


Application Life Cycle Management for BI Solution
Stand-Alone Deployments
Team-Based Deployments

Module 5: Logging and Monitoring in BI Operations


The Need for Logging and Monitoring
Logging Options
Monitoring Options
Setting Up Alerts

Module 6: Troubleshooting BI Solutions


Troubleshoot Failed BI Solutions
Troubleshooting the Data Warehouse
Troubleshooting SQL Server Analysis Services
Troubleshooting SQL Server Reporting Services

Module 7: Performance Tuning BI Queries


The Need for Performance Tuning
BI Queries to Performance Tune
Tools for Performance Tuning
Remediating Performance Issues