10988 Managing SQL Business Intelligence 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.

After completing this course, students will be able to:

Describe key features of a self-service BI solution
Describe the key capabilities of SQL Server BI in a SharePoint environment
Describe common Analysis Services operational tasks
Describe PowerPivot for SharePoint server
Describe Power Query
Describe Windows Azure HDInsight

Course Outline

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

2 - CONFIGURING BI COMPONENTS

The Importance of Standardized Builds
Configuration Considerations for BI Technologies
BI Architectures
SharePoint BI Environments
Lab : Configuring BI Components

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

4 - DEPLOYING BI SOLUTIONS

Application Life Cycle Management for BI Solution
Stand-Alone Deployments
Team-Based Deployments
Lab : Deploying BI Solutions

5 - LOGGING AND MONITORING IN BI OPERATIONS

The Need for Logging and Monitoring
Logging Options
Monitoring Options
Setting Up Alerts
Lab : Monitoring BI Solutions

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

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

Actual course outline may vary depending on offering center. Contact your sales representative for more information.

All class times shown are in Pacific Standard Time (PST)
This course is SATV-Eligible
There are currently no scheduled dates for this course. Please contact us for more information.

Contact Us For Price

Course Length: 3 Days

Enroll Now

1. Choose a Date | 2. Click Enroll Now

Need Help Picking the Right Course? Give us a call! 781-388-0026