making sense of data and analytics for private clubs€¦ · lego overtook mattel and hasbro to...
TRANSCRIPT
![Page 1: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/1.jpg)
Business Intelligence
CMAA 2018 WORLD CONFERENCE // SAN FRANCISCO// MARCH 4, 2018
Making Sense of Data and Analytics for Private Clubs
![Page 2: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/2.jpg)
2
Presenters
Rob Hill / PARTNERManages GGA EMEA office in Dublin.
Directs GGA’s Institute for Best Practice.Previously: Whitbread Plc, Marriott Hotels.
Derek Johnston / PARTNERManages GGA satellite office in San Fran.
Directs GGA’s Business Intelligence.Previously: Arthur Anderson, Deloitte.
![Page 3: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/3.jpg)
3
01 / GGA INTRODUCTIONOrigins. Reach. Client support. Expertise. Approach.
02 / SESSION INTRODUCTIONOverview. Learning Objectives.
03 / THE IMPACT OF GOOD INTELLIGENCEThe Lego Story.
Presentation Map
![Page 4: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/4.jpg)
4
04 / DEFINING BUSINESS INTELLIGENCEWhy is BI Important. What are we actually talking about.
05 / CURRENT LANDSCAPEThe state of Business Intelligence in Private Clubs.
06 / GETTING STARTEDA Framework
Presentation Map
![Page 5: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/5.jpg)
5
07 / INTELLIGENCE GATHERING What to Source and Track. Market. Membership. Operations.
08 / CONVERTING DATA TO INTELLIGENCEPutting your data to work
09 / TAKEAWAYSTakeaways. Insights. Applications. Questions.
Presentation Map
![Page 6: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/6.jpg)
6
Resource Libraryglobalgolfadvisors.com/wc18
Twitter@GlobalGolfAdvis
globalgolfadvisors.com/wc18
Conversations & Resources
![Page 7: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/7.jpg)
GGA INTRODUCTION
![Page 8: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/8.jpg)
8
“Effective leadership is putting first things first.Effective management is discipline, carrying it out.”
GGA is a highly specialised consulting firm focused on golf, private club, real estate, and resort businesses.
// Stephen CoveyAuthor, educator, businessman, speaker
About
![Page 9: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/9.jpg)
9
Conduct strategic planning for clubs of all shapes/sizes around the world
Established in 1992 as KPMG Golf Industry Practice
Origins
![Page 10: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/10.jpg)
10
Leading golf industry insight from 4 global offices
Serving 2,900+ clients worldwide
Reach
![Page 11: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/11.jpg)
11
WE DO STRATEGYWE DO INSIGHT WE DO SUCCESS
GGA researches and shares best practices amongst theworld’s top performing golf clubs with a view to improvingperformance in an array of management disciplines.
Client Support
![Page 12: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/12.jpg)
12
05
0403
02
01 STRATEGIC BUSINESS PLANNING
GATHER DETAILED INFORMATION
UNDERSTAND CURRENT CIRCUMSTANCES
OBTAIN MEMBER/CONSUMER FEEDBACK
RECOMMENDATIONS
DEVELOP PLAN
Approach
![Page 13: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/13.jpg)
SESSION INTRODUCTION
![Page 14: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/14.jpg)
14
Global data generation has skyrocketed in the last 15 years:
Up to 2003 – five exabytes
Today – five exabytes are collected every two days
Session Introduction
![Page 15: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/15.jpg)
15
Learning Objectives:
Define and classify the most important Business Intelligence for their club to track and analyze.
Implement appropriate tracking procedures to efficiently and effectively capture the data needed to analyze key business intelligence.
Analyze the most important categories of business intelligence to identify and capture key facts and trends impacting their club.
Present vital data and analytics in a meaningful way to each key stakeholder audience at their club.
Utilize data and analytics to support and inform fact based decision making amongst their management team and their board.
Session Introduction
![Page 16: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/16.jpg)
THE IMPACT OF GOOD INTELLIGENCE
![Page 17: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/17.jpg)
17
If every LEGO brick was
stacked, they would form 10
separate towers from the earth to
the moon.
The Case of Lego
![Page 18: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/18.jpg)
18
In 1990, LEGO was one of the top 10 toy companies in the world. Sales had doubled every 5 years since 1975.
Lego reacted to its declining sales with Lego theme parks, books, jewelry sets. The brand became diluted, their core audience less interested.
In 2004, Lego faced bankruptcy with losses of 2.5billion KK.
The Case of Lego
![Page 19: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/19.jpg)
19
Turnover
EBITDA
The Case of Lego
![Page 20: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/20.jpg)
20
2003, New CEO Jørgen Vig Knudstorp ordered a strategic review of the entire business.
• Market Analysis
• Customer Analysis
• Operations Audit
• Branding & Communications Review
• Financial Analysis
The Case of Lego
![Page 21: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/21.jpg)
21
A new strategy was defined
working on a new vision,
listening better to and
understanding their customer,
empowering their employees and introducing
tight fiscal control.
The Case of Lego
![Page 22: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/22.jpg)
22
Turnover
EBITDA
The Case of Lego
![Page 23: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/23.jpg)
23
23
Turnover
EBITDA
The Case of Lego
![Page 24: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/24.jpg)
24
24
Turnover
EBITDA
The Case of Lego
![Page 25: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/25.jpg)
25
Ten years on from initiating strategic planning process…
LEGO TurnovermDKK 35,780
(+397%)
LEGO EBITDA mDKK 12,148 (from -1,498)
Lego overtook Mattel and Hasbro to become the biggest and most profitable toy
company in the world
Turnover
EBITDA
The Case of Lego
![Page 26: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/26.jpg)
26
Inspiration
GGA believe that informed and intelligent planning increases likelihood of success.
Strategy relies upon intelligence.
![Page 27: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/27.jpg)
DEFINING BUSINESS INTELLIGENCE
![Page 28: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/28.jpg)
28
Business Intelligence relies on the use of data to derive insights. An effective data strategy relies on understanding what you are trying to accomplish.
BUSINESS INTELLIGENCEOften Misunderstood | Definition is categorically imprecise.
Defining Business Intelligence
![Page 29: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/29.jpg)
29
Defining Business Intelligence
What is the primary type of BUSINESS INTELLIGENCE used at your club?
Financial and operating data is typically top of mind
93%93% of club managers reference financial and operating data as their primary type of business intelligence used at their club.
![Page 30: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/30.jpg)
30
Defining Business Intelligence
We encourage you to think
BIGGER!
![Page 31: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/31.jpg)
31
Defining Business Intelligence
Barriers for Clubs
TIMETime from senior executive team is required to set plan.
CULTUREData driven decision
making in clubs is not ingrained.
RESOURCESKnowledgeable resources are
required to execute plan.
COSTTime, resources and
technology all come with a cost.
Resist the Urge to ‘Throw-in the Towel’!
DATA TYPESInternal and external data
combined for unique insight.
DATA SOURCESData from multiple sources is
synthesized for analysis.
APPLICATIONExperience and
assumption is applied..
ENABLEDData acquisition and analysis is
enabled by technology..
Common Characteristics of BI in Corporate World
![Page 32: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/32.jpg)
32
Defining Business Intelligence
Key Business Driver:
MEMBERS
History
IMAGE
What we Know
- Who they are - Where they live - What they do for a
living - What their
preferences are- When they use the
club
Future
IMAGE
What we Wish we Knew
- Who they will be - Where they will
live - What will their
preferences be- What will they
spend- When will they use
the club
![Page 33: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/33.jpg)
33
Defining Business Intelligence
Business Intelligence and Analytics
A CONTINUUM
Descriptive Diagnostic Predictive Prescriptive
Business Intelligence Analytics
History Future
What happened? Why? What could happen? What do we do?
![Page 34: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/34.jpg)
CURRENT LANDSCAPE
![Page 35: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/35.jpg)
35
Current Landscape
Descriptive Diagnostic Predictive Prescriptive
Business Intelligence Analytics
History Future
Business Intelligence is a relatively immature practice in clubs
CLUBS
Don’t let the concept of a continuum fool you, even the first few categories can be challenging to execute efficiently and effectively.
![Page 36: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/36.jpg)
36
Current Landscape
Current Sources of Data
Clubs predominantly rely on the following historic data for their BI Initiatives:
01MEMBERSHIP
02 OPERATING
03FINANCIAL DATA
59%
CLUB MANAGERSIndicate that they do not have an efficient
and effective method for regularly distilling financial and operating
performance reports to the various stakeholders at their club.
![Page 37: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/37.jpg)
37
Current Landscape
• Progressing at a rapid pace.
• New features and functionality to source and store new data.
• Dashboard builders.
• Drag and drop functionality.
• Access to all types of data contained in management system.
• Helping push clubs along the spectrum towards deeper analytics.
Technological Advancement in Clubs
![Page 38: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/38.jpg)
38
Current Landscape
Further Sources of Data
Use of market and competitive/comparable data is picking up speed:
CLUB MANAGERSIndicate that accurate competitive market data and useful comparable club data are
at the top of their business intelligence wish list.
73%
02COMPARABLE CLUB DATA
01COMPETITVE MARKET DATA
![Page 39: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/39.jpg)
39
Current Landscape
The good news: This is changing and poised to change rapidly over the coming years.
Who currently uses a BI solution to combine data sets from multiple operating
systems to generate KPIs?
CLUB MANAGERSUse a BI solution at their club to combine data sets from multiple
operating systems to generate key performance metrics.
Even fewer use a data warehouse for business intelligence purposes that is separate and distinct from their club management system
database.
7%
0%
20%
40%
Current 3 Years 5 Years
GGA Projected BI Solution Usage
![Page 40: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/40.jpg)
GETTING STARTED
![Page 41: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/41.jpg)
41
Getting Started
What should your BI objectives be?
01 / INFORM KEY DECISION MAKERS Accurate. Timely. Actionable. Intelligence.
02 / IMPROVE PRODUCTIVITYEffectiveness. Board Meetings. Management Meetings.
03 / EFFICIENTLY ALIGN STRATEGYEvaluate. Develop. Adjust.
![Page 42: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/42.jpg)
42
Getting Started
04Put your mind to it and
leverage third party support to track information
03Let these questions form the basis of your BI requirements
02Develop a list of key questions
which you need answers to
01Start with your club’s strategic plan and overarching goals.
BI REQUIREMENTS
STRATEGIC PLAN
SOURCE INFORMATION
DEVELOP QUESTIONS?
Lead With Strategy
![Page 43: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/43.jpg)
43
Getting Started
Members
Board/Ownership
GM/COO/CEO
Management Team
Employees
Local and Regional Residents
Travelers
Competitor Clubs
Associations
Government
Regulatory Bodies
Businesses
Social Media
EXTERNALINTERNAL
Key Audiences:
![Page 44: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/44.jpg)
44
Getting Started
Most Important BI Categories
GOVERNANCE
MEMBERSHIP
MARKET
UTILIZATION
OPERATIONS
CAPITAL
FINANCE
![Page 45: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/45.jpg)
INTELLIGENCE GATHERING
![Page 46: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/46.jpg)
46
Intelligence Gathering
External Data Sources
Population Data Web TrafficReal Estate Data Social Media Data News Outlets
General Ledger
Transaction
Register
Membership
Database
Customer
Relationship
Internal Data Sources
Reservation System
Survey Responses
![Page 47: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/47.jpg)
47
Intelligence Gathering
Be Mindful of Security and Data Storage.
Data breaches are a serious threat to your club.
Make security a critical element of any technological endeavor.
Data Storage
![Page 48: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/48.jpg)
48
Intelligence Gathering
If you can’t find it, you can’t mine it!
Data structure is critical
Poor structure makes finding helpful Business Intelligence year-over-year a
challenging and confusing task
![Page 49: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/49.jpg)
49
Track and monitor, consistency is crucial.
Key Intelligence Components
GOVERNANCE
IMAGE
Performance and trust in board• Self-assessment• Member feedback
Compliance with rules and regulations• Instances of member disciplinary action• Member payment delinquencies and
suspensions
Compliance with laws and regulations• Instances of non-compliance (workplace
safety, annual audit results, etc.)• Emerging issues and trends that may impact
your club
![Page 50: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/50.jpg)
50
Key Intelligence Components
MEMBERSHIPThe MOST Important Business Intelligence Category.
IMAGE
Satisfaction• Overall satisfaction and NPS• Member referral rate
Sales and Resignations• Leads and conversion rates• Net changes in memberships
Demographics• Total population of memberships• Average age and tenure
Impact• Net financial impact• Spending trends
3%
-4%
0%
-4%
1%
2%
-4.0% -3.0% -2.0% -1.0% 0.0% 1.0% 2.0% 3.0% 4.0%
2013
2014
2015
2016
2017
2018B
% Change in Total Memberships from Year to Year
Fisca
l Yea
r
Net Annual Change in Total Memberships
![Page 51: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/51.jpg)
51
Key Intelligence Components
MARKETUnderstand Historic Patterns to Forecast the Future.
IMAGE
General Demographics and Psychographics• Traits, preferences and trends• Source-of-origin• Projected changes • Past, present and future market to
membership overlay
Competition• Supply of clubs and market position• Key competitor strategy and brand• Membership categories, rules and regulations• Pricing and packaging• Marketing and communications
Mapping Competitors within 15 and 30 min.
![Page 52: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/52.jpg)
52
Key Intelligence Components
UTILIZATIONImportant measures of your club’s relevance to it’s members.
IMAGE
Utilization• Operating use statistics • Measurement of utilization versus capacity• Average spend per use measurements
Participation• Events and tournaments• Reservations and cancellations/no shows• Average spend per event and tournament• Net change in number of events
![Page 53: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/53.jpg)
53
Key Intelligence Components
OPERATIONSTrack dollar amounts, average growth rates and trends.
IMAGE
Profit and Loss• Revenue by department• Gross profit and gross margin• EBITDA and EBITDA Margin
Operational Feedback • Member AND Employee satisfaction,
engagement and experience• Ratings versus expectations
Amenity Access• Operating hours and offerings• Ratings versus expectations• Measurement of unfulfilled requests
![Page 54: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/54.jpg)
54
Key Intelligence Components
CAPITALEvaluate elements on an aggregate basis and per member.
IMAGE
Sources• Joining fees• Capital dues• Capital assessments• Annual funds available for capital
Uses• Repairs and replacements of existing assets• New capital improvements
Reserves• Capital reserve studies• Actual capital expenditures vs. reserve study• Capital expenditures as a % of Revenue• Capital expenditures vs. depreciation
![Page 55: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/55.jpg)
55
Key Intelligence Components
FINANCEFocus on options and outcomes.
IMAGE
Financing Options• Sources• Availability• Impact
Liquidity• Current ratio• Working capital• Quick ratio• Interest coverage ratio
Leverage• Debt to equity• Total debt per membership
![Page 56: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/56.jpg)
CONVERTING DATA TO INTELLIGENCE
![Page 57: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/57.jpg)
57
Converting Data to Intelligence
• Online, secure business intelligence portal.
• User profiles to enable ALL key stakeholders at the club to access business intelligence from the same source.
• Filter data based on rolls.
• Prevent version control issues and document
storage issues.
Centralize It!
![Page 58: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/58.jpg)
58
Converting Data to Intelligence
• Plan and schedule regular, recurring, formal meetings with each key stakeholder group.
• Monthly, Quarterly, Semi-Annually and Annually.
• Like anything else, if it’s on the calendar, there is a higher likelihood of execution.
Schedule It!
![Page 59: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/59.jpg)
59
Converting Data to Intelligence
• Reference Your Intelligence During Every Strategic Discussion.
• Monitor Performance Against Targets, Trends and Peers Over Time.
• Review and discuss relevant BI and identify key takeaways and next steps.
Reference It!
![Page 60: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/60.jpg)
60
Converting Data to Intelligence
• Build, maintain, update and utilize a dynamic, forward looking model.
• Consider all key forces impacting success, both internal and external.
• Use these variables to define KPIs that go beyond dollars and cents to truly measure performance.
Model It Out!
![Page 61: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/61.jpg)
61
Converting Data to Intelligence
Turn Actionable Intelligence Into Strategies & TacticsCentralize Intelligence and Analysis in One Location
Plan and Coordinate Business Intelligence Meetings to Review KPIs
Reference Your Intelligence During Every Strategic Discussion
Monitor Performance Against Targets, Trends and Peers Over Time
Understand Cause and Effect
Build Scenarios and Refine Action Plans
![Page 62: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/62.jpg)
TAKEAWAYS
![Page 63: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/63.jpg)
63
THE DIFFERENCE MAKERAn organization’s ability to identify meaningful and precise Business Intelligence amongst the growing clutter of available information.
Takeaways
Key ingredients for Dramatic Change and Transformation:
1) Lead with Strategy2) Systematic Approach3) Better Information4) Thorough Analysis5) Action
![Page 64: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/64.jpg)
64
Takeaways
QUESTIONS / DISCUSSION
![Page 65: Making Sense of Data and Analytics for Private Clubs€¦ · Lego overtook Mattel and Hasbro to become the biggest and most profitable toy company in the world. Turnover. EBITDA](https://reader034.vdocuments.us/reader034/viewer/2022050611/5fb2a249d7d54b2c344596de/html5/thumbnails/65.jpg)
65
Lead with strategy.
Avoid getting too far into the weeds.
Seek help from third party vendors and providers.
Begin with existing internal data sources.
Initially focus on descriptive and diagnostic BI.
Define, track and set KPI targets that are aligned with your club's strategy
Develop a structured approach to assemble and trend critical business intelligence
Set up and schedule delivery of clean, crisp dashboards.
Layer in new internal and external data sources and analysis.
Build a dynamic financial and operating model.
Design key inputs and assumptions driving your club’s model.
Plan for the leap to predictive and prescriptive analytics.
Takeaways