From complex data to valuable insights for LegionellaDossier

LegionellaDossier is a B2B SaaS company with over 30 employees that specializes in water safety and compliance software. They mainly drive sales through a network of partners, making their sales process pretty complex and difficult to get clear commercial insights using data.

The challenge

When we began working with LegionellaDossier, their data infrastructure was complex, hard to maintain, and built on open-source software. The engineer who created and managed it had left the company. With random, unused tables all over the place and teams working in silos, they had no clear insights into their sales, marketing, or customer success.

Our approach

  • Moved their data to BigQuery, which is easier for their organization to maintain and have easy access to.
  • Introduced Stitch to load data into the warehouse, reducing the need for specialized skills and speeding up data pipeline development.
  • Turned their complex production data from CloudSQL into an analytics-friendly format.
  • Redesigned their data model into a star schema, making data generation more efficient and cutting down on storage and compute resources.
  • Rewrote their scripts into modular SQL scripts using Dataform, which reduced the codebase and made code management easy to handle.
  • Rebuilt the dashboards in Looker Studio with advanced drill-down features, making it easy for users to find insights and track data origins from specific customer activities.
  • Created specific datasets for different business divisions, like finance, so they could integrate the data into their own models, saving them time on data gathering.

The results

Our work led to these benefits:

Set up a scalable, easy-to-access data model, setting the stage for future data projects.
Created a cost-efficient data warehouse, streamlining data management and cutting expenses.
The new dashboards provide deep insights into various business areas and revenue sources, making decision-making easier.

Conclusion

We didn’t just solve LegionellaDossier’s immediate problems—we set them up for future growth. By simplifying and streamlining their data processes, LegionellaDossier can now leverage their data effectively and make more informed decisions.. If your company is facing similar data challenges, we can help turn your data into a powerful asset for business intelligence. Let’s work together to transform your data management and drive your business forward.