Transforming Governments:
Global Success with Analytics
David Bolton
Global Industry Director – Public Sector & Health
August 2017
2Government
2
• Reducing IT spend
• Increased understanding of data as an asset
• Improving inter & intra-agency data sharing
• Attention on quality measurement and outcomes
• Increased emphasis on efficiency
• Focus on public transparency
2
Current Government Environment
Government
3Government
3
Poor end user
adoption
Need data to drive
decision making
Uncontrolled data silosMultiple data sources:
program, financial,
operational data
No insight into current
operations or conditions
Data is stale, no
longer current
Lengthy
installations
Common Government Analytic Issues
4Government
Data Landscape in an Ideal World
Big Data / Data
Warehouse
Estates
Operations Citizen Data
Finance
System
Supply ChainWorkforce
5Government
Data Reality:
Need data from Multiple Data Sources
Data
WarehouseFinance Workforce EstatesCitizen data
*Sample data sources; not a complete list
Operations Supply
Chain
6Government
Visualization is the last mile…
7Government
7
An Analytics Platform for Everyone
Centrally Deployed
Guided AnalyticsSelf Service Data
Discovery
Data
SourcingCollaboration &
Reporting
Embedded
Analytics
Visualization &
Advanced
Analytics
Answer the ‘what’ and the ‘why’, even
if you’re not technical
Analyze anywhere regardless of
physical location or application you
are using
Embedded analytics into core
business processes
One Platform supporting the full
spectrum of BI and Analytics use cases
8Government
Public Sector Global Clients
9Government
Select Qlik Government Clients
Global
10Government
Select Qlik Government Clients
US Federal
Qlik has enabled the agency to:
• Improve RFI response time from 15 days to
same-day
• Repurpose 6 FTEs from manual reporting to
analysis
• Improve interagency collaboration and ability
to identify and stop narcotics trafficking
“Within 3 months of implementing Qlik, we reduced our RFI response wait time by over 92% and
reallocated 50% of analyst staff from manual data compilation to more value-add projects.”
92%REDUCTION
In response time
Example App: Crime Intelligence
Example App: Predicting Crime with R
Federal 14
“We now have a complete picture of readiness—from
knowing who’s trained and ready to deploy, to
understanding the state of our weapons.”
Challenges
• Needed to improve overall readiness
• Parts/equipment in the right place at the right time
• Clear view of which soldiers were ready for war
Solution
• Workforce Management apps identify who’s trained and ready
• Weapons Division apps explore weapons and warfare analysis
Benefits
• Overall improvement in readiness
• Comptroller replaced 54 spreadsheets with 1 Qlik app for a full
view of readiness
About NAVAIR
• Material support for aircraft & airborne weapon systems
• Lifecycle support of naval aircraft, weapons & systems
• 8 locations across the U.S. and 1 overseas
Weapons Division Director, NAVAIR
Naval Air
Federal 15
“Since implementing Qlik we’ve reduced Naval fuel
consumption drastically, saving $140M.”
Challenges
• Needed to reduce fuel consumption to reduce costs
• Unable to track daily patterns affecting fuel consumption
Solution
• Implemented Qlik to provide insight into consumption:
• Daily summary of all ships’ energy consumption pushed to leaders
• Predictive insight into potential consumption to reduce future usage
Benefits
• Reduced fuel consumption by $140M
• Repurposed savings to energy efficient applications
About MSC
• Controls Navy’s replenishment & military transport ships
• Sealift/ocean transportation for military & civilian agencies
• Consists of 5 distinct programs
MSC Leader
Military Sealift Command
16Government
16
Challenges
• Multiple data sources
• Static inflexible reporting with no drill down capabilities (had to run new
report for further detail)
• Very time consuming. Often 35-40 mins just to run a report to extract
necessary information
• Heavy reliance on excel to manipulate and analyse data
Solution – Qlik View
• Interactive reports with immense drill down capabilities
• Primary statements and notes all within one application (rather than
multiple reports with previous system)
• Extremely positive user experience
• Significant improvement with cross agency engagement
Benefits• Very intuitive and scalable
• Paradigm shift from just ‘reporting’ to now actionable insight
• “liberating to be able to get to our data this easily with Qlik”
• Less time at the water cooler i.e. more productive staff
About The Treasury
• established in April 1824 and is the longest serving Government agency
in Australia
• advises the NSW Government on state financial management policy and
reporting, on economic conditions and issues, and on industrial relations
matters.
• coordinate the State Budget, manage the State’s financial assets,
monitor the performance of the State’s commercial and Government
agencies
David Tonkin, Principal Financial Analyst
“Other systems allow you to see the A and the B
in your data but with Qlik you get to see the C, D,
E and wherever else you want to go in your
explorations”.
The Treasury, NSW
Example App: Government Spend Analytics
Example Apps: Public Transparency Portals
Federal 19
“Qlik’s solution enables us to coordinate our efforts in a
completely new way. We can see how many people are
on the way in and guide personnel to where they are
needed the most. By allocating resources more efficiently,
we are saving time and money. Quite simply, we can work
smarter and faster.”
Challenges
• Compiling information from different data sources
• Enabling users to work from the same key data
• Streamlining work efforts across the authority
Solution
• Deployed Qlik to manage the complete case lifecycle
• Visualized the flow, from asylum processes to permit processes and
quota refugees
• Made information accessible to all authority administrators
Benefits
• Shorter wait times for asylum seekers
• Better coordination and faster case management
• Ability to predict resources and target efforts based on need
About the Swedish Migration Board
• Processes applications for visitors, and those seeking to take
up residence, obtain citizenship or seek asylum
• Responsible for handling reception of refugees
Andres Delgado, Head of Statistical Process Control at the
Migration Board
Swedish Migration Board
Federal
Federal
Federal
Government
Qlik has enabled the
department to:
• Identify incidents and quickly respond
to child welfare needs
• Increase transparency and
accountability
• Ensure data integrity through governed
data
“What previously took weeks and months can now be achieved in hours or days with Qlik
meaning information is provided to our case workers to better manage our children at risk.”
IMPROVEMENTin level of care for
children in need.
EXPONENTIAL
24
“It’s given us a single source of truth which has cut down
the time significantly, and improved collaboration across
the system.”
Challenges• Multiple data sources in use; electronic medical record systems, financial
tools, operational databases, etc.
• Lack of Self-Service tools to enable analytics adoption / actionable insight.
• Data governance, data accuracy, data timeliness.
• Disengagement of clinicians who were often skeptical of learning ‘just
another management tool’.
Solution – Enterprise Agreement
• QlikView and QlikSense deployments in 13 of the 17 Local Health Districts as
well as several Qlik environments in NSW Health / Pillar organisations.
• Applications developed covering range of clinical, operational and financial
requirements.
• Provides clinicians and managers with timely, accessible and clinically
meaningful information to compare their performance against internal data
within their own hospital, with peer facilities or on a statewide basis. .
Outcomes
• Deployed to 23,000 users (and growing) since October 2014.
• A reduction in reporting time of more than 75% compared to previous
systems.
• Significantly increased clinician and management engagement in activity
based funding management.
• Improved outcomes across multiple specialties, reduced unwarranted
variation and a system cost reduction of HALF A BILLION DOLLARS.
About NSW Health• Operates more than 230 public hospitals, as well as providing community
health and other public health services
• It is the biggest public health system in Australia with more than 108,000
dedicated staff (FTE) who make up the health workforce
• Annual budget of $21 billion to service a population of over 7.5 million
residents
Alfa D’Amato – Deputy Director, Activity Based Funding Taskforce
NSW Health
“The objective is to bring decision-making in health care
as close as possible to the patient. Now, activity-based
funding and activity-based management have been key
tools in enabling that devolution to be real, because it
makes the system transparent.
Dr Mary Foley, Secretary, NSW Health
25
Challenges
• Business users required to have high technical skills for data import
• Significant hardware overhead
• Slow data import, lack of scalability and a lack of an ability to have a single
data set for all their providers with appropriate security protection
Solution – Qlik Sense• Has enabled more effective communication with employment providers and
other stakeholder agencies on the performance of employment contracts and
related business activities
• Secure / Governed self-service capabilities has enabled employment providers
to monitor their business and be self-sufficient
• Improved scalability to address increasingly large data volumes
Benefits• Lower administration and deployment costs for the Department
• Improved speed to market for the development of reports
• Improved agility in data delivery and reporting
• Ease of access to information has seen a significant reduction in staff
administration time
About the Australian Government Department of
Employment
Department of Employment, Australia
• It is responsible for national policies and programmes that help Australians
find and keep employment and work in safe, fair and productive workplaces.
• The Department is going to use Qlik Sense, in the first instance, for its
JobActive program.
• The Department’s JobActive program is the Australian Government’s way to
get more Australians into work. It connects job seekers with employers and is
delivered by a network of JobActive providers in 1800 locations across the
country.
“It’s great to see the Department moving into the data
analytics age in such a big way with Qlik.”
Renée Leon PSM, Secretary
26
ROI with Qlik® — Public sector (safety)• £256,250 savings in labor time
• £80,000 savings in training costs
• £925,000 savings in technology costs
• 97% accuracy rate in national crime statutory data
submissions using QlikView® vs. a national average of 67%
• 43 man years’ worth of data analysis done in QlikView
• 9 months of work before QlikView now done in 1 minute
• 3 hours to load and analyze 2b rows of crime detail; resulted in
tracking down an alleged serial killer
• £350,000 savings related to crime mapping
• 20 data sources analyzed 24/7 for emergency services
• “These four apps alone freed up 4,893 hours per year of no-value
data compilation, with the associated payroll cost of $215,000.
This was like getting 2.35 full-time employees for free.”
• “The number of open National Fire Incident Reports has been
reduced by 600 reports — a 90 percent decrease in six months.”
27
ROI with Qlik® — Public sector (government)
• €42m in procurement cost savings over 2 years
• 231 hours/month reduced to 54 hours for BI work (compared to Oracle reporting)
• Oracle HR in every NHS Trust, Oracle ESR most common finance platform
• The Danish Justice Ministry have increased their case handling
efficiency by 9% — equivalent to 60 full-time employees
• £3m savings in first year with QlikView
• £24m forecast over 5 years using QlikView
• ½ day reduced to ½ hour for typical in-depth analysis
• £150,000 savings per year for budget reports
• 2 day improvement in monthly reporting process
Innovation & Direction
29
30
31