Case Study

Car Parking System Data Warehouse Solutions

Abstract

To consolidate data from Car Parking System, CCTV Cameras, IoT devices and ERP System into a cloud-based Enterprise Data Warehouse. Data scientist can study those data collected from different channels, and further analyze as big data.

PROJECT BACKGROUND

With the help of artificial intelligence application, a car park company can get business insights on how to upsell existing VIP customers and raise revenue by cross-selling other products to the right persons at the right time.

 

BUSINESS OBJECTIVES

To consolidate data from Car Parking System, CCTV Cameras, IoT devices and ERP System into a cloud-based Enterprise Data Warehouse. Data scientist can study those data collected from different channels, and further analyze as big data.

 

 

Data analysis data warehouse solution

SOLUTION/ TECHNOLOGIES

  • Integrate various data sources, like Car Parking System, CCTV Cameras, IoT devices and ERP system

 

  • Create custom-made programs to extract, transform, load (ETL) raw data into Enterprise Data Warehouse

 

  • Transform the clustered dataset into meaningful figures for senior management of Wilson Parking

KEY RESULTS

Recommend 5-year data management roadmap to Wilson Parking | Suggest industry best practice data management strategy to govern dataset from different sources | Complete total data solution was provided