Home > Cases > Automating Procurement with Data Analysis
Automating Procurement with Data Analysis
YEAR
2022
CATEGORY
Data & Marketing
Procurement Challenges
Our client’s procurement department faced significant challenges in updating their control panel due to the laborious process of consolidating cost and procurement data spread across units in nine countries. This diversity in data storage forms and the need for manual consolidation greatly reduced the team’s analytical efficiency, complicating predictions for material procurement and proactive negotiations with suppliers.
Mapping over 100 different data sources, spread across various systems, including manually updated Excel spreadsheets.
Data quality from sources.
Potential for human error in manually fed spreadsheets.
Integrations between systems and the Data Lake.
Dojo's Solution
Dojo implemented a digital transformation project using the CRISP-DM methodology and Google Data Lake infrastructure to fully automate data consolidation.
The process involved:
Mapping all data sources;
Data ingestion with quality assurance;
Data processing, creating an engineering pipeline using best practices to avoid unnecessary costs, ensuring optimal business performance;
Monitoring and synchronizing the data pipeline based on business requirements;
Ensuring data quality needed for user analysis;
Creating the necessary visualization layer for specific area analyses.
Transformative Impact
01
Millions in gains
As a result, the company achieved significant gains, enhancing agility, predictive accuracy, and decision-making precision.
02
Daily updates
The implementation led to daily updates of control panels, replacing the previous monthly process, allowing the team to focus on deeper, strategic analyses.
03
Agility and efficiency
The automation not only improved decision accuracy but also significantly enhanced agility and efficiency, reflecting substantial financial benefits for the company.
Ready to take your data management to the next level?
