Question: Your aim is to create two data visualisation dashboards that can be viewed by the marking tutors through a web browser: one using Tableau Public

Your aim is to create two data visualisation dashboards that can be viewed by the marking tutors through
a web browser: one using Tableau Public and one using Power BI.
Make sure that each dashboard includes your name, student ID, and student group.
Reproduce the analysis that you have performed when solving task 4P, i.e., of the nycflights13_weather.csv.gz (manually decompress the file first) dataset, which gives the hourly
meteorological data for three airports in New York: LGA, JFK, and EWR for the whole year of 2013.
This includes:
1. Converting all columns so that they use metric (International System of Units, SI) or derived units
(replace old or add new columns).
All data transformations must be done using PowerBI and Tableau! Do not pre-process
the datasets in pandas.
2. Computing daily mean wind speeds for the LGA airport.
3. Presenting the daily mean wind speeds at LGA on a plot (a line graph, whatever is more readable).
4. Identify the 10 windiest days at LGA. Present them in a table (dates and the corresponding total
precipitation).
5. Visualise the monthly mean wind speeds at the three airports (on a single plot). Please help with the plots and link to the dashboards.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!