Dashboard day 3 use chat GPT to make a data set and then build a KPI dashboard.
The scene!
In the not-so-distant future, humanity's insatiable curiosity and technological prowess have propelled us into the realm of interstellar travel. InTILstellar a Galactic Transport company at the forefront of this cosmic journey, provides an intriguing dataset that offers a glimpse into the vastness of its operations.
This dataset encapsulates the essence of both the familiar and the fantastical. Comprising 25,000 rows of data, it combines mundane passenger information with exotic cargo specifics. Passenger details include names, ages, and even their alien races, with over 20 distinct options to cater to our diverse interstellar society. Ticket prices vary depending on class, reflecting the length of the voyage – economy for the frugal traveler, business for those seeking comfort, and first-class luxury.
The dataset also embraces the cosmic calendar, marking departures and arrivals from the years 2999 to 3000.
Intriguingly, this dataset fuels the imagination, inviting questions about our potential future and the boundless opportunities of interstellar commerce. Galactic Transport Co. is truly charting a new course in human exploration and trade, with their data as a testament to the endless possibilities that await among the galaxies.
The struggles began straight away when chat GPT threw up strange data set after storage data set however eventually I had a script which when posted into Jupiter notebook (after lots and lots of errors ). Gave me 25,000 rows with arrival and departure dates cargo types of passenger tickets prices and volumes for all the above so far so good. Copy and pasting the error messages from Jupiter Notebook into
I had spent so much time trying to fix the data that the dashboard was a rush job. I put together a simple set of KPI comparing this year to last year (3000 to 2099 ) . Allowing the CEO to see the difference in Sales for both tickets and cargo filtered by various categories.