Michael Muell

The Advantage of making things dynamic There are many ways to build reports in Power BI. Like in coding there are many ways to accomplish the same thing. And as with code, there are ways to make your reports easier to maintain and less prone to errors when implementing changes and, well, ways to do …

Techniques to create Easy to maintain Dashboards in Power BI Read More »

In this article, we will have a look at how ingestion routines that seem simple at first turn out to be complex in big data warehouses. The example is taken from a customer project and is used in the daily load chain to update freight cost into the overall procurement cost structure. Refining Source Data …

Using SQL to create a complex Data Ingestion Routine Read More »

A very useful Add On to Power BI is called “Tabular Editor”. Not only does it allow you to bulk maintain all measures and the data model it also lets you use scripts written in C# to automate manual tasks even further. In this post, I want to share two use cases where scripting has …

Automating Power BI Measures with C# Read More »

The following article builds on top of the business perspective described in my previous article. If you haven’t checked that one out, I’d highly recommend you do that first. We defined what data-driven business process improvement is, how it’s done most efficiently, and who is responsible for it. In the second part of this series, …

Designing a Flexible Data Warehouse to Optimally Support Business Process Improvement Read More »

Transforming SAP EKBE Table​ In the IRB model, we want to determine the invoice quantity and goods received quantity for each purchase order and the last GR posting for the invoice. SAP stores all of this information in table EKBE. However, the document for the goods receipt value is in a different line than the …

Flexible Data Warehouse ETL Code-Highlights Read More »

This solution was developed for a Shared Service Center to allow the middle managers of each department to track their KPI, identify errors that waste time and money, figure out why they happen, simulate possible actions, and track their impact on improving the KPI. It’s a flexible reporting layer connecting data from SAP and external …

Development of the Shared-Service-Center Improvement Framework Read More »

This article is about one of the journeys from taking a product, in this case, the SAP Analytics Cloud, and building a useful tool that creates business value. You can substitute here for any other Self Service BI tool, e.g., Power BI. The main difference between working as an IT professional in a large corporation …

How to Really Improve Your Business Processes with “Dashboards” Read More »