Company is a residential solar electricity provider. With operations in 23 states it is one of the largest solar, storage and energy services company in US.
Customer Need / Business Driver
To migrate the existing analytics platform on Oracle to Google Cloud.
KPI has long term relationship with Sunrun and was already engaged in the existing BI platform of Sunrun. Owing to good exposure to business processes of Sunrun and ability to scale up on new technologies made KPI the preferred partner for GCP migration.
What KPI Delivered
Informatica cloud was leveraged to extract data from Salesforce and Oracle EBS, which are the primary sources along with some other applications for the analytical needs of Sunrun business.
All the extracts are stored in Cloud Storage and BQ and then are consumed either directly for reporting or for further processing by Python scripts in case of complex transformations.
Using Python scripting & effective use of Big Query capabilities, KPI built a robust ETL process that has capabilities to automatically determine dependencies based on the source and target defined for ETL processes and carry out the ETL execution based on that. The system also boasts of a well-defined error handling and troubleshooting mechanism that logs detailed error and generate meaningful alerts on event of failures encountered during the ETL run.
The ETL process is a mix of classic ETL batch process and micro ETLs that are neatly tied to a well-defined orchestration mechanism written in Python by KPI.
On the reporting end KPI in partnership with client technical & functional team has built a strong and user friendly reporting layer that has good acceptance from Sunrun business users.
Ad-hoc/Real-time analysis has helped business to get better insights from their data.
Moving to Google cloud has helped Surun to bring down the IT costs. With enhanced computing power from GCP and big query the need to build a physical dimensional model is no longer there and this has drastically reduced the development time.
Looker has helped the customer visualize millions of records and find market trends. It has also helped and encouraged teams to further deep dive into the data and find key relationships which help their business grow.