Data Analytics

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 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.

Dienst Testen is a crisis organisation created during the corona pandemic. Under the banner of the Ministry of Health, Welfare and Sport (VWS), Dienst Testen ensures that everyone in the Netherlands can be tested quickly and reliably. Dienst Testen does this in collaboration with the municipal health services (GGDs) and laboratories. To quickly gain insight into the corona test figures in the Netherlands, Dienst Testen asked us and a number of other data consultancy parties to create dashboards in collaboration.

KPN's Team Digital wondered whether more value could be gained from their existing customers. Using the available data, we looked at where – within the existing online customer journeys – there were opportunities for cross-selling and upsell.

For some time now, we have been assisting PostNL's customer service department with the optimisation of their online service & contact environment. Various pilots showed that there was also a lot of potential in improving the offline service.

Mimic is a start-up that wants to help parents achieve the best feeding experience for babies through the Mimic baby bottle. This bottle provides the most natural drinking experience possible. Thanks to the patented cup system, the Mimic bottle ensures a calm drinking pace and reduces the risk of colic.

The Municipality of Utrecht collects a lot of data from contact moments with citizens. This includes anonymous visitor behaviour on the website and online applications, but also phone calls to the Customer Contact Center, messages via webcare and physical appointments at the municipal desk.

Eneco customers can enter into or change an energy contract via the website, but also purchase a charging station or hire an energy coach, for example. Eneco wanted to bring in more expertise regarding the field of digital analytics. We helped Eneco find an extra Web analyst with whom this ambition could be fulfilled.

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.

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.

Venturn's consultants are active in the maritime and logistics sectors. The service provider itself organises soft skills training for their employees. In addition, there was a need for training in the field of data-driven work. Venturn asked us to develop tailor-made data training.

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.

From 'ethical data to doing' is easier said than done. Some of the ethical considerations in the field of working with data are laid down in the Privacy Act (GDPR). Depending on the context, there are many more questions to ask ourselves. If something is legal, this does not automatically mean that it is also ethically responsible.

The Internet of Things (IoT) system from Philips Hue, part of lighting manufacturer Signify, includes a mobile app. This allows end users to control their smart-home lamps both locally and remotely. They rate their experiences with the mobile app and the rest of the IoT system via Google Play or the App Store. Due to the large number of ratings and reviews, it is time-consuming to analyse them manually and recognise recurring themes.

Following a reorganisation and introduction of new strategic propositions, the main targets on the Consumers' Association website were no longer structurally maintained. Several reports from different systems were circulating. Different teams also worked on various, sometimes conflicting objectives. Working with Deloitte, we provided insight into website achievements in an accessible way and instituted a process for continuous improvement of these achievements.

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.

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.

ONE Business websites allow users to buy subscriptions to various magazines. The online sales funnel can hereby be dynamically divided for each offer. For example, it is possible to give users free term choices or to limit them to a specific offer. Because the sales funnel is dynamic, it is impossible with the standard Google Analytics implementation to gain good insight into the customer journey. ONE Business asked us to provide insight into where people opt out and why. This will enable them to optimise the funnel for more online conversions.

Elsevierweekblad.nl is an online platform with news, opinion and background information. Various authors write articles on a variety of relevant topics on a daily basis. Elsevier Weekblad wanted to get a better grip on the content formula behind this. This required insight into the extent to which the types of content contribute to reach, engagement and sales of subscriptions.

Organisations collect as much data as possible to map out the Customer Journey. After analysis, this combination of quantitative and qualitative data provides insight into the what and why of customers or visitors. These insights should prompt action. It is important to communicate the insights well, so that the right actions are taken. You can do that with storytelling.

Data analysis leads to clear, action-oriented insights that ensure the right decisions are made. At least, that's how it should go. To the frustration of many Data Analysts, they view carefully presented insights but little reflected in concrete actions.

Are you going to make decisions based on data? Then you have to ensure that your data quality is in order. Good documentation according to a clear process is essential here. Why and how? You can read it in this article.

"There are three kinds of lies: lies, blatant lies, and statistics," said former UK Prime Minister Benjamin Disraeli. This also often applies to the use of data, because you cannot blindly trust data if you do not know the background.

Key Performance Indicators or KPIs are indispensable to keep track of the performance in an organisation in a practical way. It is therefore important to choose the right KPIs and to keep a clear distinction between KPIs and PIs. In any case, KPIs must match the mission and vision of your company. In this article, Rogier explains how to determine your KPIs and shows you the most common mistakes.

If you use BigQuery, whether or not in combination with Google Data Studio, it is useful to keep track of your query costs. You also want to know which queries contribute the most to this. In this article we explain how your BiqQuery costs are generated and how you manage them as efficiently as possible.