Case Study: US-based Energy Efficiency Solutions Provider achieves enterprise-wide BI and data integration with Auriga

US-based Energy Efficiency Solutions Provider - Customer Case Study

US-based Energy Efficiency Solutions Provider partnered with Auriga to build the data model and Amazon-based storage foundation for its enterprise-wide BI system. The customer needed a scalable way to unify data from service-oriented systems such as CRM, sales, billing, field audit, and document management into a single analytics environment.

Auriga implemented a DataVault EDW and star datamarts on AWS, using Amazon RedShift, EC2, CloudWatch, Clover ETL, TIBCO Jaspersoft BI, and Python. The solution included data quality and integrity testing, reporting and analysis patterns, machine learning for data mining, and CI scripts, resulting in a full-stack BI platform and improved ETL QA and data consistency.