This post is the reference of the certifications in the area of BI. It started with the MCSA (which stands for Microsoft Certified Solutions Associate) SQL 2016 BI Development and was extended to the more advanced MCSE Microsoft Certified Solutions Expert: Data Management and Analytics.These certifications were replaced by the role based Azure certifications. In this post (https://www.mmertens.eu/2022/07/azure-role-based-certifications-for-data/) I describe the two possible transitions, where I’m on the “Scientist” path with DP-100 and DP-500.
This post is the reference of my certifications in the area of Machine Learning. It starts with the “old” MCSA (which stands for Microsoft Certified Solutions Associate) Machine Learning. With the switch to the role based certifications for Azure I firstly achieved the AZ-900 Azure Fundamentals, then the DP-100 Azure Data Scientist Associate.
In the years 2017 to 2019 Microsoft provided several professional education programs, and named them “Microsoft Professional Program for …”. I took part in the programs for Data Science and Artificial Intelligence, which had some overlap. The programs were set up as online courses through EDX, an online university. There were about 12 courses for each program. Typically you would need from one to four weeks per course, so overall it took nearly 2 years for me to do this besides my normal work.
In the top menu or using the following link https://www.mmertens.eu/power-bi-search, you reach a customized google search engine. It mainly works by defining the websites in which the search happens, rather than searching the whole internet. In this case, I loaded the URLs of the Power BI / SQL / Azure blogs into the customized engine. I know many good blogs, I did some research to find more, and I especially looked at the profiles of all 364 (as of July 2022) Microsoft Most Valuable Professionals (MVPs) for Data Platform – and added their blogs if they had one. I added some documentation sites like the Microsoft documentation, but also dax.guide or the Tabular Editor documentation.
AdventureWorks is one of the standard demo models from Microsoft for SQL Server. There is a data warehouse version (DW), an OLTP and a light OLTP (LT) version. They are versioned according to the SQL Server (on premises) version schema, which is basically the year (there used to be a 2008R2, but this naming schema wasn’t used any more). So the latest version of the datawarehouse (and I’m not interested in OLTP) is AdventureWorksDW2019. Now the confusion starts.
Back in 2019, Microsoft introduced a new model for their certifications, called “role-based certifications”. The old certifications like MCSE (Microsoft Certified Solution Expert) and MCSA (Microsoft Certified Solution Associate) are gone. Also the Microsoft Professional Programs (they were not so well known) are gone. Have a look at this blog entry if you want to read about data certifications and the professional program in the past: https://www.mmertens.eu/2018/08/microsoft-data-certifications/
I recently started posting on medium.com. For the english version of the article follow this link (and follow me there, please): https://medium.com/@michael_mertens/udacity-or-coursera-for-azure-machine-learning-certificates-e5514f66432b In diesem Blogbeitrag vergleiche ich die Udacity- und die Coursera-Plattform anhand eines Beispiels, eines Azure Machine Learning-Abschlusses.Beide Plattformen verfolgen das Konzept, Kurse in einem größeren Kontext zu verbinden und dabei ein wichtigeres Zertifikat zu vergeben als nur das Einzelkurszertifikat.. Es heißt „Nanodegree“ bei Udacity und „Professional Certificate“ bei Coursera. (Werbung) https://www.coursera.org/professional-certificates/azure-data-scientisthttps://www.udacity.com/course/machine-learning-engineer-for-microsoft-azure-nanodegree–nd00333 In diesem speziellen Fall kommt eine dritte Zertifizierung zum Tragen: Microsoft Certified: Azure Data Scientist Associate. Die erforderliche Prüfung hat die Nummer DP-100. https://docs.microsoft.com/en-us/learn/certifications/azure-data-scientist/ Tatsächlich ist das Coursera-Zertifikat sehr darauf ausgerichtet, sich auf die Microsoft-Prüfung vorzubereiten. Das Udacity-Zertifikat folgt nicht so streng der Liste der erforderlichen Fähigkeiten von Microsoft, aber dennoch schreibt Udacity: “This Nanodegree program will also help prepare students for Microsoft’s Exam DP-100: Designing and Implementing a Data Science Solution on Azure.”
At the end of the previous year (2020), the new licensing option “Power BI Premium per User was introduced. It started with the possibility to ask for “priority access” for tenants. This phase is over and now every tenant should have the possibility to use the license options. There are new tenant settings “Premium per user (preview)” and it seems to be a common mistake (according to questions in the Power BI Community) to expect these settings to be the place to “switch on” Premium per user. (I also made this mistake). Here are four steps that can be used to get Power BI Premium per user up and running:
There is a big hype about a new feature Microsoft provided under the name “DirectQuery for Power BI datasets and Analysis Services”: James Serra: Huge Improvement Paul Turley: It is truly the Utopian dream; the Holy Grail! Marco Russo / Alberto Ferrari: A milestone I agree with most of what they are writing, also regarding the importance of these changes. BUT, there is one thing I don’t like: Analysis Services on premises, especially Analysis Services Multidimensional is left out!