September 25, 2024

Disruptive data-driven transformation: Matillion revolutionizes Toelevering Online

Schedule a demo

75%+

employees actively leverage data in their day-to-day activities.

70–80%

of data informed key business decisions

66%

reduction in manual effort per order

Challenge

Toelevering Online initially had no data warehouse or centralized data management system. The company relied heavily on manual processes involving Excel pivot tables and data from WooCommerce. The system was highly inefficient, with a single employee responsible for extracting and managing all data, which created problems whenever he was unavailable.

Solution

The company began its digital transformation journey by implementing Matillion, Snowflake, and Tableau to build a comprehensive data platform from scratch. This new setup allowed them to automate data extraction, load their data and transform it afterwards (ELT), integrate various data sources into a single source of truth, and leverage data by developing dashboards to visualize and analyze data in real time and build advanced analytical integrations.

Results

The transition to a modern data platform drastically improved decision-making, with 70–80% of key business decisions now informed by data. Toelevering Online also achieved significant scalability, and enhanced operational efficiency. Matillion DPC has enabled the company to obtain cost savings, focus on advanced data-driven initiatives, such as predictive modeling and AI integration, further transforming its business operations.

During our first year we had an entire data warehouse solution running for roughly €100 a month.

Yalmar Mekelenkamp
Chief Data Officer
Toelevering Online

Challenge: Manual data processes and fragmented insights limited the company’s growth

Toelevering Online is an e-commerce company that sells custom-made window frames in aluminum, wood, and plastic, with industry-disruptive delivery times.

Before implementing Matillion, Toelevering Online faced some serious data management headaches. The whole data process was manual, with one single employee responsible for extracting data from WooCommerce and manually copying it into large Excel pivot tables. This process wasn’t just time-consuming but also highly unreliable. If that employee was out, no one else could step in, leaving the organization without accurate data to work with.

The other issue was that the company’s data was fragmented and siloed. Different managers had to pull their own numbers from various systems, which often led to inconsistencies and delays. This made it hard to get a clear view of important metrics across systems like customer behavior, conversion rates, and sales performance. Without reliable data, the leadership team had to depend on gut feelings rather than data-driven insights to make critical business decisions.

On top of that, Toelevering Online had big goals, their big highly ambitious goal is to sell a window frame in just three clicks and have it delivered the next day across Europe, but its existing system just couldn’t keep up. Without a scalable solution in place, Toelevering Online struggled to align its data needs with its business goals, especially as it sought to move from a simple data warehouse to a more advanced data platform that could offer real-time insights and support its long-term vision.

We had one colleague who spent a lot of time leveraging Power BI to connect to our commerce platform, extract data, and paste it into a big pivot table... if he was on holiday, no one else could do it.

Yalmar Mekelenkamp
Chief Data Officer
Toelevering Online

Solution: Automate data processes to unlock real-time insights and scalable growth

Toelevering Online knew it had to solve its data challenges, and its first big decision was selecting a suitable ELT tool (choosing between Alteryx and Matillion). Both had their strengths, and the company’s consultants had experience with both. In the end, it came down to scalability and cost. Matillion stood out for being more affordable and better suited to grow with the company, making it the clear choice.

Pairing Matillion ETL with Snowflake as the organization’s cloud data warehouse, Toelevering Online found the perfect combination to build a system that could support its long-term vision. The company built a new data platform from scratch, allowing it to centralize its data.

With Matillion, Toelevering Online automated its ELT processes and eliminated the old manual methods that were slow and prone to errors. Instead of relying on one person to pull data from WooCommerce into Excel, the company now had a system that automatically refreshed data daily. This gave everyone access to up-to-date and accurate information whenever they needed it.

Toelevering Online also gained the flexibility to start small and scale as it grew. The organization began with sales data but quickly expanded to include (online) marketing, customer service, and fulfillment data. This holistic approach broke down the silos between departments and gave everyone a full view of the business—from customer interactions to supply chain performance. With all this information in one place, Toelevering Online’s team could make smarter, data-driven decisions that helped the company stay on target with its ambitious growth goals.

The team could also set up new data jobs and dashboards easily so everyone could access the insights they needed, whether tracking sales, measuring marketing campaigns, or improving operations. With data now driving its strategy, Toelevering Online shifted from relying on gut feeling to making decisions backed by actionable insights.

We selected Snowflake because that was the easiest one to kick off, and performance-wise, it was better than other options... We chose Matillion because of the unlimited scalability and low cost in the beginning.

Yalmar Mekelenkamp
Chief Data Officer
Toelevering Online

