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

MCSA: Windows 10 Boot Camp

In an intensive and immersive hands-on learning environment, you will build the skills needed configure, manage, and maintain a Windows 10 enterprise system and prepare for the MCSA: Windows 10 certification exams. This extended-hours boot camp, led by senior Global Knowledge instructors, includes targeted lectures using Microsoft Learning recommended content and 12 months of access to more than 40 hands-on remote labs.

This boot camp includes all the exam vouchers required for certification, along with one free retake voucher if needed. It also includes access to our Microsoft Boot Camp Exclusives, providing indispensable certification exam prep.

You will prepare for these exams:

70-697: Configuring Windows Devices
70-698: Installing and Configuring Windows 10

Technical Training
Microsoft Technical

MOC 80544: Warehouse Management System in Microsoft Dynamics AX 2012 R2

This two-day instructor-led course provides students with the necessary tools and resources to perform basic tasks in the warehouse management flow in Microsoft Dynamics AX 2012 R2.

Technical Training
Microsoft Technical

MOC 20488 – Developing Microsoft SharePoint Server 2013 Core Solutions

In this course, students learn core skills that are common to almost all SharePoint development activities. These include working with the server-side and client-side object models, developing and deploying features, solutions, and apps, managing identity and permissions, querying and updating list data, managing taxonomy, using workflow to manage business processes, and customizing the user interface.

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.