How Datum Labs Collaborated with Wellness Studio on Building Scalable Data Pipelines‍‍

About the company– Wellness Studio: A Commitment to Accessible Fitness

Wellness Studio is a prominent chain of 29 training facilities located throughout southeastern Sweden, dedicated to helping people achieve a healthy life through regular training. Since its founding in 2004, Wellness Studio has prioritized accessibility by establishing facilities in both central and rural areas, ensuring that everyone has the opportunity to engage in consistent exercise. Guided by the core values of joy, passion, and caring, Wellness Studio offers the best possible start to their client’s fitness journey. With a team of 80 employees, they utilize modern technology to inspire and motivate members, fostering a strong desire for exercise and well-being.‍

The Challenge—Overcoming Visualization and Financial Data Challenges at Wellness Studio

Wellness Studio encountered significant challenges in efficiently managing and extracting financial data from Fortnox, the accounting tool used to record all financial transactions across their 29 gym locations. The complexity of consolidating financial information from multiple facilities created difficulties in maintaining accurate and up-to-date records. This issue affected their ability to monitor and analyze key financial metrics effectively, such as income, expenses, profits, and contribution margins.

Key challenges included:

• Difficulty extracting and consolidating financial data across multiple gym locations.
• Challenges in maintaining accurate and timely financial records.
• Complications in tracking and analyzing critical financial metrics such as income, expenses, profits, and contribution margins.
• Strain on resources due to manual processes and data discrepancies.

Tech Stack and Data Sources

The Solution: Bridging the Gap

To address the challenges faced by Wellness Studio in managing their financial data, a robust data pipeline was implemented. This pipeline retrieves data directly from the Fortnox API and seamlessly inserts it into BigQuery, ensuring that all financial records from their 29 gym locations are accurately consolidated. The pipeline is deployed on Google Cloud Functions, with Cloud Scheduler automating daily runs, guaranteeing that the data remains current and reliable. The solution also included the development of a PowerBI dashboard, where the data was modeled, relevant tables connected, and visualizations created. This dashboard enables Wellness Studio to efficiently analyze key financial metrics such as income, expenses, profits, and contribution margins, providing the insights needed to make informed decisions and optimize their operations.

The Data Transformation Process‍

Key aspects of the solution:

• Automated Data Retrieval: Daily data extraction from Fortnox API using a pipeline deployed on Google Cloud Functions.
• Centralized Data Storage: Insertion of data into BigQuery, ensuring accurate and up-to-date financial records.
• Comprehensive Data Analysis: Modeling and visualization of data in PowerBI, with connected tables and a custom dashboard tailored to the client's needs.‍
• Enhanced Decision-Making: Improved ability to monitor and analyze financial metrics, leading to better operational efficiency and strategic planning.

Datum Labs: Empowering Data-Driven Decision Making at Wellness Studio

DatumLabs played a crucial role in helping Wellness Studio enhance their financial reporting capabilities. By extracting data from Fortnox and building semantic models in PowerBI, DatumLabs provided a streamlined and efficient solution for creating detailed accounting reports and dashboards. The process is automated with a scheduled pipeline, ensuring that Wellness Studio always has access to up-to-date and accurate financial insights. This not only improves their ability to monitor financial performance but also empowers them to make data-driven decisions that align with their business goals.