July 2021

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 »