Выполнено

Excel expert

Этот проект был успешно выполнен P0L за £100 GBP за 2 дней.

Получить бесплатно ценовые предложения для подобного проекта
Работодатель работает
Бюджет проекта
£20 - £250 GBP
Выполнено за
2 дней
Всего заявок
7
Описание проекта

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

Выполнено:
Требуемые навыки

Хотите заработать немного денег?

  • Укажите свой бюджет и срок
  • Опишите свое предложение
  • Получите оплату за свою работу

Нанять фрилансеров, которые также подали заявку в этот проект

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