MCSE Business Intelligence

Speak to us about 0% finance.

MCSE Business Intelligence

Course Information

MCSE Business Intelligence

Course Details

Certification: MCSE Business Intelligence
Vendor: Microsoft
Course prerequisite: You will be required to have gained the MCSA: SQL Server 2012 certification.
Study time: 20-30 hours per course
Practical learning: Practice labs are available for the MCSE Business Intelligence courses.

Certification Details

The MCSE: Business Intelligence certification requires you to study two courses and pass both of the applicable exams associated with these training courses.

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

Successful completion of these two courses and a passing mark for each exam will result in the MCSE: Business Intelligence certification which is awarded by Microsoft.

Career Path Opportunities

Business Intelligence Analyst
Reporting Manager
Business Intelligence Specialist
Business Intelligence Consultant
Business Intelligence Manager
Business Intelligence Developer

What's Included

  • Implementing Data Models and Reports with Microsoft SQL Server 2012 (70-466)
  • Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (70-467)
  • 12 months unlimited access
  • Student mentor
  • Student care team
  • Career support

Why Learn With Us

Let us help you become the best you can be.

Career Support

Students receive access to our recruitment resource pack which includes our CV review guide, enabling you to showcase your new skills.

Learn more

Student Support

Our dedicated student support team is only a phone call or email away, to answer your questions and help you prepare for exams.

Learn more

Flexible Finance

Our 0% interest finance plans are fully flexible and range from 6 to 12 months, allowing you to enrol on your course with complete peace of mind.

Learn more

Partnered with Leaders

We partner with the world’s leading course providers to make sure you have high-quality learning materials that will accelerate your learning.

Learn more

Expert Team

Our team undergo daily training for the latest updates and demands in the industry, to help find you the perfect role to begin your career.

Learn more

Get This Qualification On Your CV

Transform your career today

Validate your technical expertise with industry recognised certifications from the world's biggest software maker, Microsoft

Course Curriculum

MCSE (Microsoft Certified Solutions Expert): Business Intelligence

Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012
  1. Introduction To Business Intelligence And Data Modeling
  2. Implementing Reports The SQL Server Reporting Services
  3. Supporting Self Service Reporting
  4. Managing Report Execution And Delivery
  5. Creating Multidimensional Databases
  6. Working With Cubes And Dimensions
  7. Working With Measures And Measure Groups
  8. Introduction To MDX
  9. Customizing Cube Functionality
  10. Implementing A Tabular Data Model
  11. Introduction To DAX
  12. Implementing An Analysis Services Tabular Data Model
  13. SQL Analysis Services
  14. Creating Data Visualizations With Power View
  15. Supporting Self Service Reporting
  16. Performing Predictive Analysis With Data Mining
  17. Predictive Analytics
Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012
  1. Intro To Business Intelligence 
  2. Database Essentials 
  3. Business Intelligence Development 
  4. Business Intelligence Results 
  5. Advanced Reporting And Development 
  6. SQL Server Integration Services (SSIS) 
  7. SQL Server 2014 New Features 
  8. Course Review And Exam Prep

Why Get Qualified?

Gain new skills and knowledge

Thinking ahead and learning the skills needed to move forward in your current career path will mean you are more likely to be considered for future roles.

Gain credibility early in your career

A certification from IT Online Learning shows prospective employees that you have the right skills and credentials needed to succeed in your career.

Increase your opportunity for promotion

Gaining the right set of qualifications will increase your chances of moving into a supervisory or management role, giving you the opportunity to increase your salary.

Average Salary Projection

Source: Adzuna
Average Salary
Business Intelligence Consultant
Average Salary
You Can Earn
Average Salary
Business Intelligence Analyst

Salary Projection

Average Salary

Business Intelligence Developer


You can earn an average of £53k a year

Enquire About MCSE Business Intelligence

  • This field is for validation purposes and should be left unchanged.

Learn more about how we use your data.