PowerBI on AWS
Customer is looking to migrate PowerBI solution from on-prem to AWS in order to benefit from AWS elasticity, performance, high availability and security features
Client:
Imperial Auto
Category:
Marketing/Finance
Imperial Auto
Imperial Auto Industries Limited is India’s largest integrated manufacturer and assembler of Fluid Transmission Products covering the entire spectrum including flexible high-pressure assemblies, metal tubular assemblies, and low-pressure hose assemblies.
The organization was established as a small-scale enterprise in 1969 in Faridabad, India. Today it has a global setup with over 20 facilities across India and another 3 outside India. The organization continues to grow and expand its operations continuously.
01. Problem Statement
Customer’s was using custom tool for report generation from the oracle database hosted at on premise. They wanted to move the reporting and dashboard solution to Power BI and host over cloud in order to offload infrastructure maintenance activities, keep centralized cloud storage solution and enable resource scaling as in when required.
02. Proposed Solution & Architecture
- Setup NAT Gateway is to provide internet access to instances under private subnets.
- Setup EC2 instances for Open VPN.
- Setup AWS DMS for data migration from on-prem to S3 storage.
- Setup S3 for data storage.
- Setup AWS EMR with worker nodes along with cluster node to run the report and dashboard update job
- Setup EC2 instance for MySQL database for storing historical outputs.
- Installed Microsoft Power BI gateway on EC2 server which will be required to facilitate view reports in Microsoft Power BI service.
our industries
Service Used In Imperial Auto
We help you see the world differently, discover opportunities you may never have imagined and achieve results that bridge what is with what can be.
S3 Standard
Amazon CloudWatch
AWS Config
Amazon EC2
NAT Gateway
Amazon EMR
AWS DMS
Site-2-Site VPN
Amazon DMS
03. Results
- Data was transferred successfully from on-prem Oracle database to S3 on daily basis
- PowerBI dashboard was hosted on AWS EC2 servers
- Automated execution of EMR cluster for jobs related to PowerBI reports and dashboard
04. TCO Analysis Performed
Prepared 3-year and 5-year TCO (given below) considering the organic future scale of growth –
- 3 Year TCO – $27K
- 5 Year TCO – $45K
