Designing Business Intelligence Solutions with Microsoft SQL Server 2014 (M20467)

Learn to design, install, and maintain a Business Intelligence platform with Microsoft SQL Server 2014.

Vendor# M20467

GK# 6408

Course Overview

In this course, you will learn how to design, implement, and maintain a Business Intelligence (BI) platform with Microsoft SQL Server 2014. You’ll learn to design a data warehouse and Business Intelligence solutions including: ETL, BI Delivery, Reporting Services, Excel Reporting, SharePoint Server BI along with how to monitor and optimize a BI solution.

You will learn big data concepts and analysis using Microsoft Azure HDInsight plus how to design, implement, and process big data solutions.

This course uses Microsoft SQL Server 2014.

This course incorporates material from the Official Microsoft Learning Product 20467: Designing Business Intelligence Solutions with Microsoft SQL Server 2014. This course maps to skills and knowledge measured by Microsoft exam 70-467, and in conjunction with on-the-job experience, can help prepare you for the exam.

Delivery Format Options

Classroom Live

Classroom Live

Receive face-to-face instruction at one of our training center locations.

From
$2995 CAD

5 day

View Dates/Location
Virtual Classroom Live

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an Internet connection.

From
$2995 CAD

5 day

View Dates
Virtual Classroom Fit

Virtual Classroom Fit

Attend live, online training sessions for a total of 24 hours spread over four weeks.

From
$2995 CAD

5 day

View Dates
Private Group Training

Private Group Training

Train your entire team in a private, coordinated professional development session at the location of your choice.

Receive private training for teams online and in-person.

Request a session

Request a date or location for this course.

What You'll Learn

Plan the components of a BI solution
Plan a BI infrastructure
Design a data warehouse
Design an ETL solution
Plan analytical data models
Plan a BI delivery solution
Design a Reporting Services solution
Design an Excel reporting solution
Plan a SharePoint Server BI solution
Monitor and optimize a BI solution
Plan for BI operations

Prerequisites

A basic understanding of dimensional modeling (star schema) for data warehouses
The ability to create Integration Services packages that include control flows and data flows
The ability to create a basic multidimensional cube with Analysis Services
The ability to create a basic tabular model with PowerPivot and Analysis Services
The ability to create Reporting Services reports with Report Designer
The ability to implement authentication and permissions in the SQL Server database engine, Analysis Services, and Reporting Services
Familiarity with SharePoint Server and Microsoft Office applications, particularly Excel

Who Needs To Attend

BI professionals such as BI architects or database professionals who need to design BI solutions

Training Exclusives

This course comes with 12 months access to the following benefits:

Practice Labs
24x7 Mentoring
Indexed Class Recordings
Unlimited Retakes
Digital Courseware

Find out more

Cart () Loading...

Subtotal