Transcript BI for Government - Unleashing IT Democracy

BI for e-Governance
Unleashing IT Democracy
Rohan Kumar
Business Manager – Oracle BI
Oracle in Government Solutions
Did You Know?
25 of the top 25 governments get better results with Oracle
15 out of 15 US Federal Cabinet agencies get better results
with Oracle
10 out of 15 Major UK Government Departments get better
results with Oracle
50 out of the largest 75 UK Local Authorities get better results
with Oracle
24 of the top 25 US Cities and 15 of the top 15 US counties get
better results with Oracle
Process:
Support
& Training
Consulting
Applications
Middleware
Database
Operating
System & VM
Servers
& Storage
Top to Bottom Support for Government
Leading Enterprise Software Vendor
• #1 in CRM, HCM, EPM, Middleware, and more
• Most scalable, reliable, secure infrastructure
• Most complete range of on-demand and
on-premise deployment options
Built-In Government Solution Capabilities
• Government sourcing, procurement contracts
• Constituent service via multi-channel contact center and case
management
• Enterprise tax management including consolidated view
of tax payer
• Financial management, human capital management
Largest Software Assistance Team
• 64,500 development, support, and services professionals
• 145 countries
Oracle
Oracle’s Government Footprint
ISV Partners
Constituent Channels
Self-Service Portals
Constituent Outreach
Contact Center
Field Service
Government Offices
Overlay Infrastructure
forChannels
Shared Services
Customer
& Distribution
Analytics &
Business Intelligence
Service Provider
Management
Master Data
Management
Case Management
Payments & Collections
eCommerce Engine
Government Segments
Public Education*
Environment Protection
& Resource Management
Defense* &
Intelligence
Justice & Public Safety*
Public Administration
Healthcare* &
Social Services*
Tax/Collections &
Revenue Management*
Foreign Relations
Public Infrastructure
Economic Development
Administration & Enterprise Management
iLearning & Classroom
Training
Financials / Cash Mgmt
Procurement, Contract, and
Supply Chain Management
Facilities Management & Field
Services Automotive
Human Resources and
Workforce Management
Projects, Program
Management & GRC
Records Management
Helpdesk
Mobility
Hubs / Data Warehousing
Integration Framework / SOA
Development Tools
Identity & Security Services
Networking
Database & Security Ext.
Operating System
Virtual Machine
Server
Storage
Systems & Data Center Mgmt
HR
IT
Infrastructure
* Separate Industry Footprints Provided
Management Excellence :
The Next Competitive Edge
Competitive
Advantage
Smart
– Deep Insight
Agile
– Decisive Action
Aligned – Across the
Extended Enterprise
MANAGEMENT EXCELLENCE
Cost – Lean and Mean
Quality – Six Sigma, TQM
Speed – Real-time, JIT
OPERATIONAL EXCELLENCE
Time
5
Government IT – Market Direction 2010
“Funding cuts will dictate the public
service agenda..........”
“……..There will be an increased
attention on how money is being
spent at all levels of government”
2010 Top Ten Predictions for
Europe, Middle East & Africa
“The word for 2010 will be rightsizing, underpinned by
government transformation or modernization. Establishing
priorities to guide rightsizing efforts will rise to the top of
• In INDIA - Recession Proof
the administrative policy agenda”
• NeGP, JnNURM, APDRP, SDC,
• Increase
in Governmental
Spend
“.............Governments will be required
to change
the way
they manage themselves and public money”
Public Sector Business Drivers
Tough days are coming
A year ago...
“do MORE with LESS”
Now:
“do BETTER with LESS...
and LESS and LESS...”
Public Sector Business Drivers
Tough days are coming
Keep the public debt under control
Support the economy
Support the citizen / stakeholders
Gain Public Trust
Daniel K. Moran said
“You can have data without
information, but you
cannot have information
without data”
Getting Started with BI
• BI – a term borrowed from control panel in
airplanes
• Government is in the ‘Business of Citizen
Support”
• Measurable – profit & loss / Social welfare
• Fundamental objective is superior delivery of
results from Govt. initiative
• Exemplary r’ship between Govt. and citizen
Usage of BI – Govt. v/s Private
Who – What – Why – How
Official
Operational Reports
Policy Makers
Capital Assets
Citizen
Management Function
Inter Department
WHO
C
WHAT
WHY
HOW
Customer Support
Efficiency
Dashboard / Drill Down
Predictive Analytics
Share on Portal / Publish
Archival / Compliance
Statistical Analysis
Customer Satisfaction
Alerts / Mobility
Usage of BI – In Government
Increasing Accountability
• How can I improve tracking
and reporting of public funds?
Fiscal Management
• How can we maximize revenue
collections without increasing taxes?
• What is the best way to enforce
• What work processes can
proper approval and document key
decisions / awards?
be automated to reduce costs?
Suppliers
Citizen Centricity
• What is the best way to improve
responsiveness to citizen demands?
• How should cases be distributed to
improve workload and consistency of
outcomes?
Civilian
Services
Constituents
Data Security and Access
• How can I automate collaboration
and still protect sensitive data?
• What is the best way to provide
controlled, remote access to centrally
managed information?
Challenges for Government by Segment
Social Welfare
–
Shrinking resources require a tight cost management in order to guarantee an efficient delivery
of services
–
When delivering benefits, being able to identify potential fraud is a key point to efficiently
consume resources
–
Social Welfare organisations need to understand what are the right services to invest on
–
Social Welfare organisations need to know at any moment what they have already spent, what
is committed and what still is available.
Public Safety
–
Guarantee that the available resources are adequate to fight crime successfully, and that those
resources are used efficiently
–
It is crucial to understand the trends of crime in order to be able to effectively forecast resource
requirements and allocate resources where they are needed, when they are needed
–
Support to investigations
Challenges for Government by Segment
Defence
–
Defence capability and defence readiness measurement
–
Measurement of contingent risk is critical
–
Internal service level measurement between Army, Navy, Air Force, Support organisations and
industry partners
–
Increasing importance of internal and external contract monitoring and performance
measurement and management
–
Many countries are increasingly turning to membership of alliances and coalitions such as
NATO, EU and the African Union, and are looking to collaborative equipment programs.
Membership requires strict management of funds.
Government Fiscal Management
–
Expected revenue need to be assessed with great accuracy. It requires to take into account
factors such as price trends, estimation of GDP and debt rate.
–
The tax gap estimation and tax gap reduction is the main challenge in order to avoid to raise
taxes. Being able to identify tax evasion is key.
Challenges for Government by Segment
Education
–
Outcomes, performance measurement, financial results, predictive analytics and capacity
planning are the hot topics being discussed in education today
–
The economic challenges and changing demographics are driving the need for more
accurate analysis and planning. The key is agility and turnaround time.
Local Government
–
Different standards in each Department, Local Authorities. Need for integrated performance
measurement and management.
–
Many services are under severe financial pressure (e.g. waste disposal, road repairs)
–
Requirements for fairness, accountability, transparency, efficiency and effectiveness of Local
Authority funding
–
Pressure on local taxes incomes and public safety.
e-Health is all over the place!
National and regional initiatives
Sweden: Developing a
National Patient Summary
Denmark: New National ITstrategy to standardize EHR´s
Canada – Infoway set up to
design and procure National
EHR - $2 billion of government
backing for regional EHR
projects
Finland: National eHealhtArchives to be established
Ireland:
Procurement
contracting has
started to drive
national EHR
effort
England: EHR
initiative in process,
PACS project is
running in north
region
USA – Federal ONC NHIN
contract underway. Multiple
State initiatives for RHIOS. Still
emergent – national EHR by
2014 – Obama Stimulus Plan
Opportunity
Status
Current
Work
Planning
Chile: National RFP
for EHR project is
expected soon
Considering EHR
Data N/A or No
EHR Presence
* Target opportunities identified by text in red
Source: Accenture + Oracle
Russia: 15 Diagnostic Centers
project in progress. Plans being
developed for national HER for 145
million people.
China: Plans to develop
a national EHR
Germany: One regional deal
underway. Future EHR
efforts are expected to be
regional
Hong Kong: Territory
wide Patient Master
Index
Spain: Regional
initiatives are being
considered
Mexico: No EHR
but aim for HL7
Integration –
National Disease
Surveillance going
on
Monitor
Netherlands:
National Switch Hub
France: EHR mandated by
2007. National RFP has
been issued
Italy: EHR regional
initiatives have begun
Brazil: National
Health Card Project.
Argentina: 1st
adoption of a digital
radiography solution2004
SEE: Bulgaria, Romania,
Turkey and Serbia all
developing national
eHealth strategies.
Malaysia: Lifetime
Health Record (LRH)
by 2010
South Africa: No EHR –
but infrastructure being
developed
Singapore: EMR
system tender
expected Q1 2005
Australia: HealthConnect
is developing a National
Information Network
New Zealand: National EHR
system in place (complete)
BI in Healthcare – Industry Trends
Healthcare information needs are complex, but need single source of data
HIS - Hospital
Information System
Payer
Employer
Regulator
Payer
Government
Regulatory
Agency
Patient/Consumer
Life Sciences
Provider
Retailer/
Distributor/
Wholesaler
Biotech
Medical Eqpt
Pharmaceutical
Hospital/
AMC/IDN
Outpatient
Care on
Reporting
Soln
Clinical Application
Tertiary Care
Typical Healthcare Information
Spanning Operational & Management Excellence
BI in State Governance – New York City
•
Launched on New York City’s website February
2008.
•
Includes reporting data from more than 40 City
agencies and organizations.
•
Covers reporting periods from July 2002 (Fiscal
2003) to the present.
•
Data is updated monthly, quarterly, or annually
depending on the specific measurement.
•
There are more than 500 performance
measures reported in the CPR tool.
City-wide approach - Themes
Management Excellence in Local Govt
http://www.nyc.gov/html/ops/cpr/html/cpr_home/cpr_home.shtml
Sustainability Reporting – NY State
http://www.nyc.gov/html/ops/planyc/html/home/home.shtml
NYC Stat - Stimulus Tracker
http://www.nyc.gov/html/ops/nycstim/html/summary/summary.shtml
The Unique Challenges: BI in Government
• Mapping Mission to Metric
• User Adoption
• Intra departmental usage – cut duplicate IT
spend
• Political Influence – flavor of the season &
long term approach
Must Have BI Functionality
• Dash boarding for City Administrators
– Slice & Dice
– Drag & Drop (Interactive indicators)
• Guided Analytics, Alerts and Ad hoc reporting
• Online publishing
– Sharing information with the community
– Reporting in MS Excel / PDF / PPT / Website
your findings aren’t effective till the time it is shared with
colleagues/public
Must Have BI Functionality
• Fast, easy installation
– self service by business and not IT
• Predictive Analytics
– prevention is better than cure
• Trial, training & support
• Allow citizens to analyze and collaborate in
governance
Must Have BI Functionality
From Warehouse to Workspace
Data Warehouse
BI Foundation
(BI Server)
Workspace
PRESENTATION LAYER
•Single Database
•
•
•
•Multiple schemas,
logical separation
User Roles, Preferences
Simplified View
Logical SQL Interface
•Interactive Dashboards
•Ad Hoc Analysis
SEMANTIC OBJECT LAYER
•Staging Data Layer
(SDL)
•Reporting & Publishing
Security
PHYSICAL LAYER
Manage
•Access and
Performance Layer
(APL)
Dimensions
Hierarchies
Measures
Calculations
Aggregation Rules
Time Series
•
•
•
Map Physical Data
Connections
Schema
•Disconnected & Mobile
Analytics
•Proactive Detection & Alerts
•MS Office Integration
Consume
•
•
•
•
•
•
•Foundation Data
Layer (FDL)
Acquire
Data Sources
Aligning to Strategy
How the Scorecard System Works
Fix
Send e-mail alert when a
problem is detected
Business Intelligence
Analyze
E-MAIL ALERT
STRATEGY ANALYSIS
Interdepartmental Collaboration
Automate Manual Processes and Share Information
Service
Agents
Other
Agencies
• Intelligently route workflow
requests / approvals, assign
activities, and track audit trail
• Conveniently and securely
access case details and affected
party relationships
Knowledge Base
Escalate
Transaction Info
Case details
Citizen Info
• Efficiently manage case work,
associated documents, and
knowledge base
• Make informed decisions based
on an accurate, single source of
data
Interdepartmental BI
Service &
Contact Center
Marketing
Procurement &
Spend
Service
Effectiveness
Campaign
Effectiveness
Direct / Indirect
Spend
Revenue and
Backlog
General
Ledger
Employee
Productivity
Citizen
Satisfaction
Citizen
Insight
Buyer Productivity
Inventory
Accounts
Receivable
Compensation
Resolution
Rates
Product
Propensity
Fulfillment
Status
Accounts
Payable
Compliance
Reporting
Service Rep
Efficiency
Loyalty &
Attrition
Customer
Status
Cash Flow
Workforce
Profile
Service Cost
Market Basket
Analysis
Order
Cycle Time
Profitability
Retention
Analysis
Churn & Service
Trends
Campaign
ROI
BOM
Analysis
Expense
Management
Return on
Human Capital
Off Contract
Purchases
Employee
Expenses
Purchase
Cycle Time
Supplier
Performance
Fulfillment
Management
Financials
Human
Resources
Government of Uttaranchal - India
Consolidates Data
OVERVIEW
• Uttaranchal is the 27th state of India with a population
of 21 million
CHALLENGES / OPPORTUNITIES
• Difficulty identifying and targeting the “right” citizens
for social benefits. The Public Distribution System (PDS)
provides food rations to citizens but does not have
systems or data to enforce rules:
– Death certificates and death dates not shared with
PDS resulting in distribution of food inappropriately.
– Housing Bureau information not shared with PDS and
so families with greater than 4 acres of agricultural
land are participating in this benefit.
– Pensions are being distributed to citizens who should
not qualify
– Electoral Department cannot verify date-of-birth for
election registration
SOLUTIONS
• Oracle Customer Data Hub (CDH)
CUSTOMER PERSPECTIVE
The World Bank have funded a project named,
Central Data Vault. Citizen data is being collected
from multiple departments to be used for a variety
of purposes. In addition a multi-purpose household
survey is being carried out in 70 urban areas with
the information gathered from these activities
forming a single citizen repository.
EXPECTED RESULTS
• Only qualified citizens will receive social benefits
resulting in a significant decrease in current aid
• More accurate payments can be made to qualified
senior citizens resulting in significant savings
• Age limit enforcement for voter registration
• Sharing of key citizen information to all
government departments resulting in more
focused service and savings