MCSE: Business Intelligence
CLASS DATE(s):
Request a Class

COURSE LENGTH: 6 Days

COURSE COST: $3995.00

COURSE TIMES: 10:00am - 6:00pm

Printable version of this course
print

COURSE OVERVIEW

The MCSE: Business Intelligence boot camp is 6 days of an intense deep dive into advanced concepts of SQL Server including implementing data models, reports & designing BI solutions with SQL Server. Student will take two exams, which will incorporate Microsoft Courses: 10778 Implementing Data Models and Reports with Microsoft SQL Server and 10780: Designing Business Intelligence Solutions with Microsoft SQL Server. Prove that you have the skills and techniques needed to design, build, and deploy 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.

All-Inclusive Pricing Option 1: $3,245, Option 2: $3,995 (includes *travel & lodging ) Save 10% on Online/VLT enrollments, *Contiguous US flights only

AUDIENCE AND PREREQUISITES

This boot camp is intended for business intelligence (BI) developers who focus on creating BI solutions that require implementing multidimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making. It is also intended for business intelligence (BI) architects, who are responsible for the overall design of a BI infrastructure and how it relates to other data systems in use.

MCSA: SQL Server

  

Course Cost listed does not include the cost of courseware or lunch. Please refer to your Invoice for the additional cost. This course is subject to minimum enrollment and may run as a Live Distance Learning session as a result. Please contact us at learn@vtec.org with any questions.

Exams Included
70­466: Implementing Data Models and Reports with Microsoft SQL Server
70­467: Designing Business Intelligence Solutions with Microsoft SQL Server

COURSE TOPICS:


After completing this boot camp, students will be able to:
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, Implement a Tabular Database.
Implement a Tabular Data Model in PowerPivot
Use DAX to query a tabular model
Use PowerView to create interactive data visualizations.
Use Data Mining for Predictive Analysis.

Build an analysis services database
Design dimensions and measures
Implement and configure dimensions in a cube
Design a schema to support cube architecture
Create measures, Implement a cube
Create Multidimensional Expressions (MDX) queries
Implement custom logic in a data model
Implement storage design in a multidimensional model
Select an appropriate model for data analysis

Manage, maintain, and troubleshoot an SSAS database
Analyze data model performance.
Process data models
Troubleshoot data analysis issues
Deploy SSAS databases
Install and maintain an SSAS instance

Build a tabular data model
Configure permissions and roles in Business Intelligence Semantic Model (BISM)
Implement a tabular data model
Implement business logic in a tabular data model
Implement data access for a tabular data model

Build a report with SQL Server Reporting Services (SSRS)
Design a report
Implement a report layout
Configure authentication and authorization for a reporting solution
Implement interactivity in a report
Troubleshoot reporting services issues
Manage a report environment
Configure report data sources and datasets

Plan business intelligence (BI) infrastructure
Plan for performance
Plan for scalability
Plan and manage upgrades
Maintain server health

Design BI infrastructure
Design a security strategy
Design a SQL partitioning strategy
Design a backup strategy
Design a logging and auditing strategy

Design a reporting solution
Design a Reporting Services dataset
Manage Excel Services/reporting for SharePoint
Design a data acquisition strategy
Plan and manage reporting services configuration
Design BI reporting solution architecture

Design BI data models
Design the data warehouse
Design a schema
Design cube architecture
Design fact tables
Design BI semantic models
Design and create MDX calculations

Design an ETL solution
Design SSIS package execution
Plan to deploy SSIS solutions
Design package configurations for SSIS packages