MCSE Business Intelligence Certification Training

Microsoft The Knowledge Academy Best Price Guarantee
  • Microsoft accredited training provided by the Largest Training Company Globally
  • GUARANTEED LOWEST PRICE IN THE INDUSTRY
  • Our Microsoft training courses are fully accredited by Microsoft using latest hardware and software
  • Exam Pass Guarantee: Book on any of our Microsoft courses and we guarantee that you will pass your exam. See Below FAQs
  • All Microsoft courses include exclusive Microsoft exam preparation guidance, course materials and pre & post course support
  • Get the Career Advantage you deserve in just
  • Minimise your time off work and maximise your fututre income by 25%
  • Flexibility on dates, so book on a date that suits you!
  • Microsoft certifications delivered by world class Microsoft instructors in luxury venues
  • Book Online or Call 01344 203 999 to speak to a Microsoft Training advisor

 

Browse our list of upcoming courses below

Book online or call 01344 203999 for FREE advice or to confirm your place

Please note course availability is limited*

Course Filter

Course Date Venue Duration Price Book Online
MCSE Business Intelligence Certification 08/09/2014 Liverpool 10 days £4995 Book OnlineEnquire
MCSE Business Intelligence Certification 08/09/2014 Norwich 10 days £4995 Book OnlineEnquire
MCSE Business Intelligence Certification 08/09/2014 Leicester 10 days £4995 Book OnlineEnquire
MCSE Business Intelligence Certification 08/09/2014 Sheffield 10 days £4995 Book OnlineEnquire
MCSE Business Intelligence Certification 08/09/2014 Swindon 10 days £4995 Book OnlineEnquire
MCSE Business Intelligence Certification 08/09/2014 Plymouth 10 days £4995 Book OnlineEnquire
MCSE Business Intelligence Certification 08/09/2014 Aberdeen 10 days £4995 Book OnlineEnquire
MCSE Business Intelligence Certification 08/09/2014 Cambridge 10 days £4995 Book OnlineEnquire
MCSE Business Intelligence Certification 08/09/2014 Belfast 10 days £4995 Book OnlineEnquire
MCSE Business Intelligence Certification 08/09/2014 Dublin 10 days €4995 Book OnlineEnquire
MCSE Business Intelligence Certification 08/09/2014 Nottingham 10 days £4995 Book OnlineEnquire
MCSE Business Intelligence Certification 08/09/2014 Southampton 10 days £4995 Book OnlineEnquire
MCSE Business Intelligence Certification 08/09/2014 Bristol 10 days £4995 Book OnlineEnquire
MCSE Business Intelligence Certification 08/09/2014 Newcastle 10 days £4995 Book OnlineEnquire
MCSE Business Intelligence Certification 08/09/2014 Reading 10 days £4995 Book OnlineEnquire
MCSE Business Intelligence Certification 08/09/2014 Milton Keynes 10 days £4995 Book OnlineEnquire
MCSE Business Intelligence Certification 08/09/2014 Edinburgh 10 days £4995 Book OnlineEnquire
MCSE Business Intelligence Certification 08/09/2014 Leeds 10 days £4995 Book OnlineEnquire
MCSE Business Intelligence Certification 08/09/2014 Cardiff 10 days £4995 Book OnlineEnquire
MCSE Business Intelligence Certification 08/09/2014 Glasgow 10 days £4995 Book OnlineEnquire
Previous Page Page 1 of 39
Next Page
  • What is the Exam Pass Guarantee?

    Our exam pass guarantee gives you confidence that we will support your learning until you pass your Microsoft exam. We guarantee that you will pass your Microsoft exam after completing our Microsoft certification. All we require is for you to take the exam within 30 days of completing the class. Attend all class days and complete all class assignments. If you do not pass the exam after the 1st attempt, we will allow you to attend the class again free of charge. Should you fail the exam on your 2nd attempt, you will be eligible to enrol in the class again, free of charge. Microsoft examination results must be verified to confirm re-enrolment and is subject to availability.

  • Who is this course for?

    Those who are looking for a poition as a BI and reporting engineer.

  • What are the 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

  • What exam(s) are valid for the course(s)?

    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

  • How do I book my exam(s)?

    Please visit the Prometric website to book your exam using the following web address - www.register.prometric.com/ClientProgram.asp

  • What certification will this lead to?

    You will obtain the MCSE (Microsoft Certified Solutions Expert) in Business Intelligence

The Knowledge Academy MCSE Business Intelligence Certification 10 day course covers the following topics:

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
  • The Knowledge Academy Courseware Book
  • Exam preperation
  • Manual
  • Certificate
  • Experienced Instructor
  • Refreshments

There hasn't been any testimonials submitted to this course

We do not currently have a video for this course