Challenges:
Improve data reporting capabilities for better analysis
Simplr needed to improve their data reporting pipeline to drive faster and more accurate analysis to aid in decision-making for various parts of the business. The older software and data processes they used meant they needed help to improve data reporting speed, analysis, and modeling practices.
As a relatively young company, Simplr had recently built their data stack from scratch and wanted to create a firm foundation for data processes for the future, allowing them to grow within the capabilities of the new data solutions, instead of hurrying to implement new ones once they were at capacity.
Solution:
Updating and upgrading legacy data system and data modeling process
Spaulding Ridge was brought in to implement data modeling best practices, enable Fivetran and DBT in place of a scheduled queries and self-made replication processes, and enhance and review a previous Looker project and provide Looker user training.
One of the first steps in the project was to migrate from a self-made replication process to Fivetran, improving data quality and pipeline performance. Spaulding Ridge helped Simplr overcome some initial confusions and configuration details. Everything was configured and working as plan within the set timeline.
In addition to the migration to Fivetran, the Spaulding Ridge team helped to migrate the data modeling process from the schedule queries process to a DBT model.
Finally, Spaulding Ridge reviewed the Looker project and highlighted best practices for the Simplr team. We provided business-user trainings to improve end users’ adoption of the tool and their ability to explore data in Looker.