__STYLES__

How to build a challenge dashboard: How to use a color theme at the Power Outage Challenge

Tools used in this project
How to build a challenge dashboard: How to use a color theme at the  Power Outage Challenge

About this project

undefined


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.

undefined

undefinedBesides 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

undefined


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.

Discussion and feedback(1 comment)
comment-624-avatar
hiral modi
7 months ago
I really like your approach towards learning and practicing new tools. I like your comments about "If you know your entry wouldn't be for the win, focus on the data you need to practice what you want to learn".
2000 characters remaining