Modern Power BI reporting reduces operational costs
About the client
The client is a leading passenger transportation company available to 95% of the United States population. They promote transportation equity through shared rides, bike share systems, electric scooters, and public transit partnerships.
Client requirement
- The client acquired a company whose data was stored in a MySQL on-premise database that required complex stored procedures and functions for reporting.
- The parent company used the Snowflake database and Excel reports. Lack of a centralized data store created report generation complexities and increased operational costs.
- To rectify this issue, the client sought to integrate their new datasets into their parent company’s database and simplify the reporting process.
Solution
- PreludeSys developed a semi-automated Python approach to migrate the client’s data from MySQL to Snowflake.
- We mapped data between the two databases by designing a schema similar to their existing Snowflake design. We then created Snowpipes to extract the data from MySQL and move it to Snowflake.
- We developed data models based on their Excel reports and imported them into Power BI, which allowed them to modernize their reporting process and access insights instantly.
Benefits
- Semi-automated SQL conversion achieved quick transformation.
- A centralized data store enables building ad hoc visuals.
- Power BI generates insightful reports and dashboards.
- Power BI reduced reporting operations costs.
Technology
MySQL, Snowflake, Power BI, Microsoft Azure