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

MOC 20410 – Installing and Configuring Windows Server 2012

The course is part one, of a series of three courses, which provide the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment. The three courses in total collectively cover implementing, managing, maintaining, and provisioning services and infrastructure in a Windows Server 2012 environment. While there is…

Technical Training
Microsoft Technical

Administering System Center Configuration Manager and Intune (M20696)

In this course, you will practice configuring and managing clients and devices using Microsoft System Center v1511 Configuration Manager, Microsoft Intune, and its associated site systems. You will learn day-to-day management tasks including how to manage software, client health, hardware and software inventory, applications, and integration with Microsoft Intune. You also will discover how to optimize System Center 2012 Endpoint Protection, manage compliance, and create management queries and reports.

This course incorporates materials from the Official Microsoft Learning Product 20696: Administering System Center Configuration Manager and Intune and it can assist you in your preparation for Exam 70-696: Administering System Center Configuration Manager and Intune.

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

ï¿½

Technical Training
Microsoft Technical

Active Directory Services with Windows Server (M10969)

In this course, you will learn how to better manage and protect data access and information, simplify deployment and management of your identity infrastructure, and provide more secure access to data. You will learnï¿½how to configure some of the key features in Active Directory such as Active Directory Domain Services (AD DS), Group Policy, Dynamic Access Control (DAC), Work Folders, Work Place Join, Certificate Services, and Rights Management Services (RMS).

This course incorporates materials from the Official Microsoft Learning Product 10969: Active Directory Services with Windows Server.

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

Technical Training
Microsoft Technical

Integrating On-Premises Core Infrastructure with Microsoft Azure (M10992)

This course covers a range of components, including Azure Compute, Azure Storage, and network services that customers can benefit from when deploying hybrid solutions. In this context, the term hybrid means integrating infrastructure technologies that customers host in on-premises datacenters with Azure Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) services. This course offers an overview of these services and provides you with the knowledge necessary to design hybrid solutions properly.

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