Managing SQL Business Intelligence Operations (M10988)

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

2. Configuring BI Components

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

3. Managing Business Intelligence Security

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

4. Deploying BI Solutions

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

5. Logging and Monitoring in BI Operations

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

6. Troubleshooting BI Solutions

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

7. Performance Tuning BI Queries

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

Lab 1: Introduction to operational Management in BI Solutions

Lab 2: Configuring BI Components

Lab 3: Managing Business Intelligence Security

Lab 4: Deploying BI Solutions

Lab 5: Monitoring BI Solutions

Lab 6: Troubleshooting BI Solutions

Lab 7: Performance Tuning a BI Solution