BI for Energy Efficiency Solution

CASE STUDY

BI for Energy Efficiency Solution

AWS   ·    big data   ·    data analytics   ·    data mining   ·    machine learning   ·    Python

Scope

US-based energy efficiency solutions provider tasked Auriga to develop the data model and Amazon-based storage for the enterprise-wide BI system data.

Projects Highlights

DataVault data model and data warehouse structure.

RedShift columnstore distributed map-reduce DB.

Regression, data completeness, data integrity and data quality test design.

Data marts for reporting.

Reporting and data-analysis patterns development.

Machine learning algorithms implemented for data mining.

Continuous integration procedures and scripts.

Achieved Benefits

Development of a full stack on top of Amazon Web Services in close cooperation with customer’s ETL team.

Data integration from large-scaled service-oriented enterprise system (CRM, sales, billing, field audit, document management systems, etc.).

Enhanceв in-house QA processes for ETL procedures and data consistency.

Technologies

DataVault EDW  ·  Star datamarts

AWS RedShift DB  ·  Amazon EC2

CloudWatch  ·  Clover ETL

TIBCO Jaspersoft BI  ·  Python

Most Relevant Cases

News

Auriga Recognized Again in Global Outsourcing 100® Ranking

Auriga Recognized Again in Global Outsourcing 100® Ranking

Auriga, a US-based expert software R&D and IT outsourcing services provider, has made the 2018 Global Outsourcing 100® list of the International Association of Outsourcing

Auriga Unveils Embedded Software Testing Trends

Embedded software is everywhere – from ordinary home appliances like dishwashers and microwave ovens to sophisticated medical devices, automotive engines, and flight control guidance systems....

CES 2018: The Epicenter of Automotive Innovation

The new year has started with an exciting technological event – CES 2018, one of the largest global trade fairs, taking place. During January 9-12,...