Introduction

This dashboard is built to prove that it isn't all about winning when you go along with challenge data.

This challenge is completely focused on cleaning data. The given data is as raw as you can imagine and I don't have the time and the skills to do so right now.

But as you have to practice what you preach, I only took the data of 2023, cleaned it a little, enriched it with interesting new columns, and built a dashboard using Themes.pbix all the way.

The Data

The data of this challenge is very raw. Per year you have gotten an Excel sheet with a different lay-out and a lot to clean.

Link to the data : Link

The Analysis

I tried out the themes.pbix for the following visuals

• (Stacked) Bar chart
• (Stacked) Column chart
• Line chart
• Donut chart
• Map
• New Crad
• Textbox
• Shapes

It works really well, I hope the new Azure map will be added soon.

The Visuals

I always only use core visuals. As easy as possible and with as little as needed clutter link the Y-axis and gridlines.

Normally I'm not using stacked bar and column charts. They aren't easy to compare. But for this dashboard, I used them to try out the possibilities.

The Key Insights

Key insights weren't the main reason for building this dashboard. But I did add a couple of columns to show for example if the outage started within office hours or how long the outage took.

the real key insight to me is that I'm extremely happy with this tool and will use it for all current and future dashboard projects.

The Design

After looking around on the internet using the word "paintings" I have chosen to put the painting "meisje met de parel" from Johannes Vermeer in the Adobe color tool, which gave a really nice palette.

Besides the color choose, I also focussed on the lay-out of the whole dashboard.

I alligned all visuals, inclusive the new card.

I used the divider to highlight questions I added at the top of the visuals.

I rounded all visuals with 5 px.

All visuals start and end with a 0, like here

Comments

You can explore and learn a lot from playing around with challenge data. If you know your entry wouldn't be for the win, focus on the data you need to practice what you want to learn.