As a native German speaker I switch between English and German language a lot. Generally for server components like SQL Server and development environments like Visual Studio I find it much easier to use English versions. For frontends like Excel and PowerBI I also prefer English, however the colleagues who work with my applications usually use German versions. So I use both. For Excel this means constantly mixing up colon and semicolon in formulas. Plus I always forget that the German formulas even use Umlaute like “GLÄTTEN”. For Data Analysis functions I created a little sheet with screenshots of the functions I use. Maybe it can be useful for someone else who also uses German and English version. Here it is: screenshots plus a table for easier copy/paste (if necessary).
Since many years I’m using VMWare virtualization software for setting up testing environments. In earlier times, the main benefit for me was to have presentation environments that were able to be resetted to a defined state (snapshot) when I went to customers for a presentation. I tried Hyper-V from Microsoft, which also worked ok, but came back to VMWare (Fusion) when I used a Macbook instead of a Windows notebook.
Attention: this blog post describes the situation from 2018 and is outdated in the meantime. Look at the following post to learn about the transition from the old certification schema to the new role-based certifications: https://www.mmertens.eu/2022/07/azure-role-based-certifications-for-data/ Microsoft puts a lot of efforts into technologies that are related to data, no matter whether you’d call it “Data Analytics”, “Data Science” or use the classic term “Business Intelligence (BI)”. For a company of this size it is no surprise that they have several offerings regarding education. When it comes to certifications, there are also two main “lines” in the meantime: the classic Microsoft Certification Program (MCP) with Microsoft Certified Solution Expert (MCSE) / Microsoft Certified Solution Associate (MCSA), and the rather new Microsoft Professional Program. I’m looking at “Data” only, so I narrow this post down to the relevant data certifications. These are: Microsoft Certified Solutions Expert for Data Management and Analytics Microsoft Professional Program for Data Science