MCSE Business Intelligence
This page provides a brief guide to the MCSE Business Intelligence certification path. Obtaining Microsoft Certified Solutions Expert level certification demonstrates that you have reached Microsoft's global standard for IT professionals. MCSE Business Intelligence shows that you have the skills and abilities required to plan, construct and deploy a wide range of solutions to deliver data to personnel across variable sized organisations. Such certification will provide you with a competitive edge against others applying for positions in Business Intelligence or related roles. Note that this certification must be re-examined every three years, so as to be valid on the latest Microsoft products.
The Certification Process
In order to obtain MCSE: Business Intelligence certification you will need to pass two separate exams, in addition to having passed the exams necessary to earn an MCSA: SQL Server certification. These exams are arranged separately from any training courses offered, further information on any individual exam can be seen by clicking on the corresponding title.
- Exam 70-466 Implementing Data Models and Reports with Microsoft SQL Server
- Exam 70-467 Designing Business Intelligence Solutions with Microsoft SQL Server
If you hold MCITP: Business Intelligence Developer 2008 in addition to MCSA SQL Server 2012 then you can upgrade to MCSE: Business Intelligence by taking one exam only.
- Exam 70-460 Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence
Preparing for the Exams
MCSE exams comprise of between 40 and 60 questions, drawn approximately equally from each section of examinable material. These exams are between 3 and 4 hours long. It is recommended that you should err on the side of over preparation to prevent any weaker areas resulting in a mark that is not high enough to provide a pass.
For further information on Microsoft exams in general, take a look at the Microsoft Certification exams page.
GBdirect offer the full range of Microsoft approved courses aimed to provide the skills and knowledge required to earn this certification. The courses offered are:
- Microsoft Course 10778 - Implementing Data Models and Reports with Microsoft SQL Server
- Microsoft Course 20467 - Designing Self-Service Business Intelligence and Big Data Solutions
For those who wish to take the Business Intelligence upgrade exam you may want to consider taking the following course:
These courses will help prepare you for the exams but may not provide you with everything you need to pass them. To ensure a pass we would recommend as much hands-on experience with the product as possible, in addition to further reading from either Microsoft instructional material or reference texts. Performing practice labs detailed either in Microsoft Press books or following the procedures on the TechNet can also be greatly beneficial, practice tests are also available from some companies, notably Transcender, MeasureUp and Kaplan SelfTest. We welcome any reviews of your Microsoft Certification experience, if you feel that you know of an improved learning method then please don't hesitate to get in touch.
Official Microsoft Materials
Microsoft provides some online materials on each exam page itself, notably the TechNet entries along with any other information relevant to each individual segment of the exam, these links can usually be found in the "Skills measured" section of each exam page on Microsoft's site, however these higher level SQL Server exams seem to be somewhat neglected and therefore there may be a large number of missing entries. . Such entries should not only specify what sort of content is examinable but should also give enough information to greatly aid in the learning or revision process. Some of the information can also be found on the Microsoft Developer Network, with more detailed information found within the Books Online section within the Product Documentation heading.
In addition to this Microsoft offers a variety teaching materials through the Microsoft Virtual Academy, these are ideal for either introducing yourself to a new area, or ensuring that your knowledge is not lacking in any particular area. The majority of such courses are aimed at those taking somewhat lower certifications; however you may find them valuable in covering particular of weakness or for general revision purposes.
Microsoft also hosts a wiki and small forum for each individual exam, while the wiki helpfully organises the links to TechNet articles and other Microsoft blogs etc. the forums tend to be underused.
While Microsoft Press usually provides a number of books aimed at those taking the exams required for certification there are as of yet no texts available for the MCSE: Business Intelligence exams, this list will be updated once they become available.
Non-Microsoft Press books
Professional Microsoft SQL Server 2014 Administration As MCSE certifications are now expected to cover the 2014 iteration of Microsoft SQL server this book acts as an excellent guide to the product as a whole, as well as being useful for those with a good knowledge of SQL server 2012 who are looking for details on key changes.
For changes and updates relevant to BI applications specifically, you may wish to consider Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide, which receives reviews praising its depth and variety of content on business intelligence topics.
Pro SQL Server 2012 BI Solutions This book receives highly favourable reviews, mainly due to its wide range of BI issues as well as a very easy to follow format. While this book may be best suited to those who are less experienced with BI in SQL Server 2012 reviews indicate that there is sufficient detail to make this an excellent reference text and learning resource for anyone dealing with BI on SQL Server 2012.
Delivering Business Intelligence with Microsoft SQL Server 2012 This books also receives very good reviews on the whole. The book is another with a high level of detail in addition to step-by-step instructions for use in practical tasks. This text contain a wide variety of examples, complete with screenshots while still remaining simple enough for someone of a lower or intermediate level to understand easily.
Professional Microsoft SQL Server 2012 Administration Most reviewers also agree that this is a clear and concise guide to the whole of SQL Server 2012, thus making this an excellent reference text, potentially proving useful when working on practice labs or looking up a particular issue. Earlier editions reportedly contain a significant number of errors.
Other titles from the Professional series could prove valuable for those desiring further study in particular areas, with most of these titles receiving largely positive reviews.
Microsoft SQL Server 2012 Bible This book is another that while covering a very large number of features appears to lack detail in particular areas such as encryption. Despite this the book is seen as being highly user friendly with detailed explanations in addition to sample code being included in the main text. Therefore this can serve as a good reference guide for mid-level users who are seeking to qualify for this certification.
Microsoft SQL Server 2012 Step by Step Most reviews appear to agree that this book servers very well as a guide to using SQL Server 2012, with clear instructions in a logical order, thus it can greatly aid in providing practical experience when used as an aid to assist in performing labs. Some reviewers indicate that this text may not be the best choice if you are already highly familiar with using SQL Server 2012; however it is a very good guide for those with less experience, or experience from previous product iterations.
We welcome reviews and views of any text you have personal experience with, likewise if you feel we have missed off a more valuable study aid please do get in touch.
The Techexams.net forum is one of the most active and helpful for those taking exams leading to either the MCSA or MCSE certification.
A wide variety of blogs are available detailing both exam specific tips and general advice on SQL Server, while this is by no means an exhaustive list the following blogs could prove useful in obtaining your certification.
- The ACE team Blog Used by Microsoft as their general certification tips outlet this blog can potentially be useful although some of their videos can prove rather irritating.
- MSSQLTips This page provides a highly detailed framework for earning virtually any certification involving SQL server, with further links leading to more detailed information on the topics that will be examined in these exams.
- SQL Server Blog This resource comes from the TechNet and covers a wide range of topics linked to SQL Server. This ranges from updates about online training available, new features and guides to some specific tasks.
- How I prepared myself for the MCSE certification Unsurprisingly this blog post features a fairly detailed picture of exactly what sort of preparation went on prior to taking the certification exams. This includes a list of resources used and also some information on the earlier exams in the certification path.
- Passed 70-466 and 70-467 Exams + Study Guides This post gives a list of resources used to prepare for each exam, as well as thoughts on what some of the most pressing questions were and the certification as a whole.
Unfortunately as of yet there are no practice exams that do not come into conflict with Microsoft's anti cheating policy.
What if I fail?
Don't panic. You will be able to see and your test result and the areas you felt weakest in, focus on content areas where your performance was weakest and areas with a high percentage of questions. Once you feel ready you can reschedule your exam. The following text is taken from Microsoft's exam security policy and details their exam retake policy.
Exam retake policy
- If a candidate does not achieve a passing score on an exam the first time, the candidate must wait at least a 24-hour period before retaking the exam.
- If a candidate does not achieve a passing score the second time, the candidate must wait at least a 14-day period before retaking the exam a third time.
- A 14-day waiting period will also be imposed for the fourth and fifth subsequent exam retakes. A candidate may not take a given exam any more than five times per year (12 months). This 12-month period would start the day of the fifth unsuccessful exam retake. The candidate would then be eligible to retake the exam 12 months from that date. In order to take a given exam more than five times per year, a candidate must submit a request and obtain prior permission from Microsoft.
Excellent, you've passed
As with other Microsoft exams passing a certification exam will lead to an update to your account on the Microsoft Certified Professional (MCP) site, allowing you to share copies of your exam transcripts to prove your certification to potential employers. In addition to this you will gain aces to the tools to create and download certification logos upon completion of the certification as a whole.
MCSE, Salary and Contract Rate
A recent survey of IT jobs offered across the UK reported the following statistics on the average earning of salaried and contract workers holding MCSE certification. The UK average salary for an MCSA is £42,000, with the average salary for the City of London being £45,000. A breakdown of this shows 90% are offered a salary of more than £26,000 while 10% are offered more than £55,000. Contractor daily rates were also surveyed and the UK average was found to be £325 per day and £350 per day for London. The further breakdown of these figures shows that 90% are offered a daily rate in excess of £175 while 10% are offered more than £425. Further details can be found on the IT Jobs Watch site.