Transcript Applying Analytics in Departments of Corrections

State of Washington
Information Processing
Management Association
(IPMA)
Forum 2008 – 5/20/08
Session D1
“Demystifying Business
Intelligence”
Peter Randall
[email protected]
George Mackinnon
[email protected]
Copyright © 2006, SAS Institute Inc. All rights reserved.
Note:
The content of this presentation is not an official SAS position on BI but
a generic overview of various BI topics as requested by the IPMA
organizing committee.
The views expressed in this presentation are those of the presenter
and are not an official SAS position on BI or related industry topics.
The presentation adopts a non vendor specific approach.
Copyright © 2006, SAS Institute Inc. All rights reserved.
AGENDA
 Defining BI
 The Information Evolution model
 The “BI Pyramid”
Copyright © 2006, SAS Institute Inc. All rights reserved.
Defining BI….
 Burning Index (BI) - A relative number related to the
contribution fire behavior makes to the amount of effort
needed to contain a fire within a given fuel type.
 Bi - Latin prefix meaning two;
 Bibliographic Instruction: sessions during which librarians
acquaint users with the resources and services available to
them in the Library. Risk and classification assessments,
and much more
 BI - BI is Bravo India. When operators were instructed
to"go BI" , they would bring up the next keyset for a specific
crypto device.
Copyright © 2006, SAS Institute Inc. All rights reserved.
Which organization coined the term “Business
Intelligence”?
• IBM
• SAS
• Gartner
• Cognos
• Microsoft
How long ago was this term first used / documented?
 10 – 20 – 30 – 40 – 50 years?
Copyright © 2006, SAS Institute Inc. All rights reserved.
IBM Journal article by Hans Peter Luhn titled “A Business
Intelligence System” October 1958 ( 50 years ago !!! )
Copyright © 2006, SAS Institute Inc. All rights reserved.
Some BI Definitions
“The process organizations go through to gather,
store and analyze data.”
Business Intelligence is getting the right
information to the right people at the right time
to support improved decision making at all levels.
Every BI software vendor trying to push the
definition that best fits its strategy.
Copyright © 2006, SAS Institute Inc. All rights reserved.
Information Evolution Model
Five Levels of Evolution
Level 5:
Level 4:
Level 3:
Level 2:
Level 1:
Copyright © 2006, SAS Institute Inc. All rights reserved.
Innovate - Proactive capabilities
Optimize - Operational efficiency
Integrate – State wide view
Consolidate - Departmental silos
Operate - Individual focus
Evolution and decision making….
Difficult
Value
Strategic
Tactical
Infrequent
Operational
Periodic
Frequent
Easy
Copyright © 2006, SAS Institute Inc. All rights reserved.
Degree of Difficulty
Evolution of BI
Copyright © 2006, SAS Institute Inc. All rights reserved.
Evolution of BI
Infrequent
Strategic
Periodic
Tactical
Frequent
Operational
Copyright © 2006, SAS Institute Inc. All rights reserved.
BI projects must be aligned and
Business Strategy
linked to overall business objectives.
Performance
Management
Key performance indicators (KPIs) or other metrics
People and
Process
BI Platform
Information
Management
Copyright © 2006, SAS Institute Inc. All rights reserved.
Improve through a BI Competency Center
BI platform needs to have tools that are consistent,
collaborative and connected to overall strategy.
Must also cater for unstructured data,
data integration and data quality
Information Management
Data Quality
Copyright © 2006, SAS Institute Inc. All rights reserved.
Tips on Information Management
 Do not forget data quality
 Focus on the business needs
 Reuse metadata where possible
 Do not forget about unstructured data
 Communicate through the use of diagrams;
everyone loves visuals.
 Document current state, document desired
future state and show the steps to get there
over time.
Copyright © 2006, SAS Institute Inc. All rights reserved.
BI projects must be aligned and
Business Strategy
linked to overall business objectives.
Performance
Management
Key performance indicators (KPIs) or other metrics
People and
Process
BI Platform
Information
Management
Copyright © 2006, SAS Institute Inc. All rights reserved.
Improve through a BI Competency Center
BI platform needs to have tools that are consistent,
collaborative and connected to overall strategy.
Must also cater for unstructured data,
data integration and data quality
Advent of the BI Platform
Executives
Line of Business
Managers
Power
User
Business Analyst /
Modeler
Legal/
Finance
IT / Developers
Common Metadata
Data Warehouse
ERP
Copyright © 2006, SAS Institute Inc. All rights reserved.
Data Marts
CRM
Finance
Customers /
Partners
OLAP Data
HR
External
Systems
Single metadata layer….
Data
Data
Integration
Oracle
ERP
DB2
Warehouses
Data Marts
Data Stores
Extracts
MS Access
3rd Party
METADATA
Copyright © 2006, SAS Institute Inc. All rights reserved.
Business
Intelligence
and
Predictive
Analytics
Output
Importance of a single metadata layer
 Saves staff time searching for datasets
 Saves staff time searching for information about data
 Personnel turnover does not invalidate data
 Saves time by preventing duplication of data collection
efforts within agencies
 Proper metadata enables submission to a clearinghouse
node
 Impact analysis on existing reports and procedures
Copyright © 2006, SAS Institute Inc. All rights reserved.
Single BI platform…
Data
Predictive
ETL & Data Intermed Business
Knowledge
Analytics
Access Storage Intellig.
= Insight
A collection of tools approach…

