Welcome to the third day of Dashboard Week at Data School Down Under! Today’s challenge is all about the beloved Star Trek universe. Who doesn’t love Star Trek with its great TV shows and captivating storytelling? But, with so much media content spanning over 50 years – TV shows, movies, books, and comics – it’s easy to get overwhelmed!

Fear not! We have an exciting solution for you. Using the Airtable provided, you can now organize and explore all the Star Trek media in one place. Let’s embark on this fun journey together!

Step 1: Explore the Data

The challenge involves working with multiple datasets from Airtable. After downloading the data, I decided to focus on the TV series, Movie, and Official Book datasets to keep things manageable within the time frame.

Step 2: Clean the Data

Before diving into the visualizations, I took the time to clean the data, making necessary changes like removing null values, adjusting data types, and splitting episode names into seasons and episode numbers using RegEx. Additionally, I enriched the Movie data by adding new IMDB movie ratings for a more comprehensive view.

Step 3: Layout the Dashboard

For a visually engaging experience, I designed a long-format dashboard divided into three main sections: TV Series, Movies, and Books. To add a touch of creativity, I opted for a floating dashboard layout instead of a traditional tiled layout.

Step 4: Build Charts

TV Series

To showcase the TV series data, I leveraged radial bar charts. This elegant design allows for an intuitive representation of seasons and episodes in each season. A filter enables users to switch between different series, each represented by a distinct color.

Additionally, I added a description sheet that appears in the middle when users click on a dot in the radial bar. This way, users can easily access detailed information about specific episodes.


With only 13 movies in the dataset, I created a timeline chart to visualize their release dates. To enhance the visual appeal, I incorporated movie banner images.

I also included brief descriptions, including IMDB ratings, accessible when clicking on a dot. (These are formatted in order match the background of the dashboard)


Inspired by a fantastic dashboard I saw recently, I decided to create interactive bookshelves for the official Star Trek books. Since the original dataset lacked dimensions for the books, I added height and width measures to create the shelves. Each book is color-coded by series type, and the shelves are divided by genre for a clean and organized display. Hovering over a book provides detailed information about the chosen title.

Step 5: Putting Them All Together

To create a harmonious floating dashboard, I fixed the dimensions and added a suitable background image to set the Star Trek theme. I placed all the charts, ensuring an aesthetically pleasing layout. See the final dashboard after Step 6.

Step 6: Formatting

The final touch involved formatting to keep the dashboard clean and tidy. Hiding legends using show/hide buttons, customizing tooltips, and choosing a unique font improved overall presentation.

Voila! The result is a visually appealing and informative dashboard that allows Star Trek fans to explore and enjoy the vast media universe in one place.

May your journey through the Star Trek cosmos be filled with joy and discovery!

The Data School
Author: The Data School