Managing SQL Business Intelligence Operations (M10988)

COURSE OUTLINE:

Description

In this course, you will learn about business intelligence (BI) solutions with Microsoft SQL Server 2016. You will learn about the Microsoft tools and key features of a self-service BI solution. Additionally, you will examine SQL Server BI in a SharePoint environment, which includes PowerPivot, analysis services, and reporting services (such as Power Query and Windows Azure HDInsight).ï¿½

GK Digital Learning is also available with digital Microsoft Official Courseware (dMOC). Click here to purchase.

Audience

BI professionalsï¿½
Technically proficient business users?

Prerequisites

Basic knowledge of data warehouse schema topology (including star and snowflake schemas)
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)
Basic knowledge of data warehouse schema topology (including star and snowflake schemas)
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)

Learning Objectives

Key features of a self-service BI solution
Key capabilities of SQL Server BI in a SharePoint environment
Common analysis services operational tasks
PowerPivot for SharePoint server
Power Query
Windows Azure HDInsight

1.ï¿½Introduction to Microsoft SQL Server BI Solution

Overview of Self-Service BI
Considerations of Self-Service BI
Microsoft Tools for Self-Service BI

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 Tuning
Tools for Performance Tuning
Remediating Performance Issues

RELATED COURSES

Technical Training
Microsoft Technical

Implementing a SQL Data Warehouse (M20767)

In this course, you will learn how to implement a data warehouse platform to support a business intelligence (BI) solution. You will discover how to create a data warehouse, how to implement extract, transform, and load (ETL) with SQL Server Integration Services (SSIS), and how to validate and cleanse data with Data Quality Services (DQS) and Master Data Services.

This course uses Microsoft SQL Server 2016 and incorporates material from the Official Microsoft Learning Product 20767: Implementing a SQL Data Warehouse.

Technical Training
Microsoft Technical

Developing Windows Azure and Web Services (M20487)

In this course, you will learn to design and develop services that access local and remote data from various data sources. You will also learn to develop and deploy services to hybrid environments, including on-premises servers and Windows Azure.

This course incorporates materials from the Official Microsoft Learning Product 20487: Developing Windows Azure and Web Services. It covers the skills and knowledge measured by Exam 70-487 and, in conjunction with hands-on experience, can help you prepare for the exam.

Technical Training
Microsoft Technical

MOC 20463: Implementing a Data Warehouse with Microsoft SQL Server

In this course, you will learn how to implement a data warehouse infrastructure to support information worker analytics using SQL Server 2012/2014. You will discover how to create a data warehouse with SQL Server 2012/2014, implement extract, transform, and load (ETL) with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services (DQS) and SQL Server Master Data Services.

Technical Training
Microsoft Technical

MOC 20347: Enabling and Managing Office 365

This is a 5-day instructor-led training (ILT) course that targets the needs of IT professionals who take part in evaluating, planning, deploying, and operating Office 365 services, including its identities, dependencies, requirements, and supporting technologies. This course focuses on skills required to set up an Office 365 tenant, including federation with existing user identities, and skills required to sustain an Office 365 tenant and its users.