Public Transit Client Matures Their Data Pipeline by Migrating Data Warehouse to the Cloud
A global leader in urban mobility technology approached Resultant for services including a Tableau Server assessment, recommendations, a production environment upgrade, and ongoing server maintenance and support.
Spending extended time with our team gave the client deeper insight into the challenges they faced, and they looked to Resultant to provide further guidance supporting their need for data improvements and visual analytics enhancements.
Because our first recommendation was to migrate their data to a cloud-based data warehouse to make their data storage solution lighter, faster, and more agile, our team provided an extensive demo of the cloud-based data warehouse platform Snowflake, which convinced the client to make the move to the cloud.
We also recommended they:
A senior data architect leveraged Matillion, a best-of-breed cloud-native data transformation tool. We built numerous transit detail dashboards in Tableau that connected to the cleansed and consolidated data source built through Matillion in Snowflake. They were published to the recently upgraded Tableau Server for ease of accessibility. This suite of dashboards currently provides the client with further visibility into the details and aspects of their data as a whole.
With the help and guidance of only two members of the Resultant team, the client was able to set up an enterprise data warehouse for internal use smoothly and quickly within a month.
The power of Matillion shone through by enabling the client to create one workflow that generated individual secure share views per customer in order for the client to have visibility and access only to their own data.
Employing Matillion to successfully handle this arduous yet crucial process with minimal effort saves employees significant time, freeing them to focus their efforts on the more human-centric tasks of growing the business.
Tableau enables the client to easily consume their parking and transit data and perform comprehensive visual analytics through the creation and maintenance of customizable dashboards. The stories told by the interactive and informative graphs and charts within these dashboards empower the client to ultimately make better data-driven business decisions.
About the Client
A global leader in urban mobility technology approached Resultant for services including providing a Tableau Server assessment, providing recommendations, upgrading their production environment, and continuing server maintenance and support.