Case studies
Problem, approach and outcome.
- A dynamic bridge chart in Power BIA dynamic bridge (waterfall) chart in Power BI that explains the change between two periods by segment, built with DAX and no manual setup per visual.Beverages · Power BI · DAX · Waterfall chartsRead case
- Daily sales report with a business calendarI rebuilt a daily sales report so each day can be compared with the same day last year, using a calendar with the business's own logic.Beverages · Power BI · DAX · Power QueryRead case
- Data quality in a sales reportI improved the data quality of a channel sales report so that territorial decisions rest on correct figures.Beverages · Power BI · Data quality · ValidationRead case
- P&L for a large financial institution, from data to reportI built the profit and loss statement (P&L) of a large financial institution end to end: data centralisation, transformation with SAP Data Services, modelling in SAP IDT, Web Intelligence reports and manual adjustments after the close.Banking · SAP BusinessObjects · SAP Data Services · SAP IDTRead case
- Signal analysis for a new alarm panelI used T-SQL to turn the signals of a new alarm panel into business data and mapped its state changes together with the business and the panel engineers.Security · T-SQL · SQL · Stored proceduresRead case