Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do I use Power BI to compute the following functions 1. Converting all columns so that they use metric (International System of Units, SI)
How do I use Power BI to compute the following functions
1. Converting all columns so that they use metric (International System of Units, SI) or derived units.
2. Converting the time_hour column to date-time.
3. Computing daily mean temperatures for the JFK airport.
4. Presenting the daily mean temperatures on a plot.
5. Finding and displaying the five hottest days
Your aim is to create a single data visualisation dashboard using Tableau Public or Power BI that can be viewed by the marking tutors through a web browser. The choice of the data visualisation tool is up to you. Your aim is to reproduce the analysis that you have performed while 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. 2. Converting the time_hour column to date-time. 3. Computing daily mean temperatures for the JFK airport. 4. Presenting the daily mean temperatures on a plot. 5. Finding and displaying the five hottest daysStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started