Modernization of the Data Analytics Environment at a Sanitation Company

01The Client

One of Brazil's largest water and sewage sanitation companies, with an on-premises analytics environment based on an MPP database.

02The Challenge

• On-premises analytics environment with an MPP database of high operational complexity
• Slow and difficult-to-maintain data loading processes
• Low data quality undermining the reliability of analyses
• Limitation in creating and delivering new strategic and operational KPIs

03Implemented Solution

• Modernization of the data analytics environment leveraging technologies already used by the company
• Redesign of the data architecture to reduce complexity of the on-premises MPP environment
• Optimization of ETL/ELT pipelines to reduce time and complexity of loading processes
• Implementation of data governance and quality controls with validation rules and traceability
• Development of new KPIs and dashboards for operational and strategic monitoring

04Strategic Differentials

• Leveraging technologies already present in the company, minimizing learning curve and deployment costs
• Incremental modernization approach, without the need for complete replacement of existing infrastructure
• Data governance implemented with cataloging, lineage and quality controls in the pipeline
• Expanded analytical capability delivered without cloud migration, respecting on-premises environment constraints

05Results Achieved

• Reduction of operational complexity in the analytics environment
• Decrease in processing time for data loading processes
• Improvement in the reliability and quality of data used in analyses
• Ability to generate new KPIs to support strategic and operational decision-making