mme – Michael Mertens

Jul 30

by mme in Software: Power BI & Analysis Services 0 comments

Power BI Search

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.

Jul 17

by mme in Business Modelling 0 comments

AdventureWorksDW20xx / Which version to use?

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.

Jul 12

by mme in Learning And Getting Certified 0 comments

Azure Role Based Certifications for Data

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/

Jul 10

by mme in Learning And Getting Certified 0 comments

Udacity or Coursera for Azure Machine Learning Certificates?

In this blog post I compare the Udacity and the Coursera platform using one example, an Azure Machine Learning degree.Both platforms have the concept of putting courses together in a bigger context and therefore a more important certificate. It is called “Nanodegree” at Udacity, and “Professional Certificate” at Coursera. (Advertisement) https://www.coursera.org/professional-certificates/azure-data-scientisthttps://www.udacity.com/course/machine-learning-engineer-for-microsoft-azure-nanodegree–nd00333 In this special case a third certification comes into place: Microsoft Certified: Azure Data Scientist Associate. The required exam has the number DP-100. https://docs.microsoft.com/en-us/learn/certifications/azure-data-scientist/ Actually the Coursera certificate is very much oriented to prepare for the Microsoft exam. The Udacity certificate is not so strictly following the necessary skill list from Microsoft, but still Udacity writes “This Nanodegree program will also help prepare students for Microsoft’s Exam DP-100: Designing and Implementing a Data Science Solution on Azure.”

Jan 02

by mme in Software: Power BI & Analysis Services 0 comments

Configuration of Power BI Premium Per User

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:

Dec 31

by mme in Software: Power BI & Analysis Services, Software: Tableau 0 comments

Hype about DirectQuery for Power BI datasets and Azure Analysis Services

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!

Jun 19

by mme in Business Modelling, Software: Power BI & Analysis Services 0 comments

Process Mining with Power BI and R Visuals

This little Power BI project is something like my “Hello World” for using R visuals. I picked Process Mining as the topic for the model because of several reasons: Process Mining is quite different to typical number-aggregating-scanarios, so hopefully interesting! The R visuals are adding possibilities to the project, that can’t be replaced by standard visuals easily. It is still easy to model and understand.

Jan 01

by mme in Software: Tableau 0 comments

Fürstenzug Dresden / Tableau Public Report

The following illustration is a test of the “embed” function of Tableau Public. That means that the report was created in Tableau Desktop and uploaded to Tableau Public.

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:

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.