MCSE: Business Intelligence Solutions Expert

MCSE: Business Intelligence Solutions Expert



The globally recognized standard for IT professionals
Note This certification will retire on March 31, 2017. When the certification retires, all individuals whose transcripts list this certification as active on or after September 26, 2016, will retain the active status.
Find out about the replacement certification, MCSE: Data Management and Analytics.
Prove that you have the skills and techniques needed to design, build, and deploy SQL Server business intelligence (BI) solutions that deliver more data to more people across the organization.
Earning an MCSE: Business Intelligence certification will qualify you for a position as a BI and reporting engineer.


Course name


   Implementing Data Models and Reports with Microsoft SQL Server 2012

Microsoft 6 About this Course

This five-day instructor-led course teaches students how to empower information workers through self-service analytics and reporting. Students will learn how to implement multidimensional analysis solutions, create PowerPivot and tabular data models, deliver rich data visualizations with Power View and SQL Server Reporting Services, and discover business insights by using data mining.

Audience Profile


This course is intended for database professionals who need to fulfill a Business Intelligence Developer role to create analysis and reporting solutions. Primary responsibilities include:
Implementing reporting solutions by using SQL Server Reporting Services.
Implementing multidimensional databases by using SQL Server Analysis Services.
Creating tabular semantic data models for analysis by using SQL Server Analysis Services.
Create visualizations of data by using PowerView.
Create data mining solutions by using SQL Server Analysis Services
Course objectives
Describe the components, architecture, and nature of a BI solution.
Create reports with Reporting Services.
Create reusable report items that simplify self-service reporting.
Manage report execution and delivery.
Create a multidimensional database with Analysis Services.
Implement dimensions in a cube.
Implement measures and measure groups in a cube.
Use MDX Syntax.
Customize a cube.
Implement a Tabular Data Model in PowerPivot.
Use DAX to query a tabular model.
Implement a Tabular Database.
Use PowerView to create interactive data visualizations
Course Modules
Module 1: Introduction to Business Intelligence and Data Modeling
Module 2: Implementing Reports with SQL Server Reporting Services
Module 3: Supporting Self Service Reporting
Module 4: Managing Report Execution and Delivery
Module 5: Creating Multidimensional Databases
Module 6: Working with Dimensions
Module 7: Working with Measures and Measure Groups
Module 8: Introduction to MDX
Module 9: Customizing Cube Functionality
Module 10: Implementing a Tabular Data Model with Microsoft PowerPivot
Module 11: Introduction to DAX
Module 12: Implementing an Analysis Services Tabular Data Model
Module 13: Creating Data Visualizations with Power View
Module 14: Performing Predictive Analysis with Data Mining

 Designing Business Intelligence Solutions with Microsoft SQL Server 2012

About this Course

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

Audience Profile

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. Finally, they may apply those skills in a Windows Azure SQL Server database environment


Course objectives
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
Course Modules
Module 1: Planning a BI Solution
Module 2: Planning a BI Infrastructure
Module 3: Designing a Data Warehouse
Module 4: Designing an ETL Solution
Module 5: Designing Analytical Data Model
Module 6: Planning a BI Delivery Solution
Module 7: Designing a Reporting Services Solution
Module 8: Designing an Excel-Based Reporting Solution
Module 9: Planning a SharePoint Server BI Solution
Module 10: Monitoring and Optimizing a BI Solution
Module 11: Planning BI Operations


Back to top



All Rights Reseved ©