20467 Designing Business Intelligence Solutions with Microsoft SQL Server 2012
Request a Class


COURSE COST: $2495.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course


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.

Note:This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.


This course is intended for BI professionals such as BI Architects or database professionals who need to design BI solutions. BI Architects are responsible for the overall design of the BI infrastructure, including how it relates to other data systems in use. In addition, their responsibilities include Online Analytical Processing (OLAP) cube design and integration with Microsoft SharePoint or line-of-business applications.

    This course requires that you meet the following prerequisites:
  • Knowledge of data warehousing and data modeling principles.
  • Familiarity with Microsoft Excel and Microsoft SharePoint Server 2013.


vendor course description

*Course Cost listed does not include the cost of courseware or lunch. Please refer to your Enrollment Sales Order or Invoice for the additional cost. If you have any questions, please contact us (learn@vtec.org or 207-775-0244). Course is subject to minimum enrollment. Courses maybe run as a LDL - Live Distance Learning if minimum enrolled has not been met.


Module 1: Planning a BI Solution
Elements of a BI Solution
The Microsoft BI Platform
Planning a BI Project
Lab : Planning a BI Solution

Module 2: Planning BI Infrastructure
Considerations for BI Infrastructure
Planning Data Warehouse Hardware
Lab : Planning a BI Infrastructure

Module 3: Designing a Data Warehouse
Data Warehouse Design Overview
Designing Dimension Tables
Designing Fact Tables
Lab : Designing a Data Warehouse Logical Schema

Module 4: Designing an ETL Solution
ETL Overview
Planning Data Extraction
Planning Data Transformation
Planning Data Loads
Lab : Designing an ETL Solution

Module 5: Designing Analytical Data Models
Introduction to Analytical Data Models
Designing an Analytical Data Model
Designing Dimensions
Enhancing Data Models
Lab : Comparing Analytical Data Models
Lab : Designing Dimensions and Hierarchies

Module 6: Planning a BI Delivery Solution
Considerations for Delivering BI
Common Reporting Scenarios
Choosing a Reporting Tool
Lab : Planning a BI Delivery Solution

Module 7: Designing a Reporting Services Solution
Planning a Reporting Services Solution
Designing Reports
Planning Report Consistency
Lab : Designing a Reporting Services Solution

Module 8: Designing a Microsoft Excel-Based Reporting Solution
Using Excel for Data Analysis and Reporting
PowerPivot for Excel
Power View for Excel
Lab : Designing an Excel Reporting Solution

Module 9: Planning a SharePoint Server 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 : Implementing a SharePoint Server BI Solution
Lab : Implementing a PerformancePoint Services

Module 10: Monitoring and Optimizing 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

Module 11: Operating a BI Solution
Overview of BI Operations
ETL Operations
Data Warehouse Operations
Analysis Services Operations
Reporting Services Operations
Lab : Operating a BI Solution

Module 12: Implementing Big Data Processing Solutions with Windows Azure HDInsight
Automating Big Data Processing Tasks
Integrating Windows Azure HDInsight with Enterprise Data
Lab : Creating a Big Data Solution