Loading...
Login / Register

Course 20467D: Designing Business Intelligence Solutions with Microsoft SQL Server 2014

This training course teaches database and business intelligence (BI) professionals how to plan and design a BI solution that is based on Microsoft SQL Server 2014 and other Microsoft BI technologies.
Course Prerequisites:
MCSA: SQL Server 2012
Request a Quote

Instructor-Led Training (ILT)

Attend training in a classroom environment at a campus near you. Instructor-led training is still the number one delivery method of choice because it allows you to interact and discuss the training material, either individually or in a group setting, and you gain access to expert knowledge from certified instructors. This form of guided learning is impactful and produces positive learning outcomes. Day, evening and Saturday classes are offered.

Exam
Included

Duration
5 Days

Course Content

Course 20467B

MCSE: 70-467 Designing Business Intelligence Solutions with Microsoft SQL Server 2012
5 Days

Module 1: Planning a BI Solution
This module discusses how to plan the components of a BI solution.

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

Lab : Planning a BI Solution
Scoping a BI Solution
Determining Software Requirements

Module 2: Planning SQL Server Business Intelligence Infrastructure
This module explains how to plan an appropriate BI infrastructure for a given set of BI services.

Lessons
Considerations for BI Infrastructure
Planning Data Warehouse Hardware

Lab : Planning a BI Infrastructure
Planning Server Topology
Planning Data Warehouse Server Hardware

Module 3: Designing a Data Warehouse
This module explains how to design a data warehouse for a given set of user requirements.

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

Lab : Designing a Data Warehouse Logical Schema
Identifying Business Processes and Dimensions
Designing Dimension Models and Data Warehouse Tables

Lab : Designing a Data Warehouse Physical Implementation
Designing File Storage
Designing Warehouse Data Structures

Module 4: Designing an ETL Solution
This module explains how to design an ETL solution for a data warehouse.

Lessons
ETL Overview
Planning Data Extraction
Planning Data Transformation
Planning Data Loads

Lab : Designing an ETL Solution
Preparing for ETL Design
Creating Source-to-Target Documentation
Using SSIS To Load a Partitioned Fact Table

Module 5: Designing Analytical Data Models
This module explains how to design analytical data models for specific BI scenarios.

Lessons
Introduction to Analytical Data Models
Designing an Analytical Data Model
Designing Dimensions
Enhancing Data Models

Lab : Comparing Analytical Data Models
Creating a Multidimensional Data Model
Creating a Tabular Data Model

Lab : Designing Dimensions and Hierarchies
Creating Dimensions in a Multidimensional Data Model
Creating Dimensions in a Tabular Data Model

Lab : Enhancing Analytical Data Models
Enhancing a Multidimensional Data Model
Enhancing a Tabular Data Model

Module 6: Planning a BI Delivery Solution
This module explains how to choose an appropriate delivery solution for a given scenario.

Lessons
Considerations for Delivering BI
Common Reporting Scenarios
Choosing a Reporting Tool

Lab :Planning a BI Delivery Solution
Assessing Reporting Requirements

Module 7: Designing a Reporting Services Solution
This module explains how to design a Reporting Services solution.

Lessons
Planning a Reporting Services Solution
Designing Reports
Planning Report Consistency

Lab : Designing a Reporting Services Solution
Designing a Reporting Environment
Creating Reusable Report Item
Creating Reports

Module 8: Designing a Microsoft Excel-Based Reporting Solution
This module explains how to design a reporting solution that uses Excel.

Lessons
Using Excel for Data Analysis and Reporting
PowerPivot for Excel
Power View for Excel

Lab : Designing an Excel Reporting Solution
Exercise 1: Planning Excel Features
Exercise 2: Analyzing a Cube with Excel
Exercise 3: Creating a PowerPivot Workbook
Exercise 4: Using Power View in Excel

Module 9: Planning a SharePoint Server BI Solution
This module explains how to design a SharePoint BI solution.

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

Lab : Implementing a SharePoint Server BI Solution
Exercise 1: Creating a SharePoint Server Site for BI
Exercise 2: Configuring Reporting Services in SharePoint Server
Exercise 3: Configuring PowerPivot for SharePoint

Lab : Implementing a PerformancePoint Services
Exercise 1: Creating a PerformancePoint Dashboard

Module 10: Monitoring and Optimizing a BI Solution
This module explains how to monitor and optimize a BI solution.

Lessons
Overview of BI Monitoring
Monitoring and Optimizing the Data Warehouse
Monitoring and Optimizing Analysis Services
Monitoring and Optimizing Reporting Services

Lab : Monitoring and Optimizing a BI Solution
Monitoring and Optimizing a Data Warehouse
Monitoring and Optimizing Analysis Services
Monitoring and Optimizing Reporting Services

Module 11: Operating a BI Solution
This module explains how to plan management and maintenance operations for a BI solution.

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

Lab : Operating a BI Solution
Configuring SQL Server Integration Services
Automate Data Warehouse Load Tasks
Test Automated Operations

CTU Training Solutions , Updated: October 9th, 2017

Share with friends

Request a Quote



Your Name

Your Surname

Contact Number

Your Email

Company

Which campus would you like to study at?

Your job title

Will your training be sponsored?

Message

The course information above is subject to change without notification due to market trends in the industry, legislation and/or programme version updates. Terms and Conditions

Join the CTU community

Join the CTU Community Portal and gain access to superior resources.

Join for Free

Thank you for printing this page.
Logo
0861 100 395
[email protected]za
www.ctutraining.ac.za

X

Call me Back

Leave your details and we'll contact you back!

Your Name:

Your Email:


Contact Number:

Choose a campus