MIP Logo

Dashboard Week – Day 3: Star Wars

This post was originally published on The Data School blog between 2018 and July 2025, before our program was renamed to MIP’s Analytics Career Accelerator. References throughout this article to “The Data School” or “DS” all refer to what is now MIP’s Analytics Career Accelerator. The program, its people, and its commitment to launching outstanding analytics careers remain the same – just under a new name.

If you are having trouble viewing this article, please report it here. 

Today was day 3 of Dashboard Week, and the challenge was Star Wars API data from SWAPI – The Star Wars API.

Data Preparation

Firstly, the data was not readily available, so an API was required to pull the data. Once the data was retrieved, it needed to be cleaned and transformed.

My Alteryx workflow looked like this:

Dashboard

Initially, I wanted to use all 6 tables, but after a few hours decided to use 3 out of the 6 tables, Planets, Species and People. It was quite challenging to tell a story with the data, but it was quite fun using the API and preparing in Alteryx. In the end, I decided to make some comparisons with Earth.

Here is my dashboard.

Insights

It would appear that there are a fair few planets in the Star Wars data base that have a very similar gravitational pull to that of Earth. These planets also have between 60-80% of their surface area covered by water (Earth is about 75%).
It was found that in the Star Wars Universe, we could relocate to another planet if Earth became unlivable.

You can view my tableau dashboard here:
Star Wars | Tableau Public

Check out the other days of Dashboard Week:
Dashboard Week – Day 1: Global Power Plants
Dashboard Week – Day 2: CPI and the 5 WHY’s
Dashboard Week – Day 4: ABS Census
Dashboard Week – Day 5: AFL

MAY THE DATA BE WITH YOU!

I hope you have enjoyed the post, and I will see you next time.

Share this post

Dashboard Week – Day 3: Star Wars

This post was originally published on The Data School blog between 2018 and July 2025, before our program was renamed to MIP’s Analytics Career Accelerator. References throughout this article to “The Data School” or “DS” all refer to what is now MIP’s Analytics Career Accelerator. The program, its people, and its commitment to launching outstanding analytics careers remain the same – just under a new name.

If you are having trouble viewing this article, please report it here. 

Today was day 3 of Dashboard Week, and the challenge was Star Wars API data from SWAPI – The Star Wars API.

Data Preparation

Firstly, the data was not readily available, so an API was required to pull the data. Once the data was retrieved, it needed to be cleaned and transformed.

My Alteryx workflow looked like this:

Dashboard

Initially, I wanted to use all 6 tables, but after a few hours decided to use 3 out of the 6 tables, Planets, Species and People. It was quite challenging to tell a story with the data, but it was quite fun using the API and preparing in Alteryx. In the end, I decided to make some comparisons with Earth.

Here is my dashboard.

Insights

It would appear that there are a fair few planets in the Star Wars data base that have a very similar gravitational pull to that of Earth. These planets also have between 60-80% of their surface area covered by water (Earth is about 75%).
It was found that in the Star Wars Universe, we could relocate to another planet if Earth became unlivable.

You can view my tableau dashboard here:
Star Wars | Tableau Public

Check out the other days of Dashboard Week:
Dashboard Week – Day 1: Global Power Plants
Dashboard Week – Day 2: CPI and the 5 WHY’s
Dashboard Week – Day 4: ABS Census
Dashboard Week – Day 5: AFL

MAY THE DATA BE WITH YOU!

I hope you have enjoyed the post, and I will see you next time.

Share this post

Dashboard Week – Day 3: Star Wars

This post was originally published on The Data School blog between 2018 and July 2025, before our program was renamed to MIP’s Analytics Career Accelerator. References throughout this article to “The Data School” or “DS” all refer to what is now MIP’s Analytics Career Accelerator. The program, its people, and its commitment to launching outstanding analytics careers remain the same – just under a new name.

If you are having trouble viewing this article, please report it here. 

Today was day 3 of Dashboard Week, and the challenge was Star Wars API data from SWAPI – The Star Wars API.

Data Preparation

Firstly, the data was not readily available, so an API was required to pull the data. Once the data was retrieved, it needed to be cleaned and transformed.

My Alteryx workflow looked like this:

Dashboard

Initially, I wanted to use all 6 tables, but after a few hours decided to use 3 out of the 6 tables, Planets, Species and People. It was quite challenging to tell a story with the data, but it was quite fun using the API and preparing in Alteryx. In the end, I decided to make some comparisons with Earth.

Here is my dashboard.

Insights

It would appear that there are a fair few planets in the Star Wars data base that have a very similar gravitational pull to that of Earth. These planets also have between 60-80% of their surface area covered by water (Earth is about 75%).
It was found that in the Star Wars Universe, we could relocate to another planet if Earth became unlivable.

You can view my tableau dashboard here:
Star Wars | Tableau Public

Check out the other days of Dashboard Week:
Dashboard Week – Day 1: Global Power Plants
Dashboard Week – Day 2: CPI and the 5 WHY’s
Dashboard Week – Day 4: ABS Census
Dashboard Week – Day 5: AFL

MAY THE DATA BE WITH YOU!

I hope you have enjoyed the post, and I will see you next time.

Share this post