Client Context
An energy provider managing a high volume of new customer accounts faced inefficiencies in onboarding customers and entering billing information into its Flux billing system. The workflow involved multiple steps, including data imports from the Spark data warehouse, manual transformation of data fields, and API calls to populate customer details. Errors and delays in this manual process impacted operational efficiency and the customer onboarding experience.
The client required an automated solution to improve speed and accuracy and integrate seamlessly with its billing system.
The Challenge
The client’s customer onboarding process faced several operational constraints:
- Manual data imports and transformations from the Spark data warehouse were time-consuming
- Multiple API calls were required to input customer details into the Flux billing system
- A high risk of errors due to manual processing
- Delays impacted the overall customer experience and internal operational efficiency
- Inconsistent data formatting reduced reliability and required additional validation
The Solution
Blackbook AI implemented an automated workflow using Power Automate:
- A Power Automate flow imported and transformed customer data from the Spark data warehouse
- The flow integrated with Flux Provisioning APIs to automate the creation of the Client ID and Client Secret for API execution
- Data was refreshed into two Power BI reports for real-time insights and decision-making
- Excel export functionality converted report tables into the correct format for Flux, ensuring consistency
- API execution was automated, accurately entering customer data into the Flux billing system in the correct order
The Outcomes
- End-to-End Automation:
Customer data import, transformation, and provisioning were fully automated, eliminating manual errors - Real-Time Reporting:
Power BI reports updated automatically, enabling timely operational and strategic decisions - Accelerated Onboarding:
Reduced processing time allowed faster customer onboarding, improving the overall experience - Improved Data Consistency:
Automated transformation ensured data was formatted correctly for the billing system, increasing reliability
FAQs
What parts of customer onboarding were automated?
How does this improve visibility for the business?
Why does this work for North American energy retailers?
