MCSE: Business Intelligence Training & Certification (Boot Camp - 6 Days)
  • Overview
  • Certifications
  • Curriculum
  • Schedule
  • Testimonials
  • View Comments

Program Description:

Business intelligence (BI) is becoming increasingly important for companies of many different sizes and types because of the competitive edge it can help to give them. The combined capabilities of Microsoft SQL Server 2012 and Microsoft SharePoint 2010 make it easier than ever for companies to develop a BI solution that meets their specific needs, provides reduced total cost of ownership (TCO), and achieves a faster time to solution.

By earning MCSE: Business Intelligence Certification 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 

The MCSE: Business Intelligence Certification training is an intense deep dive into all aspect of Implementing Data Models and Reports with Microsoft SQL Server 2012 and Designing Business Intelligence Solutions with Microsoft SQL Server 2012.

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 Covers

·       Course 10778A: Implementing Data Models and Reports with Microsoft SQL Server 2012

·       Course 20467A: Designing Business Intelligence Solutions with Microsoft SQL Server 2012

 

MCSE: Data Platform Training will prepare you for the following exams:

Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012

Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012

 

What you will learn:

Course 10778A: Implementing Data Models and Reports with Microsoft SQL Server 2012

Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012

This instructor-led training 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 PowerView and SQL Server Reporting Services, and discover business insights by using data mining. This course helps people prepare for Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012.

 

After completing this training, 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.

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

·     Use Data Mining for Predictive Analysis.

 

Course 20467A: Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012

 

This instructor-led training teaches students how to design and implement a BI infrastructure. The training discusses design, installation; the course discusses design, installation, and maintenance of a BI platform.

This course helps people prepare for Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012.

 

After completing this training, students will be able to:

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

·     Plan for BI operations.

 

Each day of training is section wise of Lecture, Lab, and Review modules.  

 

Days 1-3: Implementing Data Models and Reports with Microsoft SQL Server 2012

Exam: 70-466

Days 3-6: Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Exam: 70-467

Note:  Daily schedule might be changes according to materials requirements to ensure that the objectives of the course are met.
Certificate Covers
LOCATION START END TIME ENROLL