Modern Power BI reporting reduces operational costs

About 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
  1. Semi-automated SQL conversion achieved quick transformation.
  2. A centralized data store enables building ad hoc visuals.
  3. Power BI generates insightful reports and dashboards.
  4. Power BI reduced reporting operations costs.
Technology

MySQL, Snowflake, Power BI, Microsoft Azure