Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Mining Concepts And Techniques

Authors: Jiawei Han, Micheline Kamber, Jian Pei

3rd Edition

0123814790, 9780123814791

More Books

Students also viewed these Databases questions

Question

Derive expressions for the rates of forward and reverse reactions?

Answered: 1 week ago

Question

Write an expression for half-life and explain it with a diagram.

Answered: 1 week ago

Question

What do you mean by underwriting of shares ?

Answered: 1 week ago

Question

Define "Rights Issue".

Answered: 1 week ago

Question

What did they do? What did they say?

Answered: 1 week ago