Auxeum is a growing group of clinics in Germany specialising in lipedema, plastic surgery and aesthetic dermatology. Gemma Analytics replaced the clinics' manual Excel reporting with an automated data platform on Snowflake, dbt and Power BI that delivers fresh numbers every morning.
The starting point
Every clinic in the group follows the same patient journey: consultation, treatment, surgery. To steer it, management needs to know how many appointments are booked, how busy the doctors are and where revenue stands against budget. Those numbers sat in the practice management software, the telephone system and a collection of spreadsheets.
Surgeries, appointments and revenue were kept in spreadsheets and updated by hand once a week. On Monday the figures were fresh, by Friday they were a guess, and in between the clinics were flying blind. Building the report also took up a lot of internal time. The brief: automate that reporting and build a foundation that scales beyond the first use cases.
What we built
Gemma built a complete data value chain for Auxeum. Scheduled loading jobs pull data from all of these sources into a Snowflake warehouse. Because this is patient data, personal details are pseudonymised early in the warehouse. In dbt the raw data is modelled into the patient journey and a P&L view.
On top sit Power BI dashboards for operations, finance and marketing. They show revenue, consultations, treatments and surgeries against the previous year, revenue against budget, a forecast for the rest of the year, cancellations and no-shows, and revenue per location and per doctor. An open appointment planner shows for each clinic which upcoming weeks still have free slots. The setup was first built for one brand of the group and then rolled out clinic by clinic, each with identically structured dashboards.
The result
Instead of a weekly spreadsheet, the clinics now start every day with fresh numbers, and nobody builds the Monday report by hand any more. Operations sees the appointment pipeline, doctor utilisation and cancellations at a glance, finance tracks budget against actuals, and marketing sees per clinic and week where appointments are still open. Because the chain was built to scale, additional clinics were connected at a fraction of the initial effort.
Tools and setup
The platform runs on Microsoft Azure with Snowflake as the data warehouse. Apache Airflow schedules the loads, using dlt for custom sources such as the practice management and telephone systems and Fivetran for standard connectors like Google Sheets. dbt, also run by Airflow, builds the data models, and Power BI delivers the dashboards to the clinics, refreshed daily.