As part of The Data School training program, one of the most exciting and challenging weeks was Dashboard Week. During this week, we were given a dataset each morning and tasked with building a dashboard that would effectively communicate insights gleaned from the data by the end of the day. The next morning, we would present our findings to the rest of the cohort, receiving feedback and insights from our peers and coaches.

This cycle continued for the rest of the week, with each day bringing a new dataset and a new set of challenges to overcome. It was an intense and rewarding experience, requiring us to work quickly and efficiently while still producing a high-quality output.

links to my other Dashboard Week Challenge Blogs:

The Challenge and My Goal

During the first day of Dashboard Week, we were challenged to uncover insights from SpaceX data on GitHub and craft a compelling narrative. Although I was initially unfamiliar with the world of space travel, I focused on the fundamental aspects of the task and prioritized my dashboard accordingly, dividing it into three key sections:

  1. Spaceship Launches by Outcome: This section highlighted the success and failure rates of SpaceX launches, providing an overview of the company’s track record and identifying any trends or patterns.
  2. Spaceship Launches by Rocket Type: This section focused on the different rocket types used by SpaceX and how they fared in terms of launch outcomes. By comparing and contrasting the performance of each rocket type, I was able to identify which ones were most successful and which ones needed improvement.
  3. Year-over-Year Comparison of Launches: Finally, this section provided a historical overview of SpaceX launches, comparing launch frequency and outcomes year-over-year. By visualizing this data, I was able to identify any significant trends or changes in the company’s launch strategy over time.

Data Understanding and Cleaning

To obtain the necessary data, I primarily utilised the Launch Table and the Rocket Table. Once I had retrieved the data, I performed data cleaning and wrangling to ensure that it was accurate and usable.

To consolidate the data and establish the relationship between each launch and its corresponding rocket type, I merged the two tables. The resulting Alteryx Workflow allowed me to effectively manage and manipulate the data to generate the insights necessary for my dashboard.

Dashboarding

In order to make my dashboard interactive and customizable, I made use of parameters. These parameters allowed me to change certain variables within the dashboard, such as the year being analyzed, with just a few clicks. This not only made the dashboard more user-friendly but also enabled me to generate insights that were tailored to specific needs.

Furthermore, I incorporated Key Performance Indicators (KPIs) into the dashboard, which were dynamically linked to the latest and prior years that I had selected. This allowed for real-time comparison between the two time periods and provided a more comprehensive understanding of the data.

Insights and Future Steps

here are the insights you can potentially draw from my dashboard:

  • There were no launches by SpaceX in 2011.
  • In 2022, SpaceX conducted 60 launches, which is nearly double the number from the previous year.
  • With the exception of 2019, the number of launches by SpaceX has steadily increased over the years.
  • Over time, SpaceX has shifted towards using more Falcon 9 and Falcon Heavy Rockets, which have significantly increased reusability and require less maintenance compared to previous versions.

If I have more time, I would like to look into the reusable rocket by showing the number of times each rocket has be reused.

The Data School
Author: The Data School