Data Warehousing

The project was envisioned in 2004 and the first phase included the setup of the necessary hardware and software components as well as the implementation of a standardised data model / framework which would act as the basis for the data warehouse moving forward. Phase II of the Data Warehouse & Business Intelligence (ICDS) project was initiated in June 2007. The major component of phase II of the ICDS project was the sourcing of six Government of Punjab departmental source systems into the data warehouse. The source systems that were sourced into the data warehouse in Phase II include:

  • Land Records Management Information  System (LRMIS)
  • Computerisation of Lahore General Hospital (LGH)
  • Punjab Provincial Cooperative Bank Limited (PPCBL)
  • Punjab Public Service Commission (PPSC)
  • Motor Transport Management Information System (MTMIS)
  • Excise and Taxation

This initiative has been deployed in 36 districts across Punjab and is being actively used for:

  • Data Integration of Call Data Records, BTS Records, Subscriber, Driving License, Motor Vehicle, FIR, Crime Mapping, Geo-spatial Maps, Hotel Check-ins, Criminal Record Office and Tenants Systems
  • In Depth Criminal Profiling from across the source systems (CDR, Subscriber, Driving License, Motor Vehicle, FIR, Crime Mapping, Geo-spatial Maps, Hotel Checkins, Criminal Record Office etc.)
  • Centralised Citizens’ Verification : The integrated data feed from this solution is being provided to other systems of
  • PITB like Tenants Registration System, Hotel Eye System etc. which helps verify citizens on runtime.
  • In-depth- Granular CDR Analytics
  • Pre Crime Analysis
  • Post Crime Analysis
  • Geo Fencing and Geo Spatial Crime Analysis
  • Temporal Crime Analysis
  • IMEI Handset Based Analytics
  • Mobility Profiling of suspects
  • Social Network Analytics of suspects and criminals
  • Suspects’ Communication pattern and intermediary persons identification

This initiative has resulted in:

  • Timely and efficient reporting and 360 degree view of activities for the Chief Minister Punjab and other top management
  • Criminals Network Analysis
  • Location based Insights
  • Suspects Profiling and Movement
  • Predictive Crime Intelligence
  • Handsets Analytics
  • IMSI Data Analytics for suspect’s Real Time Identification and Movement
  • PITB’s Centralised Information HUB
Case Closures Weekly Average as per Punjab Police 5 to 10
Total FIRs Investigated Using this System 9,619
Total Data Source Integrated 12
Total Call Data Records Integrated for Analysis 87.3M
Total Districts of Deployment 36
Total Police Ranges of Deployment 10
Total Users of Punjab Police and CTD >6