Empowering a Yoga Studio with Data-Driven Decisions

From Excel Analysis to Operational Excellence

Unlocking Success: Actionable Insights Through Data Visualization

In a rapidly evolving business environment, staying ahead means optimizing operations and making informed decisions.

A Dutch yoga studio recognized this need and partnered with Decision Crew.

Their goal was clear:  reduce manual tasks and enhance decision-making through insightful Key Performance Indicator (KPI) dashboards.

Their story proves that data-driven insights is essential in every business. Also in sports.

Project Fact Sheet

Country
Netherlands
Primary Service
Data Visualisation
Project Timeline
Aug '22 - May '23
Technology
Microsoft SQL Server, Alteryx, Microsoft Power BI, Bsport API

Why streamline business operations?

Problem Overview

The yoga studio faced challenges with time-consuming manual tasks such as weekly & monthly reports. They also lacked transparency into the performance of their studios, classes, and instructors. This led to inefficiencies and slow decision-making.

They needed a way to:

  • Identify bottlenecks in their processes
  • Automate manual tasks to save time
  • Identify their most profitable customer subscriptions
  • Gain a competitive advantage through data-driven insights

At the outset, we analysed their existing, manual Excel dashboards. We identified that their approach was to weekly download multiple data sets and then to aggregate data in pivot tables.

As data automation experts, our immediate goal was to help streamline operations and free up resource time, prior to providing actionable insights.

Our Process

Business Process Analysis

We reviewed the manual Excel scorecards together with the CFO, to understand the data sources and target KPIs.

Systems Analysis

Our client made use of Bsport, an all-in-one software solution for sports studios. We analysed their technical platform and API for identifying automated data processing opportunities.

Design User Experience (UX)

By using the Excel dashboards as an example, we could design an attractive user experience for the CEO & CFO to make data-driven decisions.

Create data automation flows & KPI dashboards

Our data crew built a custom KPI dashboard solution to enable data-driven decision-making. We also leveraged Alteryx for quick data integration and automation.
Image of the old Excel-based dashboards used by our client the Yoga studio. An image of the Power BI KPI dashboard built by our data crew for our sports client.

Solution Overview

We identified that our client’s most significant barrier to growth was the time-consuming manual reports and a lack of actionable insights. For this reason, we implemented a comprehensive solution focusing on data automation and data visualization.

Key Achievements:

  • Introduced Low-Code Apps: Utilized Microsoft Power Apps for intuitive data interaction
  • Enhanced Accessibility: Simplified user interface for team members without technical expertise
  • Increased Decision-Making Speed: Empowered broader employee participation, shortening response times
  • Seamless Integration: Integrated with third-party systems to eliminate data silos & manual work
  • Efficiency and Innovation: Automated repetitive tasks, allowing focus on high-impact projects

This transformation has significantly improved operational efficiency and decision-making capabilities.

Outcome

This success has encouraged them to expand beyond the initial project phases and integrating automation into various parts of their business.

Business impact:

  • Profit drain identified: For the 1st time, our client could visually understand the financial drain of one of its studios and make adjustments.
  • Automated reporting: Not only did we automate the Power BI dashboard – we even built an automated Excel with Alteryx workflows!
  • Smarter Decision-Making: Also for the 1st time, our client could report on custom categories for customers and see the behaviours of different member classes, leading to product-market fit decisions.

Not only did we achieve technical success with this project, but we simply loved working with our yogi client! Here is what they had to say:

What truly sets Decision Crew apart is their commitment to ongoing support & collaboration. They demonstrated a genuine interest in our success, readily providing guidance, training & continuous improvement suggestions.

Judith ManshandenManaging Director

1

Customer transactions processed

100

data tables created

1

Non-profitable Studio Closed