Peer Group Benchmarking

1
PeER GROUP Benchmarking using Business
intelligence

• It is not appropriate for everyone to act, talk,
  think and be the same.
• But it is appropriate to be the best you can be!

2
Peer group Benchmarking
3
Be PresenT
4
The Peer Group

• THE PEER GROUP Who is in and who is out?

Variables depend on entities being grouped and
the purpose of the groupings. Typical
attributes 1. Complexity similar size,
membership, inputs, outputs2. Size3. Mission4.
Market attributes5. Specific features or value
proposition6. Infrastructure 7. Community and
environment (density and resources in the
surrounding community) Weighting could be
applied to assist in peer evaluation
5
Peer Group

• Bell Curve start off at 1 SD from the mean

6
Peer Group Basics
7
Peer Group characteristics

• Non-organizational peers - not from the same
  company or organization.
• No conflict of interest - no customer-supplier
  relationships. Non competing.
• No hidden agenda - a desire to help each other
• No personality conflicts  
• Confidentiality
• Diversity

8
Role of the Facilitator
Facilitators strike the balance between
structure and flexibility working on behalf of
participants to moderate discussions, find
subject matter experts and arrange workshops.
9
Motivation
10
Why Join a Peer Group?
Its not about pushing limits but maximizing
potential!
11
a Slice of a Bigger Pie
12
One part conformity, one part Leadership
13
Incorporate A Management information system
Standard Chart of Accounts Standardized activity
codes and descriptions Meaningful indicators
addressing sore points Operational financial and
statistical data
14
comparisons
A comparison of consolidated business activities
involves the consolidation of results into a
common currency and elimination of intercompany
transactions between related subsidiaries of the
parent (owning or controlling firm). Set the
ground rules for analysis Establish best
practices Some have argued that comparison is
the evil twin to comparison)
15
Looking for Outliers
16
Outliers should provoke a discussion
17
Peer Group Comparisons
Roundtable discussions are established to share
and compare notes on significant trends which are
impacting project management and project delivery.
Open the floor to those wanting to discuss
specific concerns or challenges they are
experiencing including company developments or
other announcements.
18
Best Practices
19
herd mentality and mediocrity or support
20
Some PeeR GROUPS are extraordinary
21
Who else is doing it and how are they doing it?
22
Its about finding the Sweet spot
23
A Pace you can live with
24
Peer Group of one
25
Self Measurement
26
Known Knowns
27
UNKNOWN UNKNOWNS
28
Business Analytics and Reporting

• The purpose is to make sense out of numbers and
  data
• Start with a cleansed data set followed by a
  query of the normalized database, csv files, text
  or spreadsheet data.
• Use analytic tools to assemble, explore and
  analyze the content.
• Expectations
• Spot and analyze trends and anomalies
• Predict potential threats, weaknesses, strengths
  and opportunities
• Plan, budget and forecast to optimize resources
• Assess and manage risk
• Conduct and compare what if scenarios
• Measure and monitor business performance
• Automate decisions if possible
• Align operational decisions to strategic goals
  and objectives

29
Business Intelligence capabilities
Reporting Analysis KPI and scorecards Dashboards
and workspaces combine historical, real time
and forecasts Mobile digital self
service Statistical analysis Group collaboration
improve alignment with stakeholders
- improve business outcomes with better
decisions Planning and budgeting Real time
monitoring and indicators Maintain access to
one version of the truth using diverse
platforms such as cloud, desktop and mobile
30
Analytic themes
Sorting alpha and numeric, first/last, and
numbering, sequencing and filtering. Sorting also
includes pattern matching Grouping by attribute
( data mining), date, consensus (convergence and
divergence) Ranking By size, frequency,
percentage, and relative importance Mathematical
Counting, summing, averaging, statistical
correlation, medians, rate of change and WHAT
IF scenarios Alerts Predicitive analytics
using live data use history to predict future
events. Alerts also use critical performance
indicators, and thresholds, as well as score
cards.
31
Analytic themes Part two
Risk Historical data is used to predict the
probability of future outcomes Comparisons To
budget, to forecast, to history, to peer groups,
non obvious relationship analysis, obvious ratio
analysis (within a consistent context) and
financial consolidations Hygiene Factors In
order for analytics to be useful and pervasive
the following must be present Speed
timeliness is key Truthful The data represents
a single version of the truth, minimizing rehash
of correctness complete, timely and relevant in
a trusted format Available User availability,
24x7, including mobile devices or other common
interfaces and scalable to many users.
32
Analytic themes part three
Visualization Wordles (text analytics),
Graphical and other types of reporting Audience
Data privacy and audit trails Level of the user
within the organization Meta data Data about
the data dictates relevancy and promotes social
media inter relatedness Geospatial Geographic
mapping
33
Grouping
Non obvious relationship analysis is useful for
looking for common attributes such as address and
phone number while other data does not indicate
any relationship. Looking at successive detailed
attributes to discern false positive matches or
false negative matches is an important component
of BIG DATA (characterized by large volume, high
velocity, and variability/variety Divergence and
convergence looks at how data points approach or
move away from a target value. It is just as
important to know if market share is increasing
or not, as what the share is at any point in
time. The rate of change also impart a sense of
urgency and a call to action.
34
A sample Analytics Exercise
Tab Delimited Cleansed Data File
35
BI TooL Interface
Drag and drop to import
36
Opening Screen
37
Dimensions and Measures
38
Automatic Data Filtering
39
Graphics
40
COnclusion
Why get involved with a peer group? Increase
Revenue, decrease costs, improve services, safe
guard organization Learn about other real-world
projects to expand beyond personal
experience Share knowledge to bring people in
high-tech industries up-to-date ( give
back) Learn and facilitate discussions on
subjects of critical importance to you Foster
the development and advancement of technology
Connect with peers and TAP INTO THE POWER OF
THE GROUP