As a trusted partner in this journey, our responsibility was to design and build a sophisticated Data Lake in Azure, Microsoft’s cloud platform. This foundational data architecture enabled seamless data integration, ensuring that the client’s data was not only centralized but also readily accessible for value-adding analytics.
The comprehensive reporting framework, developed through Power BI, empowered the client to transform into a data-driven organisation where strategic decisions are guided by precise and timely insights.
Business Outcomes
The client’s commitment to digital innovation, supported by our expertise in data solutions, has paved the way for enhanced operational efficiency and informed decision-making.
Specific Challenge
The client runs 40 bottling plants around Africa, and machine maintenance is a difficult activity to plan effectively for. Historically, the average unplanned downtime per plant was around 3 hours per week, and at an average productivity loss of R40,000 per hour per plant, that total machine downtime impact could reach over R100 million per year.
Before the digital transformation project started, productivity planning was structured around Qlikview and Tableau reports. Unfortunately, the 120 production planners across the group still needed to spend signicant time on manual planning, even with the Qlik and Tableau reports. In addition, due to data credibility issues and late data updates, the planners often had to resort to manual reports extracted through SAP.