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.
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