November 26, 2019
User sessions, page views, click-through rate, likes, retweets, etc. The amount of data that show how your target audience engages with your website, is huge. Many companies understand that there is a goldmine of business intelligence hidden within this enormous pile of data. But in order to find gems of insights, a lot of digging is required. Usually at least.
A user-friendly and integrated dashboard is a helpful companion in this quest for insights. Recently, we created a dashboard for one of our clients to help them fully leverage the data they collect from their online platforms.
In this article, we will show you how such a dashboard can be a valuable asset both for day-to-day work and for strategic, long-term planning.
One of our clients is a global provider of medical devices and equipment. They produce highly specialised innovative solutions for medical institutions all over the world and employ more than 10,000 employees in 40 countries all over the world.
As you would expect from a company that size, they have a broad online presence. Their website exists in 17 language versions and they are active on different social media platforms such as YouTube, Twitter and LinkedIn. They also use HubSpot for reporting on marketing and sales activities.
Our client was looking for a way to gather all the data coming from their platforms and organise them in a dashboard, customised depending on the role of the employee. By integrating and aggregating the right data sources, every employee should get a dashboard with information relevant to his/her day-to-day work.
At first glance, creating a dashboard might seem simple and straight-forward. Nowadays nearly all tools and platforms have an API. So to some extent you just have to combine these APIs with Microsoft Power BI, DAX, or some other sophisticated tool, put them in your favourite software and voila… You have your own dashboard.
To some extent this is the case. But to get the best out of your dashboard, there are a few extra elements you can take into consideration.
First of all, it’s a good idea to assess dashboard tools according to their efficiency, customisation options and the need for higher performance capacity. It should be possible to expand the dashboard and add more precision with for example Big Query, while retaining the same high efficiency.
With a good data warehouse as a foundation, you can start thinking about how to make insights more visual. Make sure to keep in mind this famous quote:
“[Design] is not just what it looks like and feels like. Design is how it works.”
An aesthetically pleasing dashboard is good, but the number one requirement for a tool to be successful is still how easy it is to use. Without great usability and UX, users won’t pick up your tool, even if it is the most brilliant in the world. Try to reduce the friction between the user and the interface and look for an intuitive angle.
Edward Tufte, the father of data visualization, gives a few tips on how to optimise visual representation of data:
In the picture below you can see a comparison of how Google Analytics represents data with the way we show data in our dashboards.
Google Analytics dashboard vs Making Waves dashboard
I think Tufte would be proud of our dashboard, right?
We combined our expertise about dashboard tools with the advice of Tufte and created personalised dashboards for our client’s employees. This way, the CEO can get high-level business insights, a marketeer can get a detailed overview of how many conversions a campaign is generating and a product owner will be able to keep close track of the number of page views of his portfolio.
We chose towork with Microsoft Power BI, for several reasons:
It allowed us to create a number of different dashboards, each showcasing different metrics and providing insights in the blink of an eye, bearing in mind Tufte’s principles of data visualisation for the graphical representation.
Please note that the pictures below contain fictional data:
With Power BI you can create an overview of traffic from different channels and platforms into a single report. Gathering and comparing these numbers can give us an idea of the absolute and relative value of a certain platform.
Track your traffic coming from different platforms.
Another important metric is the number of conversions generated by different platforms. It gives insights about which platforms or pages generate both customer interest and actual inquiries of the services of our client.
Track the evolution of your conversions.
Microsoft Power BI can also gather engagement data of different platforms to create a full overview of metrics as page views, bounce rate, unique visitors and many other. But it also allows to include company-specific KPIs in the dashboard. For our client, one of these KPIs is the number of downloads of PDF documents with equipment specifications. This is a good indication of genuine interest a company’s product portfolio.
Keep track on how your users engage with your website.
If you would have any questions about leveraging your data in a dashboard, don’t hesitate to get in touch with us. We can look into creating a dashboard that fits your needs. Get in touch via firstname.lastname@example.org.
Co-author & editor: Pieterjan Benoit
Paweł is a software professional with over 14 years of experience in development, and over 6 years in Microsoft technologies. He is currently involved in business intelligence and big data projects.
Contact Paweł: email@example.com