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

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.

View Entire Schedule

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

Viewing outline for:

Classroom Live Outline

1. Plan a BI Solution

Elements of a BI Solution
The Microsoft BI Platform
Planning a BI Project

2. Plan SQL Server Business Intelligence Infrastructure

Considerations for BI Infrastructure
Plan Data Warehouse Hardware

3. Design a Data Warehouse

Data Warehouse Design Overview
Design Dimension Tables
Design Fact Tables
Design a Data Warehouse Physical Implementation

4. Design an ETL Solution

ETL Overview
Plan Data Extraction, Transformation, and Loads

5. Design Analytical Data Models

Introduction to Analytical Data Models
Design an Analytical Data Model
Design Dimensions
Enhance Data Models

6. Plan a BI Delivery Solution

Considerations for Delivering BI
Common Reporting Scenarios
Choose a Reporting Tool

7. Design a Reporting Services Solution

Plan a Reporting Services Solution
Design Reports
Plan Report Consistency

8. Design a Microsoft Excel-Based Reporting Solution

Use Excel for Data Analysis and Reporting
PowerPivot and Power View for Excel

9. Plan a SharePoint Server BI Solution

Introduction to SharePoint Server as a BI Platform
Plan Security for a SharePoint Server BI Solution
Plan Reporting Services Configuration
Plan PowerPivot Configuration
Plan for PerformancePoint Services

10. Monitoring and Optimizing a BI Solution

Overview of BI Monitoring
Monitor and Optimize the Data Warehouse
Monitor and Optimize Analysis Services
Monitor and Optimize Reporting Services

11. Operate a BI Solution

Overview of BI Solutions
ETL Operations
Data Warehouse Operations
Analysis Services Operations
Reporting Services Operations

1. Plan a BI Solution

Elements of a BI Solution
The Microsoft BI Platform
Planning a BI Project

2. Plan SQL Server Business Intelligence Infrastructure

Considerations for BI Infrastructure
Plan Data Warehouse Hardware

3. Design a Data Warehouse

Data Warehouse Design Overview
Design Dimension Tables
Design Fact Tables
Design a Data Warehouse Physical Implementation

4. Design an ETL Solution

ETL Overview
Plan Data Extraction, Transformation, and Loads

5. Design Analytical Data Models

Introduction to Analytical Data Models
Design an Analytical Data Model
Design Dimensions
Enhance Data Models

6. Plan a BI Delivery Solution

Considerations for Delivering BI
Common Reporting Scenarios
Choose a Reporting Tool

7. Design a Reporting Services Solution

Plan a Reporting Services Solution
Design Reports
Plan Report Consistency

8. Design a Microsoft Excel-Based Reporting Solution

Use Excel for Data Analysis and Reporting
PowerPivot and Power View for Excel

9. Plan a SharePoint Server BI Solution

Introduction to SharePoint Server as a BI Platform
Plan Security for a SharePoint Server BI Solution
Plan Reporting Services Configuration
Plan PowerPivot Configuration
Plan for PerformancePoint Services

10. Monitoring and Optimizing a BI Solution

Overview of BI Monitoring
Monitor and Optimize the Data Warehouse
Monitor and Optimize Analysis Services
Monitor and Optimize Reporting Services

11. Operate a BI Solution

Overview of BI Solutions
ETL Operations
Data Warehouse Operations
Analysis Services Operations
Reporting Services Operations

1. Plan a BI Solution

Elements of a BI Solution
The Microsoft BI Platform
Planning a BI Project

2. Plan SQL Server Business Intelligence Infrastructure

Considerations for BI Infrastructure
Plan Data Warehouse Hardware

3. Design a Data Warehouse

Data Warehouse Design Overview
Design Dimension Tables
Design Fact Tables
Design a Data Warehouse Physical Implementation

4. Design an ETL Solution

ETL Overview
Plan Data Extraction, Transformation, and Loads

5. Design Analytical Data Models

Introduction to Analytical Data Models
Design an Analytical Data Model
Design Dimensions
Enhance Data Models

6. Plan a BI Delivery Solution

Considerations for Delivering BI
Common Reporting Scenarios
Choose a Reporting Tool

7. Design a Reporting Services Solution

Plan a Reporting Services Solution
Design Reports
Plan Report Consistency

8. Design a Microsoft Excel-Based Reporting Solution

Use Excel for Data Analysis and Reporting
PowerPivot and Power View for Excel

9. Plan a SharePoint Server BI Solution

Introduction to SharePoint Server as a BI Platform
Plan Security for a SharePoint Server BI Solution
Plan Reporting Services Configuration
Plan PowerPivot Configuration
Plan for PerformancePoint Services

10. Monitoring and Optimizing a BI Solution

Overview of BI Monitoring
Monitor and Optimize the Data Warehouse
Monitor and Optimize Analysis Services
Monitor and Optimize Reporting Services

11. Operate a BI Solution

Overview of BI Solutions
ETL Operations
Data Warehouse Operations
Analysis Services Operations
Reporting Services Operations

Viewing labs for:

Classroom Live Labs

Lab 1: Plan a BI Solution
Lab 2: Plan a BI Infrastructure
Lab 3: Design a Data Warehouse Logical Schema
Lab 4: Design a Data Warehouse Physical Implementation
Lab 5: Design an ETL Solution
Lab 6: Compare Analytical Data Models
Lab 7: Design Dimensions and Hierarchies
Lab 8: Enhance Analytical Data Models
Lab 9: Plan a BI Delivery Solution
Lab 10: Design a Reporting Services Solution
Lab 11: Design an Excel Reporting Solution
Lab 12: Implement a SharePoint Server BI Solution
Lab 13: Implement a PerformancePoint Services
Lab 14: Monitor and Optimize a BI Solution
Lab 15: Operate a BI Solution

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

MCSE: Data Management and Analytics

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

Cart () Loading...

Subtotal

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

Course Overview

Schedule

What You'll Learn

Outline

Classroom Live Outline

Labs

Classroom Live Labs

Prerequisites

Who Should Attend

Training Exclusives

Course Delivery