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 20697: Windows 10 Installation & Deployment Bundle (Course #’s 20697-1 & 20697-2)

This Accelerated Boot Camp is 9 hours a day for 5 days

Mon-Fri, 10:00am ET – 7:00pm ET/ 7:00am PT – 4:00pm PT.
This course includes 1 Exam Voucher
SATV’s may be eligible with restrictions ask for details.
Estimated time outside of class hours is 2-3 hours/day depending on student.

This 5-day Windows 10 Boot Camp course provides students with the knowledge and skills required to install and configure Windows 10 desktops and devices in a Windows Server domain corporate environment.

It also provides administrators with the knowledge and skills needed to deploy and manage Windows 10 desktops, devices, and applications in an enterprise environment.

Students learn how to plan and implement Windows 10 deployments in large organizations. These skills include learning how to install and customize Windows 10 operating systems and apps, and configure local and remote network connectivity and storage. Students will also learn how to configure data security, device security, and network security, and maintain, update, and recover Windows 10. Students also learn how to manage the Windows 10 installations after deployment to provide secure identity and data access using technologies related to Group Policy, Remote Access, and Device Registration.

To support a variety of device and data management solutions, Microsoft Azure Active Directory, Microsoft Intune, and Microsoft Azure Rights Management are introduced. These services are part of the Enterprise Mobility Suite which provide identity and access management, cloud-based device, application, and update management, and secure data access to information stored both in the cloud and on any location within your corporate network.

Technical Training
Microsoft Technical

MOC 805715: MSFT Dynamics CRM 2015/2016 Customization and Configuration

This class provides a complete understanding of the Dynamics CRM product for Systems Administrators and Systems Customers. This course contains all the necessary information to manage a CRM deployment. The course starts with a high level introduction to Dynamics CRM with a core focus on Customization the process, customization and systems for your organization. Course…

Technical Training
Microsoft Technical

MOC 10778 Implementing Data Models and Reports with Microsoft SQL Server

This 5-day instructor-led course describes how to empower information workers through self-service analytics and reporting. Students will learn how to implement PowerPivot and tabular data models, create and deliver rich data visualizations with Power View and SQL Server Reporting Services, and discover business insights by using data mining. This course helps people prepare for exam 70-466.

The Beta version of this course (10778AB) utilizes pre-release software in the virtual machine for the labs. Microsoft SQL Server 2012 Release Candidate 0 (RC0) is used in this course. Some of the exercises in this course are SQL Azure enabled.

Technical Training
Microsoft Technical

C# Design and Application Patterns

The C# Design and Application Patterns course teaches .NET developers how to apply best practices to their .NET applications. While a thorough understanding of the C# language is key to development success, developers should also understand how to write loosely-coupled code that is based upon proven best practices and patterns. By applying design and application patterns to the development process, more consistent, flexible and maintainable code can be written.

In the C# Design and Application Patterns course developers will learn how to apply several Creational, Structural and Behavioral design patterns to their .NET applications. The course includes real-life analogies for each design pattern to help students thoroughly understand the purpose of a pattern and better understand when and where a pattern can be used. Comparisons between patterns are provided to help students in the pattern selection process. Students will also learn about two key application patterns including MVC and MVVM. Hands-on exercises will re-enforce the principles and provide students with an in-depth understanding of individual design and application pattern pros and cons.