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 20462: Administering Microsoft SQL Server Databases (2014)

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

Technical Training
Microsoft Technical

Troubleshooting and Supporting Windows 7 in the Enterprise

Learn how to support the Windows 7 operating system and solve technical troubleshooting problems in a Windows 7 and Windows Server 2008 R2 networking environment. In just three days in this hands-on course, you will learn how to fix startup issues, client configuration failures, connectivity problems, and security system issues, including Encrypting File Systems (EFS), BitLocker Drive Encryption, and file permissions.

This course incorporates materials from the Official Microsoft Learning Product 6293: Troubleshooting and Supporting Windows 7 in the Enterprise, and it can assist you in your preparation for Exam 70-685: Pro: Windows 7, Enterprise Desktop Support Technician.

Technical Training
Microsoft Technical

MTA: Networking Fundamentals

In this course, you will be introduced to networking concepts in today’s increasingly connected and technology-driven businesses. You will learn how communication and information transfers are enabled by networking technologies such as the Internet, intranet, and extranet, local area networks, wide area networks, wireless networking, network topologies, and access methods. You will also build foundational knowledge in various networking concepts, including the OSI model, IP addressing, Internet Protocols, and more.

This course is designed to help you prepare for Microsoft Technology Associate (MTA) Exam: 98-366 – Networking Fundamentals, which can be taken outside of the course.