A successful data project, arranged from A to Z

A Dutch telecom provider sought to examine and enhance their change management process using Lean Six Sigma. The objective was to maximise successful changes in hardware and software, evaluate risks, inform customers, and conduct assessments. The telco aimed to strengthen operational stability, streamline network and IT maintenance, foster innovation, and optimise service delivery.

Our consultants log the assignments they take on for our clients in our ERP system AFAS. In our CRM system HubSpot, we can see all the information relevant before signing a collaboration agreement. When we close a deal, all the information from HubSpot automatically transfers to AFAS. So, HubSpot is mainly used for the process before entering a collaboration, while AFAS is used for the subsequent phase. To tighten our people's planning and improve our financial forecasts, we decided to set up a data warehouse to integrate data from both data sources.

KWF is a Dutch charity dedicated to fighting cancer. The organisation was working on the development of a Memoriam Platform. This is a new initiative to create personalised memorial pages for the deceased. On these pages, donations can be made to KWF.

FrieslandCampina Global facilitates local teams in Europe, Asia, and Africa. They want to gain a better understanding of the market and provide the teams with new insights. The goals are to strengthen their competitive position and to identify new opportunities for expansion.

In October 2022 we launched our new website, in a fresh design style. We asked our partner Kaliber to update our branding and website with a design that fits our brand values. After the website went live, we wanted to know if they succeeded at this. Therefore, our own research consultants designed and conducted a research study to evaluate the effectiveness of the new design in conveying our intended brand values and message.

From 1 July 2024, it will no longer be possible to process data in Universal Analytics 360 (hereinafter: UA360). Wehkamp collected data in UA360 and was keen to be prepared in time for the migration. In addition, they wanted to collect at least 1 year of historical data for UA360's sunset. This allowed Wehkamp to compare the data in UA360 and in GA4. A key desire was to migrate the measurements as-is.

Valk Exclusief is a chain of 4-star+ hotels with 43 hotels in the Netherlands. The hotel chain wants to offer guests a personal experience, both in the hotel and online.

TM Forum, an alliance of over 850 global companies, engaged our company as a data partner to identify and solve data-related challenges.

Stichting Donateursbelangen aims to strengthen trust between donors and charities. They believe that that trust is based on collecting money honestly, openly, transparently and respectfully. At the same time effectively using the raised donation funds to make an impact. To further this goal, Stichting Donateursbelangen wants to share information about charities with donors through their own search engine.

The organisation Doctors of the World offers medical assistance to people in a vulnerable position. They often do not know how to find their way in the Dutch healthcare system. Doctors of the World helps them with this. One of the channels to get informed about the work of Doctors of the World is the website, which will be redesigned.

Dutch citizens living, working or studying abroad must also take care of things like renewing their passports, arranging tax issues and pension with the Dutch government. This can be something of a challenge by being far away from the Netherlands, due to fragmentation of services, time difference and different situations. In a project which lasted from 2018-2022, the Ministry of Foreign Affairs therefore worked together with 12 implementing organisations (e.g. Tax and Customs Administration and RDW) on government-wide access to public services. The service is called Netherlands Worldwide (NWW). NWW is accessible 24/7 on the website, and direct customer contact channels such as telephone, WhatsApp and email.

An interest group for homeowners offers a wide range of content and services on its website that can be closed online. In order to serve its website visitors in the best possible way, interactions with the services, funnels and content pages must be properly measured. They already did this with our support, with Universal Analytics (GA3). To be well prepared for the future, they asked us to implement Google Analytics 4.

Dedimo is a collaboration of five mental healthcare initiatives. In order to continuously enhance the quality of their care, they organize internal processes more efficiently. Therefore, they use perceptions from the data that is internally available. Previously, they acquired the data themselves from different source systems with ad hoc scripts. They requested our help to make this process more robust, efficient and to further professionalise it. They asked us to facilitate the central storage of their data, located in a cloud data warehouse. The goal was to set up the data infrastructure within this environment, since they were already used to working with Google Cloud Platform (GCP).

At Royal HaskoningDHV, the number of requests from customers with Data Engineering issues continue to climb. The new department they have set up for this, is growing. So they asked us to temporarily offer their Data Engineering team more capacity. One of the issues we offered help with involved the Aa en Maas Water Authority.

The Designathon Works foundation organises Design Hackathons (Designathons) for children aged 8 to 12. The target? Teaching children from all over the world skills to become a 'changemaker'. They are challenged to design solutions for a better world, for example to combat climate change. From the Datahub, we helped Designathon Works fine-tune the impact measurements free of charge. We also made a first move towards automating data collection, analysis and visualisation.

