Audience profile

• BI professionals
• Technically proficient business users.

Prerequisites

• 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)

Course outline

Introduction to Operational Management in BI Solutions

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

Configuring BI Components

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

Managing Business Intelligence Security

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

Deploying BI Solutions

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

Logging and Monitoring in BI Operations

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

Troubleshooting BI Solutions

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

Performance Tuning BI Queries

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