MCSE SQL Data Management and Analytics Business Intelligence Certification Camp


IMPORTANT – While you can attend this camp without holding the MCSA certification – You must have the MCSA: SQL Server certification to earn MCSE Data Mgmt & Analytics (Business Intelligence) certification.

The MCSE: Business Intelligence certification boot camp is a six day comprehensive deep dive into advanced concepts of SQL Server BI with a focus on creating managed enterprise BI solutions. The camp focuses on creating managed enterprise BI solutions including how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server Performance Point Services, and discover business insights by using data mining.

The SQL Business Intelligence boot camp incorporates Microsoft Courses –

20466 Implementing Data Models and Reports with Microsoft SQL Server 2012
20467 Designing Business Intelligence Solutions with Microsoft SQL Server 2012



While attending this training program – you take two exams to test and certify for the Microsoft Certified Solutions Expert (MCSE): Business Intelligence official certification. If your goal is to learn how to use SQL BI and pass the certification exams (70-466 / 70-467) – you’ve found the right place. This course is a hybrid of actual hands on learning combined with focused materials mapped to exam objectives.

  • Class Dates
  • 02/10/2017 – 07/10/2017Punta Gorda, FL
    13/11/2017 – 18/11/2017Punta Gorda, FL
    18/12/2017 – 22/12/2017Punta Gorda, FL

  • What Is Included
  • transportation,plane,half,user,airplane,transport,account,profile,people,human Airfare to/from Punta Gorda, FL
    lodging 12 Nights of Lodging
    transportation,bus,automobile,vehicle,car,transport Shuttle Transportation from the Airport/Hotel/Facility
    restaurant Breakfast Served at the Hotel and Lunch is Provided by the Facility
    address,book,reading,read Authorized Course Materials, Study Guides, Classroom Handouts. Test Preps
    exam 3 Microsoft Exam Vouchers
    exam 3 Retake Vouchers (if needed)
    Onsite Pearson Vue Testing Center
    exam 180 Days Post Class Virtual Lab Access
    exam 90 Days eLearning Access

Class Outline

Topics covered in this boot camp:

Describe the components, architecture, and nature of a BI solution.
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 SQL Server Analysis Services.
Use DAX to enhance a tabular model.
Create reports with Reporting Services.
Enhance reports with charts and parameters.
Manage report execution and delivery.
Implement a dashboard in SharePoint Server with PerformancePoint Services.
Use Data Mining for Predictive Analysis.

Describe key features and benefits of self-service BI.
Use SQL Server Reporting Services to implement a self-service reporting solution.
Use PowerPivot in Microsoft Excel to create analytical data models.
Use Power Query in Microsoft Excel to import data into a data model.
Use Power View in Microsoft Excel to create interactive data visualizations.
Use Power Map in Microsoft Excel to create geographic data visualizations.
Use Microsoft SharePoint Server to implement collaborative self-service BI solutions.
Provision and use a Windows Azure HDInsight cluster for Big Data analysis.
Use Pig and Hive to analyze big data in Windows Azure HDInsight.
Design and implement Big Data processes to support self-service BI.


There are no reviews yet.

Be the first to review “MCSE SQL Data Management and Analytics Business Intelligence Certification Camp”

Your email address will not be published. Required fields are marked *