data based intelligence
TRANSCRIPT
Page 2
Agenda
Scenarios of Economic Intelligence Unit
Sample Dashboards from Open Data.Gov
Data based Intelligence
Managing Performance and Perceptions
Page 3
Agenda
Scenarios of Economic Intelligence Unit
Sample Dashboards from Open Data.Gov
Data based Intelligence
Managing Performance and Perceptions
Page 4
Business Impact of Investments in ICT
Reporting Compliance
Faster Decision Making Budget Prioritization
Improved Performance
Moving from “How Much” to “How Well”
Strategic/Tactical Planning
Why Data based Intelligence
Transparency for Accountability
Page 9
Agenda
Scenarios of Economic Intelligence Unit
Sample Dashboards from Open Data.Gov
Data based Intelligence
Managing Performance and Perceptions
Page 10
Measuring Performance and Perceptions
Presentation title
Measure -- Decide -- Act -- Optimize
KPI Based performance
monitoring / analysis
Citizens perceptions
Analysis
Fact based Decisions, Alerts
and Actions
... to assess KPI based performance for individual
departments
Support in defining KPIs for individual departments
Customized dashboards designed as per each department expectations
Full department control on security and access
... To assess citizens feedback, perception and
need based survey analysis
Convert textual feedback into measurable components
Automated process for assess citizen sentiments through online news feeds, portals and social media
... to generate actions based on intelligence
Fact based decision making process
Automated alerts set as per needs of individual departments
Fully controlled and automated information sharing
How…
Setup a centralized Dashboard platform to enable KPI based performance management process
Hire expert services to define department level KPI’s / Dashboards
A
B
Real time performance assessment on service delivery
Effective citizen engagement
What…
Integrated view of Departments & Schemes
Scorecards
Department Data
State/National Schemes
Critical Projects
Hire Expert services for technology enablement
C
Citizen Grievances
Social Media Groups
Newspaper feeds
Data Integration and Transformation
Dashboards
Page 11
Structured approach to Performance Measurement
Presentation title
Vision
Sate Performance
Infrastructure
Healthcare
Strategic Objectives
Key performance drivers
Industry Growth indicators
GDP Growth
Per Capita Income
Top 5 performing business categories
Infrastructure development Index
Net generation power per capita
% of villages electrified
Outages, value lost (% of Sale)
% of roads by condition
Neo natal Mortality Rate
% of fully immunized children
Elderly population sparsity
Life expectancy rate
Literacy rate
Education Development Index
Employment to Population ratio
Net enrollment ratio in education
Education and Skill
Development
Identification of
Data Sources
Information
Access modes
Identify Analysis
Scenarios
Identify What-If
Scenarios
Identify
Presentation
needs
Information
security needs
KPI Details – Public Health (Indicative) S.NO Area Indicator Unit Formula Benchmark 1
1a Improved access to
Healthcare Services
OPD Services No in Lakhs
No of OPD for benchmark (1) No of OPD per 1,00,000 lakh population for benchmark (2) & (3)
1) X% y-o-y or m-o-m increase over base data 2) National Average (per 1,00,000 population) 3) Leading state (per 1,00,000 population)
1b
IPD Services No in Lakhs
No of IPD for benchmark (1) No of OPD to IPD conversion per 1,00,000 lakh population for the total number of hospital beds in the public hospitals for benchmark (2) & (3)
1) X% y-o-y or m-o-m increase over base data 2) X% y-o-y or m-o-m increase over base 3) Bed Occupancy Rate
2a
Increased affordability of services
through Health
Insurance
Total value of Claim (RSBY) settled
Rs Lakhs Claim Amount y-o-y and m-o-m increase over base data
2b
Total no. of claims settled (RSBY)
number Number of Claims Settled y-o-y and m-o-m increase over base data
3a
Improved access to
Emergency Transportation Services
108 Ambulances
Number No. of Trips Per Day y-o-y and m-o-m increase over base data
3b
No. of calls received by ambulance/ day
3c
Number of calls not serviced per day y-o-y and m-o-m decrease over base data
3d 102 Janani Express
Number No. of Trips Per Day y-o-y and m-o-m increase over base data
3e
No. of calls received by ambulance/ day
3f Number of calls not serviced per day
S.NO. Area Indicator Unit Formula Benchmark 1
4a
Maternal and Child
Health
Full ANC coverage rate
% % of women getting full ANC coverage as aginst the total no. registered mothers for ANC and delivery
1) X% y-o-y or m-o-m increase over base data 2) Comparison with National Average and Leading state
4b
Maternal Mortality Rate (MMR)
Per Lakh Live Births
Maternal Mortality Rate 1) X% y-o-y or m-o-m decrease over base data 2) Comparison with National Average and Leading state
4c
Full Immunization Coverage
Numbers Immunization Coverage as against the expected/estimated children population in the state
1) X% y-o-y or m-o-m increase over base data 2) Comparison with National Average and Leading state
4d
Infant Mortality Rate (IMR)
Per 1000 live births
IMR (Infant Mortality Rate) 1) X% y-o-y or m-o-m decrease over base data 2) Comparison with National Average and Leading state
4e
Availing full complement of JSSK services
number number of pregnant women receiving full complement of JSSK services against the total pregnant population
1) X% y-o-y or m-o-m increase over base data 2) Comparison with National Average and Leading state
5a Focus on population stabiliation
Birth Rates number births per 1000 population 1) No. y-o-y or m-o-m decrease over base data 2) Comparison with National Average and Leading state
5b
couple protection rate
% % of couple in reproductive age groups protected with terminal methods of sterilization
1) X% y-o-y or m-o-m increase over base data 2) Comparison with National Average and Leading state
5c
% % of couples in reproductive age group protected
KPI Details – Public Health (Indicative)
S.NO Area Indicator Unit Formula Benchmark 1
6a
Improved Healthcare
Service Effectiveness
Average Length of stay (ALOS)
In days No of days spent in IPD per patient X% Reduction y-o-y or m-o-m over the base data
6b Return to emergency in 72hrs
number No. of patients returning to the hospital within 72hrs
6c Return to OT in 24hrs number No. of patients returning to OT within 24hrs
6d Death within 48hrs number No. of patients dying within 48hrs of Cardio-pulmonary rescusitation
6e Referral from PHC to CHC or DHC
number No. of patients referred
7a
Maternal and Child Health
Caesarean sections deliveries
% % of CS as against total no. of deliveries in the state
1) X% y-o-y or m-o-m decrease over base data 2) Comparison with National Average and Leading state
7b Promotion of Institutional Delivery
% % of Institutional deliveries as against total no. of deliveries in the state
1) X% y-o-y or m-o-m increase over base data 2) Comparison with National Average and Leading state
7c Reduction in still birth rate % % of still born as against total no. of institutional deliveries in the state
1) X% y-o-y or m-o-m decrease over base data 2) Comparison with National Average and Leading state
7d Provision of free diet to mothers
number Number of facilities with catering services for provision of free dietary services
1) X% y-o-y or m-o-m increase over base data
7e Hospital stay of 48hrs after normal delivery
Number Number of mothers spending 48hrs in 1) X% y-o-y or m-o-m increase over base data
8a
Promotion of rational use of
drugs and diagnostics
Generic Medicines Prescription
% % of Medicines made available through in-house generic store/Total prescription
X% Reduction in stock outs y-o-y or m-o-m over the base data
8b % of generic prescription X% increase in generic prescriptions y-o-y and m-o-m
8c Availability of Generic Drug Stores in Hospitals
% % stock out in hospitals for generic drugs 1) X% y-o-y growth over base data
KPI Details – Public Health (Indicative)
Page 22
Agenda
Scenarios of Economic Intelligence Unit
Sample Dashboards from Open Data.Gov
Data based Intelligence
Managing Performance and Perceptions
Page 23
Agenda
Scenarios of Economic Intelligence Unit
Sample Dashboards from Open Data.Gov
Data based Intelligence
Managing Performance and Perceptions
Page 24
BI Scenarios of Economic Intelligence Unit
Increasing tax base by identifying unregistered dealers
Identification of duplicate dealer registrations
Reconciliation of ITC claims of dealers
Detecting inconsistencies in Dealer’s Trade Network
Comparison of data with department internal sources
Comparison of data with other external sources
Revenue Forecasting
Creation of models for dealer risk rating and tax gap analysis
Detection of patterns in data through data mining
Detection of incorrect claims and deductions
Detection of computation errors resulting in under-declaration of tax
Dealer Segmentation
1
3
4
5
6
7
8
9
10
11
12
2
Page 25 Presentation title
Analytics Advisory – Outputs Data Analysis - Overview
► Holistic view of dealer performance through score cards & dashboards
► Risk rating assigned to dealer helps prioritize cases for further action
► Enables comparison with the right kind of dealers i.e. similar industry,
sector, nature of business, etc.
► Verification of information provided by dealer to the department with
information available in other systems
► Bird’s eye view and comparison with data received through different
reports available in public domain
Track 3:
External Linkages
Track 1:
Dealer
Categorization
► Correlating information provided by dealer in returns and other systems
► Identifying cases of tax evasion such as under reporting of tax, incorrect
ITC claims
► Aiding selection of cases for audit and assessment
► Validating correctness of refund claims through system
Track 2:
Dealer Activity
Analysis for the CTD being carried out across three main tracks