Michael Mertens - Data Science and Analytics
Aug 25
by mme in Mathematics and Statistics 0 comments

vorgerech.net

vorgerech.net war meine alte Webseite, auf der insbesondere ein befreundeter Mathematikprofessor einige Skripte zur Ingenieurmathematik bereitgestellt hat. Die Seite ist nun abgeschaltet, die Skripte sind hier noch eine Weile herunterladbar:
Read More
Aug 25
by mme in Mathematics and Statistics, Software: Excel 0 comments

Optimierung mit dem Excel-Solver

In diesem Beitrag geht es um ein Thema aus dem wirtschaftswissenschaftlichen Fachgebiet des “Operation Research”, OR genannt. OR beschäftigt sich mit mathematischen Methoden, um betriebswirtschaftliche Probleme zu lösen, z.B. das Problem der Bestimmung von optimalen Losgrößen in der Produktion. Unter gewissen Bedingungen existieren Algorithmen zur Bestimmung von optimalen Lösungen; teilweise führen nur numerische Verfahren zum Ziel. Ein bekannter und relativ einfach verständlicher Algorithmus zur Lösung von linearen Optimierungsproblemen ist der Simplex-Algorithmus.
Read More
Aug 15
by mme in Software: Excel 0 comments

German-English Translations for Data Analysis

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).
Read More
Aug 11
by mme in Technical Infrastructure 0 comments

VMWare Test Environment V. 1.0

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.
Read More
Aug 11
by mme in Learning And Getting Certified 0 comments

Microsoft Data Certifications

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
Read More
Recent Posts
Archives
Categories