B
Copyright © 2006, SAS Institute Inc. All rights reserved.


Intelligence Platform
Copyright © 2006, SAS Institute Inc. All rights reserved.
Copyright © 2006, SAS Institute Inc. All rights reserved.
BI projects must be aligned and
Business Strategy
linked to overall business objectives.
Performance
Management
Key performance indicators (KPIs) or other metrics
People and
Process
BI Platform
Information
Management
Copyright © 2006, SAS Institute Inc. All rights reserved.
Improve through a BI Competency Center
BI platform needs to have tools that are consistent,
collaborative and connected to overall strategy.
Must also cater for unstructured data,
data integration and data quality
Administrator
Power
User
Data
Analyst
Ad Hoc
Reporting User
Information
Consumer
Copyright © 2006, SAS Institute Inc. All rights reserved.
Administers Users, Security, and
the BI environment and managed
access to data.
Understands complex data manipulation,
processes, flows and integration.
Understands the complexities of the data,
understands join structures, can manipulate
data.
Builds reports and provides Information.
(does not need or understand the
complexities of the database structure)
General “one click” Users – can
open a Report, Execute a Report
with filters
The Process…
SOFTWARE TOOLS
DATA
OUTPUT
Copyright © 2006, SAS Institute Inc. All rights reserved.
BI Competency Center
What does the BICC do?
 Define requirements to support the organization’s
strategy of structuring and using information
 Create best practices for interpreting and using
information
 Support the execution of a an organization-wide BI
strategy
 Ensure that BI is integrated into relevant business
processes of the organization
 Plan and prioritize BI initiatives
Copyright © 2004,
2006, SAS Institute Inc. All rights reserved.
What is a BI Competency Center?
• a formal organizational structure / team
• sponsored by executive management
• representatives from business & IT
• well defined roles, responsibilities and
processes
• implements the BI strategy
• responsible for BI standards and procedures
Copyright © 2006, SAS Institute Inc. All rights reserved.
BI Competency Center Functions
Enterprise
BI Strategy
Promotion
Of BI within
the enterprise
Governance &
Policies
Copyright © 2006, SAS Institute Inc. All rights reserved.
Alignment with
Strategic Goals
Technology
Requirements
& Standards
Data Quality
Standards
Functions of the BI Competency Center
 BI Program – define and
monitor implementation of
the BI strategy, be
responsible for consistent BI
deployment, standards,
technology assessments,
knowledge management,
best practices, domain
expertise
 Data Stewardship –
metadata management, data
standards, data quality, data
architecture
 Support – dealing with
technical and business –
related user questions
Copyright © 2006, SAS Institute Inc. All rights reserved.
 BI Delivery – front-end development,
reporting, business logic application,
user applications testing and
maintenance
 Data Acquisition – data integration
and data store development, testing
and maintenance
 Predictive Analytics – data mining,
statistical modeling, optimization, text
mining, forecasting
 Training – training business users
and project teams
 Vendor contracts management – user
licenses administration, updates and
project teams
BI projects must be aligned and
Business Strategy
Performance
Management
linked to overall business objectives.
Key performance indicators (KPIs) or other
metrics fed by the BI platform
People and
Process
BI Platform
Information
Management
Copyright © 2006, SAS Institute Inc. All rights reserved.
Improve through a BI Competency Center
BI platform needs to have tools that are consistent,
collaborative and connected to overall strategy.
Must also cater for unstructured data,
data integration and data quality
Performance Management
Application / Business / Operational Performance
Management
 availability of software applications.
 help businesses discover efficient use of resources.
 ways to improve business results, across organizations.
Balanced Scorecards
 primarily a tool to help strategy implementation.
Predictive Performance Management
 predict potential outcomes with a high degree of
confidence.
Copyright © 2006, SAS Institute Inc. All rights reserved.
BI and Performance Management
data store /
Copyright © 2006, SAS Institute Inc. All rights reserved.
/ data mart
Performance Management Do’s and Don'ts
 Do focus on alignment with goals
 Do leverage BI to assess progress
 Do address cultural issues
 Don’t ignore the importance of Executive level
sponsorships
 Don’t leave anyone out
 Don’t rush into measurement
Copyright © 2006, SAS Institute Inc. All rights reserved.
BI projects must be aligned and
Business Strategy
Performance
Management
linked to overall business objectives.
Key performance indicators (KPIs) or other
metrics fed by the BI platform
People and
Process
BI Platform
Information
Management
Copyright © 2006, SAS Institute Inc. All rights reserved.
Improve through a BI Competency Center
BI platform needs to have tools that are consistent,
collaborative and connected to overall strategy.
Must also cater for unstructured data,
data integration and data quality
Volume 1 – Winter 2007
Copyright © 2006, SAS Institute Inc. All rights reserved.
Copyright © 2006, SAS Institute Inc. All rights reserved.
Some final recommendations…
 Work towards a single BI platform
 Plan to use predictive analytics to move you up
the value chain
 Start small, but have a longer term goal
 Implement a virtual BI Competency Center
 Always adopt a project approach
Copyright © 2006, SAS Institute Inc. All rights reserved.
Thanks for your time.
Copyright © 2006, SAS Institute Inc. All rights reserved.