Microsoft's professional qualification
MCSE
Business Intelligence
- Contact UsView Certifications
- The cornerstone for Microsoft Certified Solutions Expert certifications.
Would you like us to send you information on this certification and be informed of any future updates and retirements?
Certification summary
The Microsoft Certified Solutions Expert (MCSE): Business Intelligence certification shows that you have the skills and ability to design, build, and deploy solutions that deliver more data to more people across your organization. In the MCSE: Business Intelligence course you will Build, Manage, Maintain and troubleshoot a SQL Server Analysis Services database, Plan and design business intelligence infrastructure, Design and build reports and data models, Design an extract, transform and load (ETL) solution. Earning an MCSE: Business Intelligence certification will qualify for a position as a BI and reporting engineer.
Exams summary
To get a MCSE: Business Intelligence certification you need to complete these five exams:
Exam 461: Querying Microsoft SQL Server 2012
Exam 462: Administering Windows Server 2012
Exam 463: Configuring Advanced Windows Sever 2012 Services
After finishing Exam 461, 462 and 463 you'll earn a Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 certification. Once you have your MCSA: SQL Server 2012 the next two exams will upgrade that to a MCSE: Business Intelligence.
Exam 466: Implementing Data Models and Reports with Microsoft SQL Server 2012
Exam 467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012
A closer look...
The Microsoft MCSE is a globally recognised qualification across the IT and telecommunications industry. A variety of government organisations, training institutions and corporations around the UK recommend or require the MCSE certification for their staff or channel partners.
Career & Job Opportunities
The Microsoft Certified Solutions Expert (MCSE) is a globally recognised qualification across the IT and telecommunications industry. A variety of government organisations, training institutions and corporations around the UK recommend or require MCSE certifications for their staff or channel partners. These includes Amazon, Dell, HP, BT and the Cabinet Office. As of 2015, the average salary of a Microsoft MCSE Professional is £40,300pa with more than 87% being offered a salary of more than £27,000pa. The average salary for a MCSE graduate is estimated to be £26,000pa. After graduation, you can find work in roles such as Systems Engineer and Support Technician with relative ease.
Start the MCSE Business Intelligence with a trial
We are offering a trial of this course for free with no purchase necessary, just sign up below to instantly receive your login details.
We will work with you to ensure that you can find work in IT after completing your Microsoft course
Working with JobcentrePlus and our Recruitment Partners across the UK, we will work with you to ensure that you can find work in IT (an not in any job) through job interviews and applications. We aim to get you in an IT job role on completion of your MCSE. If you have no qualification or background in IT, we will provide you with the necessary training for the experience required. For existing MCSE professionals, we can upgrade your qualifications and improve your career prospects. Do not allow your lack of experience or self-confidence deny you from a career in I.T - it is a lot easier (and enjoyable too) than most people think, once you learn the basics.
- ↘ Take on a new adventure with the MCSE interactive video demos
- ↘ Contact us about our Microsoft student placement service
Promotions. Gain access to the MCSE and Microsoft course library for 10 days.
If your aim is employment/career advancements through IT training, see how you can achieve this together with your tutor.
91.0%
The five exams
The MCSE Business Intelligence is the latest generation in Microsoft server technology and as such there is no current retirement plan for its exams. Below is a breakdown of the exams for this certification and how they are made up.
Exam 461
This exam measures your ability to accomplish the technical tasks listed:
- Create database objects.
- Work with data.
- Modify data.
- Troubleshoot and optimize.
Exam 461
This exam measures your ability to accomplish the technical tasks listed: Create database objects, Work with data, Modify data, Troubleshoot and optimize . Here are the percentages that make up the final mark for this exam using these technical tasks:
- Create database objects (24%)
- Create and alter tables using T-SQL syntax (simple statements)
- Create and alter views (simple statements)
- Design views
- Create and modify constraints (simple statements)
- Create and alter DML triggers
- Work with data (27%)
- Query data by using SELECT statements
- Implement sub-queries
- Implement data types
- Implement aggregate queries
- Query and manage XML data
- Modify data (24%)
- Create and alter stored procedures (simple statements)
- Modify data by using INSERT, UPDATE, and DELETE statements
- Combine datasets
- Work with functions
- Troubleshoot and optimize (25%)
- Optimize queries
- Manage transactions
- Evaluate the use of row-based operations vs. set-based operations
- Implement error handling
Try this course online, login via providing some basic student details below
Exam 462
This exam measures your ability to accomplish the technical tasks listed:
- Install and configure.
- Maintain instances and databases.
- Optimize and troubleshoot.
- Manage data.
- Implement security.
- Implement high availability.
Exam 462
This exam measures your ability to accomplish the technical tasks listed: Install and configure, Maintain instances and databases, Optimize and troubleshoot, Manage data, Implement security, Implement high availability. Here are the percentages that make up the final mark for this exam using these technical tasks:
- Install and configure (19%)
- Plan installation
- Install SQL Server and related services
- Implement a migration strategy
- Configure additional SQL Server components
- Manage SQL Server Agent
- Maintain instances and databases (17%)
- Manage and configure databases
- Configure SQL Server instances
- Implement a SQL Server clustered instance
- Manage SQL Server instances
- Optimize and troubleshoot (14%)
- Identify and resolve concurrency problems
- Collect and analyse troubleshooting data
- Audit SQL Server instances
- Manage data (19%)
- Configure and maintain a back-up strategy
- Restore databases
- Implement and maintain indexes
- Import and export data
- Implement security (18%)
- Manage logins and server roles
- Manage database permissions
- Manage users and database roles
- Troubleshoot security
- Implement high availability (12%)
- Implement AlwaysOn
- Implement database mirroring
Try this course online, login via providing some basic student details below
Exam 463
This exam measures your ability to accomplish the technical tasks listed:
- Design and implement a data warehouse.
- Extract and transform data.
- Load data.
- Configure and deploy SSIS solutions.
- Build data quality solutions.
Exam 463
This exam measures your ability to accomplish the technical tasks listed: Design and implement a data warehouse, Extract and transform data, Load data, Configure and deploy SSIS solutions, Build data quality solutions. Here are the percentages that make up the final mark for this exam using these technical tasks:
- Design and implement a data warehouse (11%)
- Design and implement dimensions
- Design and implement fact tables
- Extract and transform data (23%)
- Define connection managers
- Design data flow
- Implement data flow
- Manage SSIS package execution
- Implement script tasks in SSIS
- Load data (27%)
- Design control flow
- Implement package logic by using SSIS variables and parameters
- Implement control flow
- Implement data load options
- Implement script components in SSIS
- Configure and deploy SSIS solutions (24%)
- Troubleshoot data integration issues
- Install and maintain SSIS components
- Implement auditing, logging, and event handling
- Deploy SSIS solutions
- Configure SSIS security settings
- Build data quality solutions (15%)
- Install and maintain data quality services
- Implement master data management solutions
- Create a data quality project to clean data
Try this course online, login via providing some basic student details below
Exam 466
This exam measures your ability to accomplish the technical tasks listed:
- Build an analysis services database.
- Manage, maintain and troubleshoot an SSAS database.
- Build a tabular data model.
- Build a report with SQL Server Reporting Services (SSRS).
Exam 466
This exam measures your ability to accomplish the technical tasks listed: Build an analysis services database, Manage, maintain and troubleshoot an SSAS database, Build a tabular data model, Build a report with SQL Server Reporting Services (SSRS). Here are the percentages that make up the final mark for this exam:
- Build an analysis services database (38%)
- Design dimensions and measures
- Implement and configure dimensions in a cube
- Design a schema to support cube architecture
- Create measures
- Implement a cube
- Create Multidimensional Expressions (MDX) queries
- Implement custom logic in a data model
- Implement storage design in a multidimensional model
- Select an appropriate model for data analysis
- Manage, maintain and troubleshoot an SSAS database (18%)
- Analyse data model performance
- Process data models
- Troubleshoot data analysis issues
- Deploy SSAS databases
- Install and maintain an SSAS instance
- Build a tabular data model (17%)
- Configure permissions and roles in Business Intelligence Semantic Model (BISM)
- Implement a tabular data model
- Implement business logic in a tabular data model
- Implement data access for a tabular data model
- Build a report with SQL Server Reporting Services (SSRS) (28%)
- Design a report
- Implement a report layout
- Configure authentication and authorization for a reporting solution
- Implement interactivity in a report
- Troubleshoot reporting services issues
- Manage a report environment
- Configure report data sources and datasets
Try this course online, login via providing some basic student details below
Exam 467
This exam measures your ability to accomplish the technical tasks listed:
- Plan business intelligence (BI) infrastructure.
- Design BI infrastructure.
- Design a reporting solution.
- Design BI data models.
- Design an ETL solution.
Exam 467
This exam measures your ability to accomplish the technical tasks listed: Plan business intelligence (BI) infrastructure, Design BI infrastructure, Design a report solution, Design BI data models, Design an ETL solution. Here are the percentages that make up the final mark for this exam:
- Plan business intelligence (BI) infrastructure (15%)
- Plan for performance
- Plan for scalability
- Plan and manage upgrades
- Maintain server health
- Design BI infrastructure (16%)
- Design a security strategy
- Design a SQL partitioning strategy
- Design a backup strategy
- Design a logging and auditing strategy
- Design a reporting solution (24%)
- Design a Reporting Services dataset
- Manage Excel Services/reporting for SharePoint
- Design a data acquisition strategy
- Plan and manage reporting services configuration
- Design BI reporting solution architecture
- Design BI data models (34%)
- Design the data warehouse
- Design a schema
- Design cube architecture
- Design fact tables
- Design BI semantic models
- Design and create MDX calculations
- Design an ETL solution (11%)
- Design SSIS package execution
- Plan to deploy SSIS solutions
- Design package configurations for SSIS packages
Try this course online, login via providing some basic student details below
This course is suitable for...
School leavers
A fun and enjoyable way to build a fresh career
Teachers & IT professionals
A prestigious qualification which will distinguish you from the crowd of 21st century geeks
Anyone else...
Looking to start a healthy, rewarding & lucrative career in I.T
But is this course right for you?
Will it provide you with the skills that you need, or the career you'd like to explore? If you are not 100% sure that it's correct for you then we highly recommend that you experience our trial courses and assessments to get an accurate insight to the MCSE certification. You can sign up for this below or use it to ask our lecturers some questions. You can also call us on 0800 622 69 69 and speak to one of our course advisers and they will help you choose the perfect certification tailored to your needs.
More Information
Request more info on the MCSE: Business Intelligence course
Exam tips and syllabus
Get the MCSE: Business Intelligence exam syllabus aswell as helpful tips
What our students say
See what our students have to say about the MCSE: Business Intelligence