Business Intelligence 20467-Designing Business Intelligence Solutions with Microsoft SQL Server 2012

20467-Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Location:

Date of Class:

Instructor:

Last Day To Enroll:

2975.00 2,975.00
$2,975.00
PRICE PER USER
$
X
USERS


=
SUBTOTAL
$
  • Course Delivery: Virtual Classroom
  • Language: English

Chat Live | Contact Us | Toll Free: (888) 360-8764

 

Description

This five-day instructor-led course teaches students how to design and implement a BI infrastructure. The course discusses design, installation. the course discusses design, installation, and maintenance of a BI platform.
 

Course Objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning.

Upon successful completion of this course, students will be able to:

  • 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.
 

Topics Covered

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

  • Elements of a BI Solution
  • Planning a BI Project
  • The Microsoft BI Platform
  • Lab : Planning a BI Solution  
  • Exercise 1: Scoping a BI Solution.
  • Exercise 2: Reviewing a Suggested Solution

Module 2: Planning a BI Infrastructure
This modules explains how to plan an appropriate BI infrastructure for a given set of BI services.

  • Planning a Data Warehouse Infrastructure
  • Planning an ETL Infrastructure
  • Planning Analysis Services Infrastructure
  • Planning Reporting Services Infrastructure
  • Lab : Planning a BI Infrastructure  
  • Exercise 1: Determining Required Servers
  • Exercise 2: Determining Data Warehouse Server Hardware Requirements
  • Exercise 3: Reviewing a Suggested Solution

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

  • Designing a Logical Schema
  • Designing a Physical Schema
  • Lab : Designing a Data Warehouse Logical Schema  
  • Exercise 1: Identifying Required Dimensions
  • Exercise 2: Identifying Measures and Hierarchies
  • Exercise 3: Designing a Data Warehouse Schema
  • Exercise 4: Reviewing a Suggested Solution
  • Lab : Designing a Data Warehouse Physical Schema  
  • Exercise 1: Planning Database Storage
  • Exercise 2: Designing Partitioning
  • Exercise 3: Designing Indexes
  • Exercise 4: Reviewing a Suggested Solution

Module 4: Designing an ETL Solution
This module explains how to design an ETL solution for a data warehouse.
  
  • Planning for Data Extraction
  • Planning for Data Transformation
  • Planning for Data Loading
  • Planning for SSIS Package Deployment
  • Lab : Designing an ETL Solution  
  • Exercise 1: Reviewing Data Sources
  • Exercise 2: Creating Source-to-Target Maps
  • Exercise 3: Planning ETL Processes
  • Exercise 4: Reviewing a Suggested Solution

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

  • Options for Analytical Models
  • Data Model Design Considerations
  • Lab : Comparing Analytical Data Models  
  • Exercise 1: Creating a Multidimensional Model
  • Exercise 2: Creating a Tabular Model
  • Lab : Designing Data Models  
  • Exercise 1: Designing Dimension Attributes
  • Exercise 2: Designing Data Model Aggregations and Storage
  • Exercise 3: Reviewing a Suggested Solution

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

  • Considerations for BI Delivery
  • Choosing a Delivery Approach
  • Lab : Planning a BI Delivery Solution  
  • Exercise 1: Assessing Reporting Requirements

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

  • Designing Reports
  • Considerations for Report Execution
  • Planning a Reporting Solution
  • Lab : Designing a Reporting Services Solution  
  • Exercise 1: Planning a Reporting Services Solution
  • Exercise 2: Planning a Report Delivery Environment
  • Exercise 3: Configuring Report Execution

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

  • Using Excel for Data Reporting and Analysis
  • PowerPivot in Excel
  • Power View in Excel
  • Lab : Designing an Excel Reporting Solution  
  • Exercise 1: Planning Excel Features
  • Exercise 2: Analyzing a Cube with Excel
  • Exercise 3: Using PowerPivot
  • Exercise 4: Using Power View

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

  • 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 : Planning a SharePoint Server BI Solution  
  • Exercise 1: Planning SharePoint Server Security
  • Exercise 2: Configuring Reporting Services in SharePoint Server
  • Exercise 3: Managing PowerPivot Data Refresh
  • Exercise 4: Reviewing PowerPivot Activity
  • Exercise 5 (Optional) Creating a PerformancePoint Dashboard

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

  • 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  
  • Exercise 1: Monitoring and Optimizing a Data Warehouse
  • Exercise 2: Troubleshooting Analysis Services Queries
  • Exercise 3: Monitoring and Optimizing Reporting Services

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

  • Overview of BI Operations
  • Automating ETL Tasks
  • Post ETL Tasks
  • Planning a Backup Strategy for a BI Solution
  • Lab : Planning BI Operations  
  • Exercise 1: Planning ETL and Processing Tasks
  • Exercise 2: Planning a Backup Strategy

 

Prerequisites

To ensure your success in this course, it is recommended that you have:

  • 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.
 

Subject Matter Expert

Productivity Point Global is led by a team of individuals with world-class experience in professional development skills and leading edge technologies. These established professionals collaborate to drive PPG's business forward through entrepreneurial innovation, strategic partnerships, brand management and sales growth.

Productivity Point Global, previously ExecuTrain of Florida, began in 2003 and evolved out of a desire to increase our outreach both nationally and internationally. Utilizing the highest standard in customer service combined with our subject matter experts and high-end training venues, PPG has carved a niche by consistently expanding our corporate and government client base, originally hosted in the southeastern region of the US.

By consistently setting quality as the benchmark of our value system, PPG combines strategic partnerships and cutting edge technology with our determined efforts to branch out into other regions. PPG's combination of technology and professional skills training, IT outsourcing, and event hosting enables us to place a focused emphasis on the diversified business needs of our clients.
For more info please visit: http://www.productivitypoint.com/

Got questions? Contact us below or call 877-881-2235

Why Choose 360training.com?

  • Fast and easy courses completion
  • Get an education faster than at traditional colleges!
  • 100% online - No classroom attendance required.
  • Unlimited 24x7 online customer support
  • Over 500,000+ certified nationwide.