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 Opens New Engineering Center in Russia

Auriga Opens New Engineering Center in Russia

Auriga, an expert software R&D and IT outsourcing services provider, continues to strengthen its presence in Russia. In spring 2018, the company opened a new

Auriga Among Top Companies for Innovation and Customer Experience

Auriga, an expert software R&D and IT outsourcing services provider, has once again earned its place among the most innovative, responsible, and dedicated outsourcing companies...

Auriga Launches New Website

Auriga is pleased to announce the release of our freshly redesigned corporate website! A completely new design, a clear presentation of the company’s expertise, an...