Course Introduction:
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 2012 and other Microsoft BI technologies. Who Should Attend
This course is not designed for students who are new to SQL Server 2012 BI technologies; it is targeted at BI professionals with experience of implementing solutions with SQL Server database Engine, SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services. After completing this course, participants will be able to,
- Plan a BI solution.
- Plan SQL Server BI infrastructure.
- Design a data warehouse.
- Design an extract, transform and load (ETL) solution.
- Design analytical data models.
- Plan a BI delivery solution.
- Design a Reporting Services solution.
- Design a Microsoft Excel-based reporting solution.
- Plan a SharePoint Server BI solution.
- Monitor and optimize a BI solution
Course Content
Module 1: Planning a BI Solution
Lesson 1: Elements of a BI Solution
Lesson 2: The Microsoft BI Platform
Lesson 3: Planning a BI Project
Lab: Planning a BI Solution
Module 2: Planning SQL Server Business Intelligence Infrastructure
Lesson 1: Considerations for BI Infrastructure
Lesson 2: Planning Data Warehouse Hardware
Lab: Planning SQL Server Business Intelligence Infrastructure
Module 3: Designing a Data Warehouse
Lesson 1: Data Warehouse Design Overview
Lesson 2: Designing Dimension Tables
Lesson 3: Designing Fact Tables
Lab A: Designing a Data Warehouse Logical Schema
Lesson 4: Designing a Data Warehouse Physical Implementation
Lab B: Designing a Data Warehouse Physical Implementation
Module 4: Designing an ETL Solution
Lesson 1: ETL Overview
Lesson 2: Planning Data Extraction
Lesson 3: Planning Data Transformation
Lesson 3: Planning Data Loads
Lab: Designing an ETL Solution
Module 5: Designing Analytical Data Models
Lesson 1: Introduction to Analytical Data Models
Lesson 2: Designing an Analytical Data Model
Lab A: Designing Analytical Data Models
Lesson 3: Designing Dimensions
Lab B: Designing Dimensions and Hierarchies
Lesson 4: Enhancing Data Models Lab
C: Enhancing Data Models
Module 6: Planning a BI Delivery Solution
Lesson 1: Considerations for Delivering BI
Lesson 2: Common Reporting Scenarios
Lesson 3: Choosing a Reporting Tool
Lab: Planning a BI Delivery Solution
Module 7: Designing a Reporting Services Solution
Lesson 1: Planning a Reporting Services Solution
Lesson 2: Designing Reports
Lesson 3: Planning Report Consistency
Lab: Designing a Reporting Services Solution
Module 8: Designing a Microsoft Excel-Based Reporting Solution
Lesson 1: Using Excel for Data Analysis and Reporting
Lesson 2: PowerPivot for Excel
Lesson 3: Power View for Excel
Lab: Designing a Microsoft Excel-Based Reporting Solution
Module 9: Planning a SharePoint Server BI Solution
Lesson 1: Introduction to SharePoint Server as a BI Platform
Lesson 2: Planning Security for a SharePoint Server BI Solution
Lesson 3: Planning Reporting Services Configuration
Lesson 4: Planning PowerPivot Configuration
Lab A: Implementing a SharePoint Server BI Solution
Lesson 5: Planning for PerformancePoint Services
Lab B: Implementing PerformancePoint Services
Module 10: Monitoring and Optimizing a BI Solution
Lesson 1: Overview of BI Monitoring
Lesson 2: Monitoring and Optimizing the Data Warehouse
Lesson 3: Monitoring and Optimizing Analysis Services
Lesson 4: Monitoring and Optimizing Reporting Services
Lab: Monitoring and Optimizing a BI Solution
Module 11: Operating a BI Solution
Lesson 1: Overview of BI Operations
Lesson 2: ETL Operations
Lesson 3: Data Warehouse Operations
Lesson 4: Analysis Services Operations
Lesson 5: Reporting Services Operations
Lab: Operating a BI Solution