Case

From Excel to BigQuery: Tollvignettes Scales Up with a Future-Proof Data Solution

Tollvignettes.com is een online platform dat digitale tolvignetten aanbiedt voor verschillende Europese landen, zoals Slovenië, Tsjechië, Hongarije en Zwitserland.

Need

Tollvignettes, an e-commerce company specializing in digital vignettes, has been experiencing significant growth. This growth required the next step in data maturity. The company's CFO was spending a lot of valuable time keeping financial models up to date. These models are essential for monitoring and improving business processes, gaining insights into the company's growth and strategy, and managing advertising costs. Data from various sources (webshop orders, advertising data, and payment platform data) had to be manually downloaded and merged in Excel. This was a highly labor-intensive and time-consuming task that was not scalable. Tollvignettes wanted to continue growing, which created a need for an efficient, automated, and reliable data environment that could scale with the company.

Outcome

Datamart helped Tollvignettes set up their complete data flow, allowing the company to scale on all fronts. From easily adding new data sources to analyzing a large number of data points, everything has been designed to be user-friendly and flexible. For this project, Google Cloud Platform was used, with BigQuery as the data warehouse and Looker Studio for data visualization. Looker Studio is an accessible and free visualization tool that enables the finance team to independently create and share reports. Datamart implemented an ETL pipeline for Tollvignettes, ensuring that data from various sources is automatically retrieved and transformed. With this automation, Tollvignettes can easily access their financial data and quickly perform analyses without manual effort. Thanks to Datamart, Tollvignettes now has a centralized data storage (data warehouse) and can perform valuable analyses through reporting (data visualization). Datamart has elevated Tollvignettes to a new level of data maturity, enabling data to directly contribute to the company's growth.

Tools

<Programmeertaalen/>

Curious about how we can get your data in motion?

Lorem ipsum by sit amet, consecteur adipising elite. Mass adipiscing in an orci semper. Urna, urna, elit ac cat. Ipsum suspension integer proin nunc netus is present urn nunc

Lorem ipsum by sit amet, consecteur adipising elite. Mass adipiscing in an orci semper. Urna, urna, elit ac cat. Ipsum suspension integer proin nunc netus is present urn nunc

Curious about how our tools can boost your business?

Lorem ipsum by sit amet, consecteur adipising elite. Mass adipiscing in an orci semper. Urna, urna, elit ac cat. Ipsum suspension integer proin nunc netus is present urn nunc

Lorem ipsum by sit amet, consecteur adipising elite. Mass adipiscing in an orci semper. Urna, urna, elit ac cat. Ipsum suspension integer proin nunc netus is present urn nunc

Let data speak for your organization.

With a focus on data storytelling, we are happy to take a closer look at your data business case

Continue reading

Other impactful projects

More insight into sales potential for Laborie

Read more ↗

Creating more insight for Verhuurbeter.nl into the possibilities of dashboards and implementation

Read more ↗

Developing up to date dashboards voor Battolyser Systems

Read more ↗