Automation & BI

Supply and demand report on social organization focused on food rescue

The challenge

The Food Network aims to bring together companies with social organizations by rescuing products for human consumption and distributing them to those who need them most, thus avoiding waste.

As companies grow organically, it is necessary to adjust their management to meet the new needs created by a more demanding scale, where digitalization is key.

The strategy

In addition, there is an important opportunity to strengthen the tool in terms of its automation and integration with the information sources, in order to reduce the time spent on manual tasks and focus the time on the analysis.

The achievements

Delivered 2 Power BI reports with automated ETLs, which reduced the operational burden on the Food Network team:

120 man-hours saved per year

100% automatic update of the report with queries to the database in productive mode