BI REPORTING on AWS

Cost Optimization and Enhanced Reporting performance for India’s Largest Electricity Distributor

BUSINESS CHALLENGE

Data extracted from multiple sources, transformed using Pentaho Data Integrator and loaded to MySQL database. ETL-ed data transported to SAS servers via batch jobs and presented to users as visual reports. Reports were not loading even with as low as 10 concurrent users and SAS reporting engine was not utilized to its full potential – No Univariate/Multivariate analysis. In addition, the overall spend on 25 licenses was also enormous.

BUSINESS GOAL

Enhanced reporting capability with cost efficiency.

SOLUTION OVERVIEW

  • Data from various sources would be extracted and transformed by PDI & MySQL
  • Transformed data would be stored on premise in a MySQL Database
  • Tableau Reports created as similar to those in SAS
  • All reports set to extract mode to locally store necessary data

SOLUTION HIGHLIGHTS

  • The Current ETL setup was retained to ensure the reporting logic was not altered
  • Separate account and VPN connectivity was recommended for proper bandwidth utilization
  • Tableau reports were created and published with extract mode to ensure that all data resides inside the reporting server

VALUE PROPOSITION

PERFORMANCE ENHANCEMENT

  • 50% gain in report loading time

COST OPTIMIZATION

  • Licensing costs reduced by 80% despite obtaining 175 additional licenses

HIGHLY SECURE BUILD

  • On premises to AWS connection was established using VPN Tunnelling
  • Role-based access control for the AWS environment
  • Cloud storage implemented with AWS best practices