Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Live Online & Classroom Enterprise Training

Location: Bangalore, India | Dubai, UAE

Industry Experienced Instructor  |  Remote Labs  |  Lab Access Post Training

Need help finding the right training?

Course Details

In this course, you will learn how to design, install, and maintain business intelligence (BI) infrastructures, including data warehouse, an extract, transform, and load (ETL), Analysis Services, Reporting Services, and SharePoint Server.

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

Course Prerequisites

You should have the following technical knowledge:

  • Basic understanding of dimensional modeling (star schema) for data warehouses
  • Ability to create integration services packages that include control flows and data flows
  • Ability to create a basic multidimensional cube with Analysis Services
  • Ability to create a basic tabular model with PowerPivot and Analysis Services
  • Ability to create Reporting Services reports with Report Designer
  • Ability to implement authentication and permissions with the SQL Server database engine, Analysis Services, and Reporting Services
  • Familiarity with SharePoint Server and Microsoft Office applications, particularly Excel
  • Or the skills and knowledge from the following courses:

Course Agenda

1. Planning a BI Solution

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

2. Planning a SQL Server BI Infrastructure

  • Considerations for a BI Infrastructure
  • Planning Data Warehouse Hardware

3. Designing a Data Warehouse

  • Data Warehouse Design
  • Designing Dimension Tables and Fact Tables
  • Designing a Data Warehouse Physical Implementation

4. Designing an ETL Solution

  • ETL Overview
  • Planning Data Extraction, Data Transformation, and Data Loading

5. Designing Analytical Data Models

  • Analytical Data Models
  • Designing an Analytical Data Model
  • Designing Dimensions
  • Enhancing Data Models

6. Planning a BI Delivery Solution

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

7. Designing a Reporting Services Solution

  • Planning a Reporting Services Solution
  • Designing Reports
  • Planning Reporting Consistency

8. Designing a Microsoft Excel-Based Reporting Solution

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

9. Planning a SharePoint Server BI Solution

  • 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

10. Monitoring and Optimizing a BI Solution

  • BI Monitoring Overview
  • Monitoring and Optimizing the Data Warehouse, Analysis Services, and Reporting Services

11. Operating a BI Solution

  • BI Operations Overview
  • ETL Operations
  • Data Warehouse, Analysis Services, and Reporting Services Operations