Skip to content

Microsoft MCSE Business Intelligence

e-Careers

Summary

Price
£800 inc VAT
Finance options

Flexible part payment options available.
Study method
Online
Duration
12 weeks · Self-paced
Qualification
No formal qualification

Overview

Create new opportunities in the IT industry using SQL Server 2012 as a foundation for building Business Intelligence (BI) and reporting solutions that deliver more data across an organisation.

Course media

Description

Students will learn how to design, build and deploy SQL Server BI solutions that deliver more data to more people across the organisation. This MCSE SQL Server Business Intelligence course also grants the student access to the Live Labs. This valuable learning resource allows candidates to design and test their own BI applications and reports using live equipment, they can also recreate scenarios in the course to ensure full retention of the concepts being taught.
The course starts with the three modules that make up the MCSA SQL Server 2012 course:
• Microsoft 70-461: Querying Microsoft SQL Server 2012
• Microsoft 70-462: Administering SQL Server 2012 Databases
• Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012


The course then continues with the two modules that make up the MCSE SQL Server 2012 Business Intelligence. The first of those modules, Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012, will take students through:
• How to work with large datasets across multiple platforms as is common in most modern BI applications and reports.
• Building Online Analytical Processing (OLAP) cubes and supporting structures such as pivot tables, PowerPivot solutions and Multidimensional Expressions (MDX) to deliver information quickly and efficiently to analysts.
• Choosing between the Unified Dimensional Model (UDM) and Business Intelligence Semantic models according to specific business data and reporting needs.
• Developing complex SQL queries to mine multiple datasets and building reports using Crescent.


Microsoft 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012:
• Designing BI solutions that meet current and future performance and scalability needs.
• Using Excel Services and SharePoint Reporting integration to allow for improved data analysis and integration with other line of business applications.
• Designing, deploying and managing SSIS package to extend BI application functionality and expose more data for reporting and modelling.

Who is this course for?

This course is suitable for IT professionals who want to reap the benefits of having the ability to deploy BI solutions in an enterprise-class environment.

Requirements

There are no prerequisites to take this course.

Career path

Professionals with the Business Intelligence qualification usually function in roles such as BI analyst, BI architect or BI developer. These roles usually offer an average salary of £40,000.
Source: payscale

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Online courses