The City of Metro is the largest parking authority in the UK with

$40000$

$$parking bays. And with half a million vehicles driving into the borough every day, it is also one of the busiest. Metro City Council does not have a holistic view of which streets are under greatest demand for parking, and which are underused. The Council

$$

s Parking Services division collects all manner of data, such as parking tickets and pay

$-$

by

$-$

phone transactions that describe the use of parking services. However, the data is spread across a number of departments and outsourced suppliers and is typically collected in spreadsheets. Pulling the data together to analyse a single street is a laborious task. The City has a dozen of of large public halls which get booked for large events e

$.$

g

$.$

$$community charity events, weddings, local school

$$

s events etc. This causes variations in the demand for parking which requires a degree of preplanning on organizing the parking Marshalls. But those variations could be predicted if the event booking system is integrated.

$$

$$

The biggest problem really is that a lot of data is sitting in disparate sources,

$$

$$explains Lani Ballings,

$[$

information analyst and

$$

project manager

$$

$$wannabe

$]$

$$at the Parking Services unit.

$$

Collating all that information to work out how occupied a street is at a certain time of day is a manual task that took four days.

$$

$$

In April, the council decided that it needed a better overview of parking trends, so that it could direct drivers to streets with low occupancy. It also wants to integrate its events booking system with the Parking Services Unit to enable better prediction, scheduling and rostering of Marshalls. To do this, it wants to migrate three years

$$

$$worth of parking data and event booking records into an existing departmental data warehouse. To analyse and visualise that data, it aims to use QlikView

$$

s in

$-$

memory business intelligence solution. This can greatly accelerate the speed with which the Parking Services unit can interrogate historical data to identify trends.

$$

We hope to return the data within about half an hour,

$$

$$says Ballings.

$$

Furthermore, it wants to allow the unit to integrate the data with its geographical location systems, to enable creating a heat map of parking bay occupancy.

$$

The council wants to use this data to roster and deploy parking marshals in busy streets, to tell drivers where they could find a better parking spot.

$$

It

$\text{'}$

s more expensive for us to manage the process of issuing a ticket or to reduce business activities due to traffic of people circling for a parking space,

$$

$$says Ballings.

$$

Instead

$,$

$$we far prefer an adequate number of marshals to interact with delivery companies, visitors, and other motorists in the area to try and encourage them to change their parking behavior by telling them where they're more likely to find available space.

$$

$$

Deploying marshals in busy spots can improve the occupancy of parking spots in less busy streets. The council wants to give parking marshals real

$-$

time data to direct drivers based on up

$-$

to

$-$

the

$-$

minute trends. Marshals will access real

$-$

time data using their own mobile devices.

$$

The council wants to eventually install sensors in parking bays in popular streets

$($

as revealed by the QlikView deployment

$)$

$$that record when a car enters and leaves the spot. Drivers can access that data through a smartphone app, which shows them which spots are free right when they need it

$.$

$$Ballings says:

$$

We hope to get a much greater level of understanding as to how parking bays are used. We have found that vehicles parking at

$9$

am stay for just over an hour, whereas cars at

$5$

pm tended to stop for just five or

$10$

$$minutes$.$ When that integration takes place, Marshals will also be able to use the app themselves to direct traffic in real time and in future

$$

$,$

$$Ballings says,

$$

it will allow drivers to pre

$-$

book parking bays and the council to vary pricing based on demand

$$

$.$

$$

The City of Metro recruited your team to initiate the project to develop a prototype of the above system with all the functionalities described by Ballings.

$$

$$

Project preliminaries

$$

You will work in groups comparable to a Scrum team on an information systems development project. So

$,$

$$the size of the group is expected to be around

$6$

$$members$.$ All members of the group must belong to the same tutorial class. The group needs to remain the same across both Part A and Part B

$.$

$$Any issues within the group need to be resolved or reported to the tutor as soon as they arise. A peer review process will be executed later during the marking if such issues arise, or generally a peer review process is used if the tutor deems it needed or if any member of the group raises an issue on the fairness of the effort expended during the project. Create a user story for project manager and list POV statement and $10$ How Might we statement $???$