How WWL Unifies Data from 24 Eshops to Expose the “Why” Behind Sales

By Jack Zagorski | 3 min read

If you’re reading this from a location in Western Europe or Asia, you may be sitting under a light bulb from the product range of World Wide Lighting (WWL)—an ecommerce lighting company headquartered in Helmond, the Netherlands. Founded in 1986, the company specializes in B2B sales of everything from high-quality conventional light bulbs, to forward-thinking LED solutions, to complete luminaires. Today, it has 24 eshops in 14 Western European countries and is parent to four subsidiaries, each with its own target market.

 

The Problem: Siloed Data Was Keeping Insights in the Dark

Like so many other ecommerce businesses nowadays, WWL understood that siloed data blocks access to big-picture insights, and in 2020 set out to build a tech stack that would integrate all their sources. The company’s entire business goes through a single ERP system, so the first step was to connect this and their other database sources to a data warehouse. But their constituent departments were using around a dozen API-based tools, whose data also needed to be integrated. Soon after hiring a partner to start building the framework of the warehouse, they began searching for a partner who would help them wrangle data from the cloud. 

WWL’s business motto is “We move fast,” which is why they eventually settled on i-spark—a full-service data agency that provides bespoke solutions to strategical, technical, and analytical problems in weeks, not months.

 

The Solution: Off-The-Shelf and Quick Custom Connectors

For integrating data from WWL’s API-based data sources, i-spark recommended Dataddo for its wide portfolio of off-the-shelf connectors and quick turnaround time for the construction of new connectors. This was important for WWL because, in addition to data from Salesforce, Zendesk, Trustpilot, Copernica, Mopinion, and other cloud services, they needed to pull data from Transsmart—their proprietary software tool that integrates shipping solutions with ERPs. Dataddo built the connector free of charge.

With a little help from Dataddo’s solutions team, WWL configured Dataddo to funnel the data from these cloud services into the staging area of their now-completed data warehouse. From there, it is cleaned, transformed, and combined with data from their ERP solution and other database sources. The data is then fed into Looker, the company’s BI tool, where it is accessed directly by over 50 end users weekly, and shared with even more who receive email reports daily. Whenever an end user needs information, they simply query the data from their warehouse, which fires it back in near real time.

 

The Outcome: A Better Understanding of Why 

Previously, WWL only knew what was happening with their business at any given moment. Now, thanks to their data stack, which includes Dataddo, it’s much easier to determine why. And not just for the company’s data analysts, but for its business-focused end users.

Jimmy WWLWhenever we see something that we want to know more about, it’s easy for all the users to deep dive and take one step deeper in the data…to see a bit more of why things are happening.”

Jimmy van den Eerenbeemt - Insights Manager

 

Just the Tip of the Iceberg

Today, WWL has approximately 18 data sources integrated in a single warehouse. But according to their lead data engineer:

“We are on the tip of the iceberg of possibilities.”

In addition to considering integrating new data sources, the company is looking into building predictive analytics models to help its decision-makers stay one step ahead. With their data now illuminated, the future looks bright.

 

See How Dataddo Can Help Your Business

Just a few quick steps to get your data to your dashboard for better analysis, without the hassle.

Start 14-day free trial


Category: Case Studies

Comments