Benefits: Automated data processes, better decision-making, and predictive insights

After implementing Matillion, Toelevering Online quickly started seeing significant improvements across the board. Automating data processes meant the company no longer had to rely on slow, manual methods. Instead of waiting on one person to pull data, the system now refreshed daily, giving them up-to-date insights on sales, customer behavior, and overall operations.

Previously, the order router had to manually enter each order and allocate them one by one in WooCommerce, which required 3 clicks per order. With the new data platform, allocation now takes just 1 click, reducing manual effort by 66%, saving valuable time and increasing efficiency across the board.

With everyone finally working from the same data, different teams could collaborate better, making it easier to get a clear view of the business. Decisions that were once based on gut feelings were now backed by real-time data, allowing Toelevering Online to spot trends faster, optimize marketing, and boost efficiency—all while keeping pace with its rapid growth.

But the real game-changer came when Toelevering Online migrated to Matillion DPC. This gave the company even more flexibility and room to grow. With Matillion DPC, Toelevering Online could easily set up more complex data jobs. Moving to a full SaaS environment meant the organization no longer had to manage virtual machines, which cut costs and freed up time for the team to focus on more important data projects. This also allowed the company to scale its data operations as it grew without worrying about hitting limits.

Toelevering Online was truly excited about the new possibilities Matillion DPC opened up. Teams could now dive into predictive analytics and real-time customer insights using AI-driven models to predict customer churn and forecast sales. Additionally, this enabled the company to transform from a data warehouse into a fully-fledged data platform, building analytical integrations with other tools by leveraging Snowflake and Matillion. This shift transformed Toelevering Online from a company that simply managed data to one that actively used data to drive innovation and business growth.

The migration's benefits were clear—better decision-making, more accurate forecasting, and a newfound ability to truly leverage data as a strategic asset.

People were convinced... They saw what better decisions they could make just by using data and not having to rely on that one colleague

Yalmar Mekelenkamp
Chief Data Officer
Toelevering Online

What's next?

With Matillion DPC fully implemented, Toelevering Online has set its sights on even bigger goals. One of its key ambitions is to be a fully data-driven business by 2027, so it can set even bigger steps to 2032, when customers can order custom window frames in just three clicks and have them delivered the next day. Achieving this requires more than just managing data—the company must transform how it uses it.

Toelevering Online plans to continue scaling its data operations with a focus on using predictive analytics and AI to drive smarter business decisions. The company wants to take its customer experience to the next level by predicting when someone will most likely complete an order and optimizing its fulfillment process so manufacturers can anticipate demand and reduce delays.

Toelevering Online also plans to explore more advanced AI applications, such as integrating customer sentiment analysis to improve its churn prediction model. By understanding how its customer base feels about its products and services, Toelevering Online can address issues before they become bigger problems and keep more clients happy.

Another exciting plan is to start monetizing its data. Toelevering Online wants to offer real-time dashboards and data integrations to key customers and manufacturers, providing them with access to insights that help them make better decisions.

Looking ahead, Toelevering Online’s goal is to lead the way in data-driven e-commerce. By continuing to improve its end-to-end data platform and diving deeper into AI-powered solutions, the company is well on its way to hitting its 2032 target. The organization’s focus remains on doing one percent better every day, staying ahead of the competition, and delivering a seamless data-backed customer experience.

About Toelevering Online

Toelevering Online is a Dutch company that offers custom-made window frames through an efficient e-commerce platform. It caters primarily to contractors and construction companies, with about 90% of its customers coming from the B2B market. Originally focused on wooden window frames, it has since expanded to offer options in wood, PVC and aluminum, allowing it to meet a broader range of customer needs.

Toelevering Online’s big goal is to transform the construction industry by making the ordering process faster, simpler, and more efficient. Through continuous investment in technology and customer relationships, Toelevering Online aims to grow sustainably while remaining at the forefront of innovation in the construction sector.

About Matillion

Matillion is a leading provider of data transformation solutions for cloud data warehouses with AI capabilities. The platform helps companies extract, transform, and load data efficiently, which results in valuable insights that enable them to make data-driven decisions.

With its wide range of pre-built connectors and robust integration capabilities, Matillion empowers businesses to unlock the full potential of their data and drive efficiency, innovation, and growth. The company's commitment to simplifying data integration has made it a trusted partner for companies looking to optimize data integration processes.

Our latest resources

View all resources

Ready to get moving?

See how quickly your team can start delivering business-ready data, with Matillion.

Join Matillion

We need driven, curious people who think big and move fast to join our team.