Data Visualization Exams

 Today I finsished taking the two Data Vizualization BETA exams. Together these two exams will earn an MCSA on Business Intelligence Reporting. I can see a high demand for teaching these two courses. Definitely an area that not many people currently teach as PowerBI is only two years old. It will be interesting to see how well I did. If you watch the corresponding courses, you should do fine. Compared to other MCP exams, these are very straight forward. My one tip is to study DAX functions.

778: Data Visualization with PowerBI
779: Data Visualization with Excel

CompTIA Certifications

Reach Your Career Goals with CompTIA Certifications

The demand for skilled tech professionals continues to climb at a rapid pace. CompTIA Certifications validate your skills and start you on your path to IT career success:

Posted by CompTIA – The Computing Technology Industry Association on Friday, May 12, 2017

The CompTIA certifications are a great way to get started in the IT industry. My recommendation would be start with IT Fundamentals and go from there.

MCSA Certifications – April

 Just when I thought I had all the certifications figured out, Microsoft announced yesterday the addition of the MCSE: Business Applications (focusing on Dynamics 365) which includes two new supporting MCSA paths – MCSA: Dynamics 365 and MCSA: Dynamics 365 for Operations. Additionally, they’ve added the new MCSA: Data Science, which puts you on a path to earn an MCSE: Data Management & Analytics certification. Check out this new pdf that clearly outlines the requirements for each certification and the electives that can be taken to renew each MCSE annually. Bonus information on the pdf download is some other unannounced MCSA certifications including Cloud Database Development, Big Data Engineering, and BI reporting.

Columbus SQL User Group

On my way to the Columbus, Ohio SQL Server User Group to talk about “How to get Microsoft Certified”. Microsoft has recently streamlined the certification process and this session focuses on what you need to know to get Microsoft Certified on SQL Server. The presentation walks you through the certifications, exams, and resources available to get you ready for success. You can download the presentation here.

MCSA: Windows 2016

 Passed two exams this week during the MCT Summit. I started with the 70-740: Installation, Storage, & Compute with Windows Server 2016. This was the one I studied for on the train, because I thought I was a little rusty on Virtual Machines and Clustering. But it was the simple stuff like REFS and Data Duplication that was tripping me up during the exam. Today, I took the third and final exam needed for the MCSA: Windows Server 2016 certification. Which of course is the 70-741: Networking with Windows Server 2016 exam. Again, I breezed through the difficult parts of the exam only to be hung up on a silly subnetting question. It was like I forgot how to do math. But a few extra minutes double checking my work and I knew I had it right. So that is 9 exams and 9 certifications in the last 6 months. I think I’m going to take the rest of the year off from Microsoft exams.

MCSE: Productivity 2017

Passed the Exchange 2016 exam today with a very high score.What is humorous is that I thought it was tomorrow and had not really studied that much. I would say I took it cold, but I did just teach the Exchange 2013 class two weeks ago. One thing I was surprised about was that I thought I would only earn the Specialist certification for passing the 70-345 exam. However, since I already have the qualifying MCSA certifications, this exam re-earned my MCSE: Productivity for 2017. Not sure what I am going to do for next year. I might have to learn Sharepoint.

Passed 742 exam

So the first exam of the year is 70-742 – Identity with Windows Server 2016. A very good exam on Active Directory and Group Policy. I am taking the Window Server 2016 MCSA exams out of order, only because that seems easier for me. I am actually going to take an Exchange 2016 exam next and then come back to the other two Windows Server exams. I am so glad I have finally found some time to get to these exams. From what I can tell so far, they are not as difficult as the Server 2012 exams and are a fair test of knowledge.

Data Science Certificate

One of the interesting things about participating in a beta program is that not all the bugs are figured out. For those who participated in the three month accelerated data science program that finished on August 26, 2016, we finally received our certificates today. I have no idea what the significance of the November date on the certificate means, but I am just happy to be a Charter Member of the Microsoft Professional Program. Believe me, it was not easy. If you would like to participate in the program, you can sign up here.

Cloud Tech Summit – Chicago

I am very excited to be helping others learn new technologies and asisst them in earning new certifications. On January 19, 2017, I will be delivering two exam prep session at the Microsoft Tech Summit in Chicago. The first is for the 70-473: Cloud Data Platform exam and the second session is for the 70-475: Big Data and Analytics Solutions. Click on the appropriate link if you would like to download the powerpoint presentations.

During the session I focus on Microsoft websites, however, if you have a Pluralsight account I would recommend the following video sessions to study for the exams. For the 70-473 exam: SQL Azure by Scott Seely, SQL Server 2016 New Features by Leonard Lobel, Implement Storage for Azure by Tim Warner, and Practical SQL Server HA/DR by Russ Thomas. For the 70-475 exam: Start with the 70-473 videos and then add Applying the Lambda Architecture by Ahmad Alkilani, HDInsight Deep Dive with Elton Stoneman, and Real World Big Data in Azure by Elton Stoneman.

MCSA: SQL 2016 Development

 Last September I took the BETA exams for 70-761: Querying Data with Transact-SQL and 70-762: Developing SQL Databases. Well it looks like I passed them, because today I received an email saying I have earned my MCSA: SQL Server 2016 Database Development. I always like when I pick up a new certification, but it’s really cool to wake up and earn one you were not expecting. I am just now sure to count it towards my 2016 goals or 2017.

Exam Passed – 473

 Well, that was not as difficult as I thought it would be. I was able to pass the 70-473 exam for the Cloud Data Platform Specialist certification.  The first place to start if you are interested in passing this exam is Microsoft Virtual Academy. It has a great overview of the exam topics with some demonstrations. Next, spend some time with the Azure Documentation to walk through some very excellent tutorials.

SQL Saturday Atlanta #578

Attached is my presentation on SQL Server Certification that will be presented at SQL Saturday Atlanta: BI Edition this weekend. I have also provided useful links in getting certified on SQL Server.

Azure Exam Discounts

I am starting to work on the 70-473 exam and normally the exam would cost $165. With my MCT discount it would only be $82.50. However, right now Microsoft has a deeply discounted offer for select Azure exams. With this discount I was able to get not only the exam voucher for the 70-473 exam, but also the Measure Up Practice exam, and a free re-take for only $99. There is an even deeper discount if you are going to take 3 exams. Found out more here.