Davide Cattaneo

Personal Website

Multinational Retail Corporation

02

Year

2023

Sector

Food Retail Chains

Work performed

Data Integrations

Scroll to explore

Partner data integration and multinational retail operational dashboard

THE CHALLENGE

A multinational large-scale retailer needed to integrate data from its various partners into a coherent and easily consultable view. The main problems were the fragmentation of sources and the difficulty of users, mainly functional and non-technical, in managing files and complex analyses. The objective was to reduce analysis time, making the data immediately usable without requiring specific technical skills.

THE PROCESS

A SharePoint-based architecture was designed, allowing users to independently upload their partner files without technical intervention. Through Power Automate, an automatic data update flow was implemented on upload. At the same time, a dashboard was developed in Power BI focused on usability, simplifying navigation and data understanding.

THE SOLUTION

A centralized, constantly updated, and accessible dashboard was created, integrating the data of the different partners in a single model. The solution allows multidimensional analyses on products, markets and partners, being usable even by users without technical skills. Mobile access and continuous data availability favor immediate use in any operational context.

The result

Elimination of manual file management. Elimination of errors resulting from manual manipulation. Substantial reduction of time dedicated to data preparation. Focus directed exclusively at analysis and decisions. Qualitative impact: Operational meetings are now focused on interpretation and decision making, reducing the time spent on data verification and correction.