MCSE Business Intelligence Boot Camp

Quantity

$3,595.00

Add to Cart

New Age Technologies has been delivering Authorized Training since 1996. We offer Microsoft’s full suite of authorized courses including courses pertaining to Microsoft MCSE Business Intelligence Boot Camp, Microsoft Office, Sharepoint, SQL, Exchange and more. If you have any questions or can’t seem to find the Microsoft class that you are interested in, contact one of our Microsoft Training Specialists. Invest in your future today with Microsoft training from New Age Technologies.

✉ Microsoft Training Specialist | ☏ 502.909.0819

---

EXCLUSIVE BENEFIT:

This course includes a twelve-month subscription to these exclusive benefits:

• 12 months of anytime access to your course labs and lab environment
• 12 months of 24/7 access to mentoring via chat, email, and phone
• 12 months of on-demand access to indexed, searchable recordings of your Online Live class
• 12 months of unlimited retakes of your class
• 30 days of access to the online Microsoft Press E-Reference Library, including all training kits, exam references, and rapid review books
• 30 days of access to a recommended Microsoft reading List designed by our instructors, including topics and chapters within the Microsoft Press E-Reference Library
• 12 months of access to recorded “Power Hours” — an online review session covering key exam objectives conducted by our expert instructors – for each exam

---

COURSE INFORMATION

MCSE Business Intelligence Boot Camp Overview:

MCSE Business Intelligence Boot Camp helps you build your skills and techniques to design, build, and deploy solutions that deliver more data to more people across your organization as well as prepare you for the MCSE: Business Intelligence certification exams.

This boot camp includes all the certification exam vouchers required for certification, along with one free retake voucher for each exam, if needed. It also includes access to our Microsoft Boot Camp Exclusives, providing indispensable certification exam prep.

Although not required to attend this boot camp, it should be noted that in order to qualify for the MCSE: Business Intelligence certification candidates must either hold or obtain an MCSA: SQL Server 2012 certification as well.

MCSE Business Intelligence Boot Camp incorporates content from Microsoft Official Courses (MOC):

• Implementing Data Models and Reports with Microsoft SQL Server (M20466C)
• Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (M20467B)

You Will Cover the Objectives for these Exams:

• 70-466: Implementing Data Models and Reports with Microsoft SQL Server
• 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server

Who Should Attend:

• IT Professionals with at least three years of hands-on experience implementing and administering database systems
• Database Administrators, Systems Engineers, System Analysts and Technical Consultants who have completed the MCSA: SQL Server 2012 certification or have equivalent knowledge
• IT Professions who want to prepare for the MCSE: Business Intelligence certification

MCSE Business Intelligence Boot Camp Prerequisites:

Before attending this course, you must have the following:

• MCSA: SQL Server 2012 certification or equivalent knowledge
• Three years of hands-on experience working in a SQL Server environment
• Basic knowledge of the Microsoft Windows operating system and its core functionality
• Attended MCSA: SQL Server 2012 Boot Camp

MCSE Business Intelligence Boot Camp Objectives:

After successfully completing this course, you will be able to:

• The technical skills required to implement data models and reports with Microsoft SQL Server
• The knowledge and skills to design business intelligence solutions with Microsoft SQL Server
• Key topics and concepts addressed in the exams 70-466: Implementing Data Models and Reports with Microsoft SQL Server and 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server

Follow on Courses:

• MCSE: Data Platform Boot Camp

MCSE Business Intelligence Boot Camp Outline:

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

Module 1: Introduction to Business Intelligence and Data Modeling

• Elements of an Enterprise BI Solution
• The Microsoft BI Platform
• Planning an Enterprise BI Project
• Module 1 Lab:
• Explore BI Solutions

Module 2: Creating Multidimensional Databases

• Multidimensional Analysis
• Creating Data Sources and Data Source Views
• Creating a Cube Cube
• Security
• Module 2 Lab:
• Create a Multidimensional Database

Module 3: Working with Cubes and Dimensions

• Configuring Dimensions
• Attribute Hierarchies
• Sorting and Grouping Attributes
• Module 3 Lab:
• Define Dimensions

