Coca-Cola FrostLink Analytics
Nimblu-Keytronics
Our Mission
Harness the power of Internet of Things (IoT) technology to collect and monitor data from refrigeration units across OXXO stores, focusing on key parameters such as humidity and temperature. By leveraging IoT, our goal was to optimize refrigeration processes, enhance energy efficiency, and support data-driven decision-making within the FEMSA group.
Development
The project was structured around the creation of a comprehensive IoT infrastructure and a user-friendly dashboard for data visualization:
1. IoT Hub Integration: Utilizing Microsoft Azure's IoT Hub, we established a robust platform for data collection. This enabled the seamless aggregation of sensor data from refrigeration units, providing real-time insights into their operational status.
2. Software Development: Development efforts were focused on creating APIs that facilitated the retrieval of sensor data. These APIs allowed for the transmission of data from the refrigerators to the IoT Hub, ensuring a constant flow of information.
3. Database and Storage Solutions: Azure served as the centralized database system, storing detailed information from each refrigerator across every OXXO branch. This approach allowed for efficient data management and accessibility.
4. Dashboard Creation with Power BI: Leveraging Power BI, a Microsoft tool renowned for its user-friendly data visualization capabilities, we designed and implemented dashboards. These dashboards were tailored to display the collected data, offering intuitive access to vital operational metrics.
Results
The implementation of our system led to remarkable outcomes:
1. Achieved connectivity for 800 stores across the country, with each store contributing data from approximately six sensors every minute.
2. The project was instrumental in collecting more than 4,730,400 data points, creating a rich database for analysis and decision-making.
3. Developed a user-friendly dashboard in Power BI that simplified the understanding of complex data sets. This tool has been crucial in unraveling insights from the amassed data, facilitating informed and significant decisions regarding store operations, energy conservation, and refrigeration management.
4. Enabled FEMSA group to make strategic decisions that optimized distribution and scheduling, directly informed by the insights gleaned from real-time data.
5. Resulted in a substantial 30% savings in energy consumption across the stores involved, highlighting the project's significant impact on sustainability and operational efficiency.
This project approach not only showcases the transformative power of IoT and data visualization technologies in retail operations but also establishes a new standard for energy management and operational decision-making within the FEMSA OXXO chain.
Hablemos
Contactanos
hablemos 👋
Ponte en contacto
Let's talk
Contact Us
Let's talk
Contact Us
Let's talk
Let's talk 👋
Contact Us
Contact Us
Let's talk
Contact Us
Let's talk
Contact Us