Zakończony

Excel expert

Ten projekt został pomyślnie zakończony przez P0L za £100 GBP w 2 dni.

Otrzymaj darmowe wyceny do podobnego projektu
Pracodawca pracuje
Budżet Projektu
£20 - £250 GBP
Ukończony W
2 dni
Ofert Razem
7
Opis Projektu

You have been supplied with the following .csv files containing data sourced from the London Fire Brigade:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

Prior to commencing your analysis you are advised to examine and cleanse the data. You are to use the data supplied in these files to answer the following business questions:

Question 1 - Using the [url removed, login to view] file

a) Create a spreadsheet including a lookup function such that a user can select a fire station and all vehicles assigned to the station will be displayed.

b) Extend a) by displaying the results from the look up on a map.

c) Create a spreadsheet including lookup functionality such that a user can look up vehicle status and/or make and all corresponding vehicles and their locations will be displayed.

Question 2 - Using the [url removed, login to view] file

a) Which station has responded to the highest number of requests for help from the London Ambulance service for help moving people over the last 5 years?

b) How has this changed year on year over the last five years?

Question 3 – Using the [url removed, login to view] and [url removed, login to view]

a) What is the most common type of incident that the London Fire Brigade respond to?

b) Which are the top 5 areas of London with the highest number of incidents, ranked highest to lowest?

c) On average how long does it take a Fire Engine to attend the most common type of incident in the top five areas identified in b)?

d) For each of the top 5 areas identified in b) how has the response time identified in c) changed over the last 6 years?

We will provide the files listed above

Ukończony przez:
Wymagane Umiejętności

Chcesz zarobić trochę pieniędzy?

  • Napisz kwotę, za jaką jesteś w stanie podjąć się projektu i przedział czasowy, w którym będziesz w stanie go zrealizować
  • Opisz, w jaki sposób wykonasz projekt
  • Otrzymaj wynagrodzenie za pracę

Zatrudnij Freelancerów, którzy również składają oferty do tego projektu

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online