All cases
Customer serviceFood service
Analytics Power Platform

Automatic food waste reports that turn into tailored recommendations for each kitchen.

How a food waste solutions provider captures data from the large-scale kitchens it works with in an app and generates the reports straight from Power BI - instead of tracking more than 20 indicators in Excel.

Customer anonymised
Starting point

The client helps operators of large kitchens in hospitals, schools and factory canteens reduce food waste. The previous application was outdated: configurations could not be updated, browser compatibility was missing, reporting did not run automatically. More than 20 indicators were tracked in Excel and the slide decks compiled by hand every six months - under strict data security requirements.

Solution

An application built with Power Apps replaces the old system. Each location can be configured individually - inventory system, disposal type, portion sizes and frequency - so food waste can be calculated precisely from what was prepared, consumed and discarded. Power BI replaces the Excel workflows: slide decks are generated automatically and exported directly. Benchmarking features compare locations across the entire client portfolio.

Result
RobotHumanAI-assisted
Location configured: inventory, disposal type, portions, frequency→Food waste calculated from prepared, consumed and discarded→Analysis and benchmarking in Power BI→Slide deck generated and exported automaticallyConsultants derive tailored recommendations
Result
20+
indicators per location, previously tracked in Excel
4
configuration dimensions per location: inventory system, disposal type, portion sizes, frequency
Automatic
erstellte Berichtsfolien, direkt aus Power BI exportiert
Benchmarking
comparison across the entire client portfolio
not months

Do you have a similar process?

Tell us about your workflow, we’ll tell you honestly what can be automated.

Book an intro call