Skip to content

Updated Microsoft Certification Goals

Updated Microsoft Certification Goals - MCSE: Data Management and Analytics

It has been several years since I last studied for a Microsoft Certification. (Insert your favorite saying about how time flies and life changes here!) Back in February 2014, I started working towards the old MCSE: Business Intelligence. The first step was to earn the MCSA: SQL Server 2012/2014. It took longer than I expected, including a frustrating experience trying an online proctored exam, but I finally passed the last of the three required exams in May 2015.

By then, my goals had changed. Varigence had announced the BimlHero Certified Expert program, and I decided to put the MCSE on hold for a while. Sorry, Microsoft, Biml was just more fun! :) In February 2016, after 10 months of working on the Biml certification, I became the second BimlHero in the world.

My plan was always to resume studying for MCSE: Business Intelligence. But, surprise surprise, things changed again. My new jobs required a lot of traveling, and I even put tech on hold for over a year while working in a community-facing role. I challenged myself in different ways by speaking and delivering workshops. In short, I chose to focus on developing other skills.

We are now almost halfway through 2018 and I am finally ready to continue working towards my next Microsoft Certification. Except for the tiny little detail that I was so slow that the certification I originally set as my goal no longer exists. Hahaha! :) Instead of the old MCSE: Business Intelligence, my updated goal is…

Microsoft Certified Solutions Expert: Data Management and Analytics

MCSE: Data Management and Analytics

“Demonstrate your broad skill sets in SQL administration, building enterprise-scale data solutions, and leveraging business intelligence data – both on-premises and in cloud environments.”

To earn the MCSE: Data Management and Analytics, you need to:

  • Earn an MCSA
  • Pass one additional exam

Since I already have the MCSA: SQL Server 2012/2014, I only need to pass one additional exam to earn my MCSE: Data Management and Analytics.

There are currently several exams to choose from, and a few of them are also required for other MCSAs. I figured if I’m going to study for one exam for the MCSE, why not just continue studying for another exam and earn a newer MCSA as well? My second, updated goal is…

Microsoft Certified Solutions Associate: SQL 2016 BI Development

MCSA: SQL 2016 BI Development

This certification validates your extract, transform, and load (ETL) and data warehouse skills, along with those for implementing BI solutions using multidimensional and tabular data models and online analytical processing (OLAP) cubes.

To earn the MCSA: SQL 2016 BI Development, you need to pass two exams:

I will blog about my experiences preparing for and taking these exams in separate blog posts.

The 70-767 exam is the one I have most hands-on experience with and the one that I will attempt first. The 70-768 exam will be more difficult since I have less project experience, but I’m very much looking forward to digging into and learning these topics. If all goes well, I hope to earn my MCSE and my second MCSA by the end of the summer :)

Update: Goals Achieved!

MCSE: On June 5th, 2018, I passed exam 70-767! Since I already had an older MCSA, this meant that I also became a Microsoft Certified Solutions Expert: Data Management and Analytics. I later wrote about my experiences preparing for and taking Exam 70-767.

MCSA: On July 31st, 2018, I passed exam 70-768! This was the second exam I needed to pass to become a Microsoft Certified Solutions Associate: SQL 2016 BI Development. I later wrote about my experiences preparing for and taking Exam 70-768.

About the Author

Cathrine Wilhelmsen is a Microsoft Data Platform MVP, BimlHero Certified Expert, Microsoft Certified Solutions Expert, international speaker, author, blogger, and chronic volunteer who loves teaching and sharing knowledge. She works as a Senior Business Intelligence Consultant at Inmeta, focusing on Azure Data and the Microsoft Data Platform. She loves sci-fi, chocolate, coffee, craft beers, ciders, cat gifs and smilies :)

Comments

Hi! This is Cathrine. Thank you so much for visiting my blog. I'd love to hear your thoughts, but please keep in mind that I'm not technical support for any products mentioned in this post :) Off-topic questions, comments and discussions may be moderated. Be kind to each other. Thanks!

Fingers crossed for all mentioned goals Cathrine! I’ve reached that MCSE a year ago and now I feel like I should accede to another one.

Thank you, Kamil! It’s a lot of hard work, but that makes it feel even better when you finally succeed :) I’m considering the MCSA: Data Engineering with Azure next, but I’ll save that for another blog post. One step and one goal at the time ;)

You can do it! Stacia Misner has some great videos on Pluralsight and I think she wrote the exam reference books.

Thanks, John! I can and will do it, just have to keep working until I reach my goal :)

Go Cathrine.. these are not as hard as you might think especially for you
I’ve a few more exams to add in coming months.. #neverstoplearning

Thanks, Neil, and best of luck to you too! :)

Hello Cathrine, I am a fresher with no experience but i have decent knowledge of SQL. I would like to become Database developer and also BI development. I am confused between MCSA: SQL Server 2012/2014 and MCSA: SQL 2016 Database Development certifications. Which one am I supposed to take? Can you please guide me.

I usually recommend pursuing the newest certifications, except if you know that you will not be able to use that technology for years to come. What do you find confusing about the two MCSAs you mention? One is focused on SQL Server 2012/2014 technologies and covers development, administration, and business intelligence. The other is focused on SQL Server 2016 technologies, but only covers development. (There are two other MCSAs focused on SQL Server 2016 that covers administration and business intelligence.)

Hi, first off, congrats for your double MCSA and renewing MCSE. I had been planning for 70-767 and this article of yours is very helpful and complete.
I needed a clarification: I was also thinking why not go for MCSE by passing 70-761, 70-762 and 70-767. My question is if I take 70767 first and then MCSA by 70761+70762, will I get MCSE or not? Microsoft specified that MCSA is required then 1 more exam for MCSE. If I pass 70767 then get MCSA, will I get MCSE or I need to pass 70761+762 to earn MCSA and then only sit for 70767?
Thanks in advance.

Hi Kazi, you can take the exams in any order. What’s important is that you pass all three required exams. If you take the 70-767 exam first, then 70-761, and finally 70-762, you will get both your MCSA and MCSE after you pass the third exam. This is an unconventional route, though. I’m guessing that it’s easier for Microsoft to guide people down the “first MCSA, then MCSE” path, as well as more rewarding for most people to first get an MCSA title and then the MCSE title – as opposed to postponing all rewards until after the third exam has been passed :) Good luck!

Hi ,
Could you please confirm if I will pass below two exams than can I get MCSE: Data Management and Analytics ? OR I need to pass any other exam as well?

70-767: Implementing a Data Warehouse using SQL
70-768: Developing SQL Data Models

Thanks

No, those two exams alone will not earn you MCSE: Data Management and Analytics. It will only earn you MCSA: SQL 2016 BI Development. After you earn your MCSA, you will need to pass a third exam to earn the MCSE. All the details are available on Microsoft’s MCSE: Data Management and Analytics page.

But these two are already part of MCSE. I am confused about these . For both the exams it is mentioned that Credit toward certification: MCSA, MCSE https://www.microsoft.com/en-us/learning/exam-70-768.aspx .

Yes, they are part of the MCSE, but not the only requirements for MCSE. In addition to those two exams, you will need to pass a third exam to earn your MCSE. Please go to the MCSE: Data Management and Analytics page, scroll down to “Certification Exams and prep resources”, and expand each step. There, you will find all the details.

Hi! This is Cathrine (again). Just a reminder. I'd love to hear your thoughts, but please keep in mind that I'm not technical support for any products mentioned in this post :) Off-topic questions, comments and discussions may be moderated. Be kind to each other. Thanks!

Share Your Thoughts?