Data Warehouse for Government of the Punjab

1
Data Warehouse for Government of the Punjab

• Information Technology Department
• Government Of Punjab

Background, Status and Direction
2
What Is a Data Warehouse?

• A Data Warehouse (DW) an integrated and
  centralized repository of historical, detailed
  data that supports multiple decision making
  applications for multiple groups.

Data Warehouse
Data Warehousing is a process, not a product.
3
Why Data Warehousing?

• Data is the most valuable asset any company has.
• To make better decisions, you need to exploit
  that
• data and have better access to it.
• Why? Data can answer any business problems
  and/or solve challenges.
• Integrated data takes you to the next level
• of analysis and decision making.

4
Process
Workload Complexity
Increase in Ad Hoc Analysis
Data Sophistication
Human Discovery
Machine-assisted Discovery
Query and OLAP tools
Data Mining tools
5
Data Warehouse for Government of the Punjab
Location-Information Technology Department ,
Government of the Punjab. Authorities
Responsible for1. Sponsoring- Information
Technology Department2. Execution-
Information Technology Department3. Operation
and maintenance- Information Technology
Department 4. Concerned federal
ministry Ministry of Science and Technology
6
Data Warehouse for the Government of the Punjab

• Phase I
• as a component of the Punjab Portal
• The main objective of this phase is to make a
  framework for Govt. of the Punjabs Data.
• Project duration 2003-05 (30 months)
• Total Project Cost 6 million out of 23.585
  Million of Punjab Portal
•  
• Phase II
• The main objective of this phase is to add six
  departmental databases to this central
  repository.
• Project duration 2006-07 (18 months, January
  2006-June 2007)
• Actual Completion Date April 20, 2008 (Because
  some departmental databases were not completed in
  June 2007)
• Total Project Cost 18.082 Million
• Total Expenditure 13.157 Million.

7
Data Warehouse for the Government of the Punjab

• Background
• Punjab Data warehouse Project is meant to
  provide Data Integration framework based on
  single and common repository. Data from all the
  departmental databases would be Extracted,
  Cleaned, Transformed and Loaded into the Data
  Warehouse. This consolidation of data will
  facilitate consistent and uniform view of the
  data from various departments thus, providing
  single version of the truth. This framework
  will be based on industry best practices for
  decision support system and business
  intelligence. The Data Warehouse project will
  encourage inter and intra department data
  analysis, monitoring of operational performance
  and enable future planning relating to these
  departments.

8
Related Projects

• The data warehouse requires a fleet of mature
  databases which serve as the sources of raw data
  for the warehouse. Following projects has been
  successfully added in the project-
• Motor Transport Management Information
  System (MTMIS)
• Motor Vehicle Registration Management Information
  System (MVRMIS)
• Transport Department Management Information
  System (TDMIS)
• Driving License Management Information System
  (DLMIS)
• Excise Taxation (ET)
• Entertainment Duty
• Excise Duty
• Hotel Tax
• Professional Tax
• Property Tax
• Punjab Public Service Commission (PPSC)

9
Punjab Government EDW/BI Architecture
10
Data Warehousing Benefits

• Single version of the truth.
• Integrated View of Citizen based on his/her
  interactions with various government departments
• Efficient use of resources via better decision
  making.
• Quality E-Governance
• Centralized and coordinated information
  dissemination to the
• Citizens
• Agencies
• Government Officials
• Efficient and enhanced inter departmental
  collaboration
• Ensure consistency in information sharing
• Provide efficient services to the public.

11
Example Education

• Business Issues
• How many schools to open
• Where to open schools
• Are services consistent among population
• Are educational resources properly allocated
• Schools with no children children with no
  schools

12
EDW/BI SCREENSHOTS
13
What is the year on year trend for Transport
Department?Which vehicle types are counting for
maximum licenses in 2008?
14
Summary of Transport Department
15
What is the selling trend of Vehicle
Manufacturers in Punjab?
16
Top Selling Cars in Punjab
17
Selling trends of Vehicles
18
Driving License
19
Which vehicles does this driver owns? Just one
click will do it!!
20
So I have found the details of vehicle
registration of this owner!!
21
Food Stamp Data Trends
22
Food Stamps Which district have low
salaries?Application counts based on the salary
slabs division?
23
(No Transcript)
24
(No Transcript)
25
Way Forward EDW Strategy 2009-2010
26
Strategy

• Efficient and enhanced inter departmental
  collaboration
• Taking Punjab Government EDW to the next level of
  maturity
• Ensure consistency in information sharing
• Provide efficient services to the public.
• Reducing cost of delivery.
• Decision making through the Business Intelligence
  reporting and dashboards.
• Making Data warehousing/BI education an important
  part of College/University curriculum in Punjab
  with the help of Teradata

27
NIC based Integrated Citizens Portal
28
NIC based Integration

• Citizens 360 degree view can be seen through the
  Teradatas Enterprise Data Warehouse and BI
  solution.
• The detail records of the Citizen can be
  retrieved across different dimensions including
  but not limited to
• Citizens Detail Info (NIC Based)
• Citizens Family Details
• Citizens Driving License Details
• Citizens Motor Vehicle Registrations
• Citizens Criminal Records
• Citizens Land Record Details
• Citizens Excise and Taxation Details (Property,
  etc)

29
Citizens Driving License Detail
30
Citizens Land Records Details
31
Citizens Motor Vehicle Details
32
Thanks