Completado

Excel expert

Este proyecto fue completado exitosamente por P0L por £100 GBP en 2 días.

Obtén cotizaciones gratis para un proyecto como este
Empleador trabajando
Presupuesto de Proyecto
£20 - £250 GBP
Completado En
2 días
Ofertas Totales
7
Descripción del Proyecto

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

Completado por:
Habilidades Requeridas

Buscando hacer algo de dinero?

  • Establece tu presupuesto y período de tiempo
  • Describe tu propuesta
  • Consigue pago por tu trabajo

Contrata Freelancers que también oferten en este proyecto

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