Dashboard: Star Wars Dashboard

This dashboard answers the following questions:

How many starships are cataloged in the database?
What is the distribution of planet populations across the galaxy?
Which species has the highest average height?
What are the most common climates on planets within the Star Wars universe?
Which manufacturers have produced the most starships?

This dashboard contains 4 cards.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/powerpipe-mod-starwars

Start the Powerpipe server:

powerpipe server

Open http://localhost:9033 in your browser and select Star Wars Dashboard dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run starwars.dashboard.starwars --share

Queries

This dashboard uses the the following queries:

select
  name,
  cast(average_height as integer) as average_height
from
  species
where
  average_height not in ('N/A', 'NA')
order by
  average_height desc
limit 10;