PROJECTS

Classes (2) Club Administration (7) Clubs (1) Members (6) Olympics (2) Planning (2)


SO, YOU WANT TO BE A SUMMER OLYMPIAN – PART 2: COUNTRY

SO, YOU WANT TO BE A SUMMER OLYMPIAN – PART 2: COUNTRY

Now that you’ve found your sport, it’s time to find your optimal country. Start by selecting your sport and taking a look at which countries have excelled at it over the years. Choose a country to see how it has performed over the years, and if it is dominant within the sport. Finally, search for…

SO, YOU WANT TO BE A SUMMER OLYMPIAN?

SO, YOU WANT TO BE A SUMMER OLYMPIAN?

I decided to take a look at Olympic data this week. I found a dataset on Kaggle that included (many) of the height/weight/age details for competitors over the years and thought it would be interesting to see which sport I am physically best suited for (it’s Shot Put/Hammer Throw and a few others). The dashboard…

WHERE ARE THE MEMBERS?

WHERE ARE THE MEMBERS?

Each year all clubs receiving public funding submit their membership numbers to three sports organisations in Denmark (DIF, DGI and DFF) via a central portal (Centralt Forenings Register). Those numbers are further turned in to a detailed report looking at membership across the clubs in Denmark (see medlemstal.dk). I created a report for clubs Inspired…

FIND YOUR NEXT CLUB IN DENMARK

FIND YOUR NEXT CLUB IN DENMARK

Denmark is a country of clubs and associations – everything you can think of probably has a club here. Each year all clubs that receive funding from the municipality (kommune) submit their membership numbers. These numbers are aggregated based on age groups, gender, activity and location. It’s a great dataset for looking at what is…

MEMBERS – LEFT (part 3)

MEMBERS – LEFT (part 3)

This is part 3 of my deep dive into members of a sports club. The business term for this would be attrition – in other words – who is leaving the club. Retention is covered in part 1: Members – Current, and acquisition is covered in part 2: Members – New. The club wanted to…

MEMBERS – DEVELOPMENT (part 4)

MEMBERS – DEVELOPMENT (part 4)

This is the final report relating to members of a club. This time I look at how the demographics (and payments) of members have changed over time. The development report gives a high-level view of how the club is performing based on member numbers and income relating to members within a relevant period. Metrics highlight…

MEMBERS – NEW (part 2)

MEMBERS – NEW (part 2)

This is part 2 of my deep dive into members of a sports club. The business term for this would be acquisition. Retention is covered in part 1 Members – Current. The aim is to understand why members choose to join and what factors could play a role. The report is used to understand marketing…

CLASSES – CAPACITY (part 2)

CLASSES – CAPACITY (part 2)

The Class Capacity report is the second of the Classes report and focuses on the capacity of coaches, classes and locations. The club wanted to understand what space was available in their locations for planning purposes, health & safety, and resource planning. Suppose a club’s ambition is to grow. In that case, it is crucial…

CLASSES – OVERVIEW (part 1)

CLASSES – OVERVIEW (part 1)

The Classes report is a part of a reporting pack. The club wanted an overview of the different classes they offered to support planning activities. Planning activities can include marketing, pricing, resource management and waiting list reduction activities. The report also shows the club what “type” of club it is. In this case, most classes…