MCSE: Business Intelligence
Microsoft Certified Solutions Expert: Business Intelligence
Stay Current! Would you like us to send you information on the current MCSE tracks and be informed of any future updates and retirements?
What is the MCSE Business Intelligence?
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.
To get a MCSE: Business Intelligence certification you need to complete these five exams:
Exam 461: Querying Microsoft SQL Server 2012
Exam 462: Administering Microsoft SQL Server 2012 Databases
Exam 463: Implementing a Data Warehouse with Microsoft SQL Server 2012
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
After finishing all five of these exams you will be awarded a MCSE: Business Intelligence qualification. See below for more information on the exams.
Jobs and Career Opportunities with the MCSE Business Intelligence
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 2020, 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. Below is a short list of the range of career opportunities offered to MCSE Server Infrastructure Professionals:
|
• Systems Engineer
• Information and Network Security Analyst
• Database Architect and Design
• Database Analyst |
• Systems Support Administrator
• Data Centre Specialist
• Hardwares, Computers and Server Virtualization Technician
• Field Server Service Technician |
MCSE Training
We want to ensure you get the best training experience for the best price. Our state of the art and modern classes ensures you get the best and a fun learning experience while finishing your certification the shortest amount of time possible. While working through your MCSE course we offer 24 hour support 7 days a week and incase you get really stuck you can call your lecturers for a 1on1 chat whenever you need.
Working with JobcentrePlus and our Recruitment Partners across the UK, we will work with you to ensure that you can find work in IT (and not in any job) through job interviews and applications. We aim to get you on a graduate job 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.
Course Exam Details:
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
- • Click here to request the full 70-461 Exam Syllabus and further exam details, including:
- Number of exam questions
- Duration of exam
- Passing score
- Exam prices in the UK
- Exam preparation tips
Exam 462:
This exam measures your ability to accomplish the technical tasks listed: Install and configure, Mantain 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
- • Mantain 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 analyze 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
- • Click here to request the full 70-462 Exam Syllabus and further exam details, including:
- Number of exam questions
- Duration of exam
- Passing score
- Exam prices in the UK
- Exam preparation tips
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
- • Click here to request the full 70-463 Exam Syllabus and further exam details, including:
- Number of exam questions
- Duration of exam
- Passing score
- Exam prices in the UK
- Exam preparation tips
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%)
- Analyze 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
- • Click here to request the full 70-466 Exam Syllabus and further exam details, including:
- Number of exam questions
- Duration of exam
- Passing score
- Exam prices in the UK
- Exam preparation tips
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
- • Click here to request the full 70-467 Exam Syllabus and further exam details, including:
- Number of exam questions
- Duration of exam
- Passing score
- Exam prices in the UK
- Exam preparation tips
|