FysioHolland is an umbrella organisation for physiotherapists in the Netherlands. A central service team relieves therapists of additional work, so that they can mainly focus on providing the best care. In addition to organic growth, FysioHolland is connecting new practices to the organisation. Each of these has its own systems, work processes and treatment codes. This has made FysioHolland's data management large and complex.

The well-known Dutch band HAEVN was unable to perform due to the corona measures. In order to make the most of their time, they wanted to optimise their new website and webshop. They sell merchandise, CDs and LPs through their Shopify webshop. Fans can also download concert films there. The HAEVN team themselves had little knowledge of data-driven website optimisation and asked us for help.

The Neuron provides a programmatic bidding platform to plan, buy and manage digital Out-Of-Home ads in real-time. They asked us to predict the number of expected impressions for digital advertising on billboards in a scalable and efficient way.

The outbreak of the corona pandemic in early 2020 has turned the world upside down. In addition to countless infections, hospitalisations and deaths, we also saw an outbreak of violence in many countries. Citizens took to the streets, sometimes violently, to protest against the measures taken, but domestic violence also increased in many places and fear and frustration played a role in racism.

Vesteda was curious if social listening – monitoring and analysing social media discussions about a brand, competitors, products or hashtags/keywords – could add value to the organisation. To this end, we started a project that consisted of two parts: exploring possibilities for social listening in the Corporate Communication department and applying social listening in an ongoing Data Science project.

DIGIWEDO specialises in designing and developing responsive websites, web shops and web applications for SMEs (MKB). They regularly receive questions from customers about how to collect, visualise and/or analyse data in the right way. DIGIWEDO does not yet offer any services in the field of data. They asked us to think about how they could expand their existing services when it comes to advice in the field of data-driven working. Within a week, using our data pressure cooker we proposed a clear plan that helps DIGIWEDO to meet customer needs.

In times of the coronavirus (COVID-19), a good overview of the patients in the scaled-up intensive care of the Utrecht medical centre is vital. Employees must be able to view patient characteristics, the most current lab readings and the course of patients' vital signs at a glance. In addition, up-to-date insight into the bed occupancy per department and the capacity of the nursing staff is required. We immediately got started to provide the necessary insights for UMC Utrecht. As a way of also contributing in these times of crisis, we offered our hours free of charge.

Fietsvoordeelshop has seven physical stores and a webshop. It is one of the most successful bike shops at the moment. In the field of data, the bicycle shop mainly worked with Excel. This means that a lot was done manually, every week. Due to the growth of the organisation and the increasing number of processes, the Excel file became increasingly large and unclear. Fietsvoordeelshop asked us to demonstrate with a data pressure cooker of five days that data-driven work could be of added value.

Nuon became Vattenfall in October 2019. The rebranding was a good reason to optimise Analytics. There was a renewed focus on applying insights from user data in the Mijn Vattenfall environment. The data collected for this was not always reliable. In addition, there was insufficient knowledge and capacity within the department to maintain the Analytics. The energy supplier asked for our help to support them in re-establishing the tagging and analytics of Mijn Vattenfall.

Within KPN, one team is responsible for the implementation of Adobe Analytics, the Digital Performance team. Due to the working method that had developed before the formation of this team, the specialists did not work together optimally.

Residential investor Vesteda is working on a new website. If an available rental home has a garden, the location of the garden must be listed on the webpage of that home. This information was not yet available in the database. We were instructed to determine the location of the garden based on the coordinates of the homes.

RetailTrends is a family business with a media platform for retailers. Over the years, the company has developed from a publisher of a single print magazine to a multimedia platform. This consists of two websites with news and background articles about the industry; a print magazine; an online magazine; and events. Interested parties are kept informed via various newsletters and social media channels. Some of the content is only accessible to members.

Fair Wear is a non-profit organisation that aims to improve the working conditions of employees in garment factories. The NGO has collected a lot of documentation about its activities in recent years, for example in the form of reports from a complaint line for factory employees, reports of audits that check whether factories comply with the guidelines, and reports of training for factory employees. This information is stored as typed text, usually in Word or PDF format.

The Van Gogh Museum is the most visited museum in the Netherlands. More than 2.2 million people visited the museum in 2017. Data is collected from all those people. Data from the website and other online marketing channels, but also offline data from ticket sales at the box office, for example.

Residential investor Vesteda is working on a new website. This must offer (potential) tenants and B2B customers, such as investors and pension funds, an optimal online experience. Buyer personas of the various B2C target groups had already been developed. Together with Vesteda, we also started to map out the B2B target groups. In addition, together with the customer, we developed the optimal customer journeys for the most important buyer personas.

Various departments within Univé made decisions based on data from multiple data sources and separate reports. As a result, each department made decisions based on different information. The departments were also not always aware of each other's performance. We investigated how the integration of the data sources using the Microsoft Power BI visualisation tool could improve decision-making.