10988: Managing SQL Business Intelligence Operations (SQL Server 2017)

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

This course is based on the objectives of the course version 10988C.

SATV Eligible Course
Don’t let your SATVs expire – put them to work for your organization today. Reserve your seat for the SATV eligible courses. To place your schedule request call at 1-888-563-8266 or chat live with a Learning Consultant.

Next Class Dates

Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with a Learning Consultant.

Intended Audience for this 10988: Managing SQL Business Intelligence Operations (SQL Server 2017)

» The primary audience for this course is business intelligence professionals.
» The secondary audiences for this course are technically proficient business users.

Course Prerequisites for 10988: Managing SQL Business Intelligence Operations (SQL Server 2017)

» Required: An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
» Required: Familiarity with SharePoint Server and Microsoft Office applications, particularly Excel
» Required: Some basic knowledge of data warehouse schema topology (including star and snowflake schemas)
» Required: Some exposure to basic programming constructs (such as looping and branching)

10988: Managing SQL Business Intelligence Operations (SQL Server 2017) Course Objectives

» 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

10988: Managing SQL Business Intelligence Operations (SQL Server 2017) 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
Lab : Introduction to Operational Management in BI Solutions
Configuring BI Components
The Importance of Standardized Builds
Configuration Considerations for BI Technologies
BI Architectures
SharePoint BI Environments
Lab : Configuring BI Components
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
Deploying BI Solutions
Application Life Cycle Management for BI Solution
Stand-Alone Deployments
Team-Based Deployments
Lab : Deploying BI Solutions
Logging and Monitoring in BI Operations
The Need for Logging and Monitoring
Logging Options
Monitoring Options
Setting Up Alerts
Lab : Monitoring BI Solutions
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
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

Do you have the right background for 10988: Managing SQL Business Intelligence Operations (SQL Server 2017)?
Skills Assessment
We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will recommend cost-effective solutions that you can use to get ready for the course.
Our required skill-assessments ensure that:
All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
NetCom students enjoy one of the industry’s highest success rates, and pass rates when a certification exam is involved.
We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.

Take your FREE Skill Assessment test »