ADN is entrusted with the vital responsibility of managing the water supply system for a significant portion of mainland Portugal, serving 3.7 million inhabitants in an expansive area spanning 19,687 square kilometers.
O Desafio
ADN’s Purchasing department encountered significant challenges when it came to analyzing procurement information. The use of Excel for data analysis was slow, cumbersome, and insufficient to effectively handle the wealth of information retrieved from SAP. Additionally, the existing setup limited their ability to analyze reports, relying solely on Pivot Tables and Excel formulas.
A Solução
To overcome these challenges, DNA adopted ALLOS to streamline their procurement information system. The introduction of ALLOS brought about a transformation in the way DNA’s Purchasing department managed data and reports:
Key Elements of the ALLOS Solution:
- Seamless Data Retrieval: ALLOS was integrated with SAP to efficiently extract data, eliminating the need for complex extractions.
- Efficient Data Analysis: ALLOS provided a platform for the utilization of ALLOS formulas in existing reports, negating the need for intricate Excel formulas and Pivot Tables.
- Customized Reporting: ALLOS collaborated with the Purchasing department to create data structures and reports tailored to their unique business requirements.
Os Resultados
To overcome these challenges, DNA adopted ALLOS to streamline their procurement information system. The introduction of ALLOS brought about a transformation in the way DNA’s Purchasing department managed data and reports:
Key Elements of the ALLOS Solution:
- Seamless Data Retrieval: ALLOS was integrated with SAP to efficiently extract data, eliminating the need for complex extractions.
- Efficient Data Analysis: ALLOS provided a platform for the utilization of ALLOS formulas in existing reports, negating the need for intricate Excel formulas and Pivot Tables.
- Customized Reporting: ALLOS collaborated with the Purchasing department to create data structures and reports tailored to their unique business requirements.
The implementation of ALLOS brought about substantial improvements for DNA’s Purchasing department:
- Enhanced Data Accessibility: Procurement professionals now have all the necessary information readily available within Excel, accessed through ALLOS formulas.
- Streamlined Data Analysis: With data directly sourced from the database, Excel no longer became sluggish, and users gained the capability to independently generate reports, create graphs, perform visualizations, format data, and conduct in-depth analysis.
Conclusion DNA’s embrace of ALLOS led to a comprehensive transformation of their procurement information system. By eliminating the limitations of Excel and integrating ALLOS, DNA’s Purchasing department achieved improved data accessibility and enhanced data analysis capabilities. The result is a more agile, efficient, and self-reliant approach to managing procurement information.
