Todays challenge was to analyze data from the tv show survival. The data was relatively clean so it gave us a lot of time for creativity. However, the way that the presentation is planned involves providing explanations and justifying why we chose each chart.
The first thing I did was gain an understanding of what the data shows. Luckily there was a detailed data dictionary which clearly explained each field.
![](https://www.thedataschool.co.uk/content/images/2023/01/image-540.png)
However, due to the way the data was joined we had to keep in mind any duplication that may occur. (See below)
![](https://www.thedataschool.co.uk/content/images/2023/01/image-541.png)
Once I had an understanding of what my data shows, I started planning what I wanted my dashboard to look like using excalidraw.
![](https://www.thedataschool.co.uk/content/images/2023/01/image-544.png)
I decided to join additional data to my table which had information on the imdb ratings which is what I would base my dashboard on.
![](https://www.thedataschool.co.uk/content/images/2023/01/image-543.png)
I joined them based on the following:
![](https://www.thedataschool.co.uk/content/images/2023/01/image-546.png)
Once I joined my tables I started creating my chart. I quickly realized that the charts would take longer than I expected as there would be repeated measures which would need to be changed using LODS.
![](https://www.thedataschool.co.uk/content/images/2023/01/image-548.png)
Overall, it was a difficult challenge but I enjoyed seeing what I could come up with in the short time we had!