Completed

Excel expert

This project was successfully completed by P0L for £100 GBP in 2 days.

Get free quotes for a project like this
Employer working
Project Budget
£20 - £250 GBP
Completed In
2 days
Total Bids
7
Project Description

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

Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

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