Managing SQL Business Intelligence Operations
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.
Intended audience
The primary audience for this course are business intelligence professionals.
The secondary audiences for this course are technically proficient business users.
Topics
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
Lab : Introduction to Operational Management in BI Solutions
Module 2: Configuring BI Components
The Importance of Standardized Builds
Configuration Considerations for BI Technologies
BI Architectures
SharePoint BI Environments
Lab : Configuring BI Components
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
Lab : Managing Business Intelligence Security
Module 4: Deploying BI Solutions
Application Life Cycle Management for BI Solution
Stand-Alone Deployments
Team-Based Deployments
Lab : Deploying BI Solutions
Module 5: Logging and Monitoring in BI Operations
The Need for Logging and Monitoring
Logging Options
Monitoring Options
Setting Up Alerts
Lab : Monitoring BI Solutions
Module 6: Troubleshooting BI Solutions
Troubleshoot Failed BI Solutions
Troubleshooting the Data Warehouse
Troubleshooting SQL Server Analysis Services
Troubleshooting SQL Server Reporting Services
Lab : Troubleshooting BI Solutions
Module 7: Performance Tuning BI Queries
The Need for Performance Tuning
BI Queries to Performance Tune
Tools for Performance Tuning
Remediating Performance Issues
Lab : Performance Tuning a BI Solution
האם אתה בטוח שאתה רוצה לסגור את הטופס ולאבד את כל השינויים?
