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.
Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus.
Excellent presentation skills, subject matter knowledge, and command of the environment.
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect.
Click here to print this page »
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
SharePoint BI Environments
Module 3: Managing Business Intelligence Security
Security Approach to BI Solutions
Security Approach for BI Components
The Security Approach in Different BI Environments
Module 4: Deploying BI Solutions
Application Life Cycle Management for BI Solution
Module 5: Logging and Monitoring in BI Operations
The Need for Logging and Monitoring
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