All cases
Customer serviceFood service
Analytics Power Platform

Automated food waste reporting for large-scale kitchens

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, frequencyFood waste calculated from prepared, consumed and discardedAnalysis and benchmarking in Power BISlide deck generated and exported automatically
Result
20+
indicators, previously tracked in Excel
after 6 months
4
configuration levels per location
at the source
1Click
slide decks straight from Power BI
for all sites
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