Module 4: Working with Measures and Measure Groups

• Measures
• Measure Groups
• Module 4 Lab:
• Configure Measures and Measure Groups

Module 5: Multidimensional Expressions (MDX)

• MDX Fundamentals
• Adding Calculations to a Cube
• Using MDX to Query a Cube
• Module 5 Lab:
• Use MDX

Module 6: Enhancing a Cube

• Implementing Key Performance Indicators
• Implementing Actions, Perspectives, and Translations
• Module 6 Lab:
• Customize a Cube

Module 7: Implementing an Analysis Services Tabular Data Model

• Tabular Data Models
• Creating a Tabular Data Model
• Using an Analysis Services Tabular Data Model in the Enterprise
• Module 7 Lab:
• Implement an Analysis Services Tabular Data Model

Module 8: Data Analysis Expression (DAX)

• DAX Fundamentals
• Using DAX to Create Calculated Columns and Measures in a Tabular Data Model
• Module 8 Lab:
• Enhance a Tabular Data Model using DAX

Module 9: Implementing Reports with Reporting Services

• Reporting Services
• Creating a Report with Report Designer
• Grouping and Aggregating Data in a Report
• Showing Data Graphically
• Filtering Reports using Parameters
• Publishing and Viewing a Report
• Module 9 Lab:
• Create a Report with Report Designer

Module 10: Enhancing Reports with SQL Server Reporting Services

• Show Data Graphically
• Filter Reports Using Parameters
• Visualizing Data with Power View
• Module 10 Lab:
• Enhance a Report

Module 11: Managing a Report Execution and Delivery

• Managing Security
• Managing Report Execution
• Subscriptions and Data Alert
• Troubleshooting Reporting Services
• Module 11 Lab:
• Configure Report Execution and Delivery

Module 12: Delivering BI with SharePoint PerformancePoint Services

• Introduction to SharePoint Server as a BI Platform
• Introduction to PerformancePoint Services
• PerformancePoint Data Sources and Time Intelligence
• Reports, Scorecards, and Dashboards
• Module 12 Lab:
• Implement a SharePoint Server BI Solution

Module 13: Performing Predictive Analysis with Data Mining

• Data Mining
• Create and Validate a Data Mining Model
• Using the Data Mining Add-In for Excel
• Using a Data Mining Model in a Report
• Module 13 Lab:
• Use Data Mining to Support a Marketing Campaign

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

Module 1: Planning a BI Solution

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

Module 2: Planning a SQL Server BI Infrastructure

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

Module 3: Designing a Data Warehouse

• Data Warehouse Design
• Designing Dimension Tables and Fact Tables
• Designing a Data Warehouse Physical Implementation
• Module 3 Labs:
• Designing a Data Warehouse Logical Schema
• Design a Data Warehouse Physical Implementation

Module 4: Designing an ETL Solution

• ETL Overview
• Planning Data Extraction, Data Transformation, and Data Loading
• Module 4 Lab:
• Designing an ETL Solution

Module 5: Designing Analytical Data Models

• Analytical Data Models
• Designing an Analytical Data Model
• Designing Dimensions
• Enhancing Data Models
• Module 5 Labs:
• Comparing Analytical Data Models
• Designing Dimensions and Hierarchies
• Enhancing Analytical Data Models

Module 6: Planning a BI Delivery Solution

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

Module 7: Designing a Reporting Services Solution

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

Module 8: Designing a Microsoft Excel-Based Reporting Solution

• Using Excel for Data Reporting and Analysis
• PowerPivot and Power View for Excel
• Module 8 Lab:
• Designing an Excel Reporting Solution

Module 9: Planning a SharePoint Server BI Solution

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

Module 10: Monitoring and Optimizing a BI Solution

• BI Monitoring Overview
• Monitoring and Optimizing the Data Warehouse, Analysis Services, and Reporting Services
• Module 10 Lab:
• Monitoring and Optimizing a BI Solution

Module 11: Operating a BI Solution

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

---

Boost your salary by obtaining your Microsoft Certification: Microsoft Certified Systems Engineer (MCSE): Business Intelligence