MCSE Business Intelligence Certification Training

The 10 day MCSE Business Intelligence certification is for those who are looking for a poition as a BI and reporting engineer.

Pre-requisites

Before attending this course, students must have:

• Working knowledge of relational databases.
• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Before attending this course, students should have:
• Basic understanding of virtualization technology (Classroom labs utilize virtual machines)

To help you prepare for this class, review the following resources:

• Book: T-SQL Fundamentals for Microsoft SQL Server 2012 and SQL Azure
• MCTS Self Paced Training Kit 70-461

Our 10 day MCSE Business Intelligence certification comprises of the following courses:

Querying Microsoft SQL Server 2012 (course M10774)

• Write SELECT queries
• Query multiple tables
• Use built-in functions
• Use subqueries
• Execute stored procedures
• Use set operators
• Implement error handling
• Implement transactions
• Use table expressions
• Sort and filter data
• Use window ranking, offset and aggregate functions
• Query SQL Server metadata
• Program with T-SQL
• Improve query performance

Administering Microsoft SQL Server 2012 Databases (course M10775)

• Plan and install SQL Server.
• Describes the system databases, the physical structure of databases and the most common configuration options related to them.
• Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.
• Create SQL Server Backups.
• Restore SQL Server databases.
• Use the import/export wizards and explain how they relate to SSIS.
• Work with SQL Server security models, logins and users.
• Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles.
• Work with permissions and the assignment of permissions.
• Work with SQL Server Audit.
• Work with SQL Server Agent, jobs and job history.
• Implement SQL Server agent security, proxy accounts and credentials.
• Configure database mail, alerts and notifications.
• Create database maintenance plans.
• Work with SQL Profiler and SQL Trace stored procedures.
• Introduce DMVs and the configuration of data collection.
• Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.
• Troubleshoot SQL Server databases

Implementing a Data Warehouse with Microsoft SQL Server 2012 (course M10777)

• Describe data warehouse concepts and architecture considerations.
• Select an appropriate hardware platform for a data warehouse.
• Design and implement a data warehouse.
• Implement Data Flow in an SSIS Package.
• Implement Control Flow in an SSIS Package.
• Debug and Troubleshoot SSIS packages.
• Implement an SSIS solution that supports incremental data warehouse loads and changing data.
• Integrate cloud data into a data warehouse ecosystem infrastructure.
• Implement data cleansing by using Microsoft Data Quality Services.
• Implement Master Data Services to enforce data integrity.
• Extend SSIS with custom scripts and components.
• Deploy and Configure SSIS packages.
• Describe how information workers can consume data from the data warehouse

Implementing Data Models and Reports with Microsoft SQL Server 2012 (course M10778)

• 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

Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (course M20467)

• 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

Exams to be taken after completing the 10 day MCSE Business Intelligence certification:

• Exam 70-461 - Querying Microsoft SQL Server 2012
• Exam 70-462 - Administering Microsoft SQL Server 2012 Databases
• Exam 70-463 - Implementing a Data Warehouse with Microsoft SQL Server 2012
• 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