OneDoc: A successful BI Project

Introducing OneDoc: The leading online booking platform for medical appointments in Switzerland

OneDoc is a game-changer in the Swiss healthcare industry, offering a revolutionary online booking platform for medical appointments. With a team of 40 passionate entrepreneurs based in Geneva and Zurich, OneDoc has partnered with leading groups such as Medbase (Migros Group), Hirslanden, HUG - Hopitaux Universitaires de Genève, Arsanté, Magellan Health and Medgate.?For more infos: www.onedoc.ch.

As a SaaS business, OneDoc provides subscriptions to practitioners, allowing them to:?

• Offer convenient online bookings to their patients.?
• Reduce the number of missed appointments with automated SMS reminders.?
• Streamline the management of their practice with ease.?
• Improve their online visibility with a presence on Switzerland's first online appointment booking platform.

The challenge

OneDoc was using bexio AG (www.bexio.com) for order processing, billing, and accounting, but they faced difficulties in evaluating sales figures and P&L data. The standard reports offered by Bexio were insufficient, as they were unable to drill down to the root cause of issues. Additionally, the manual effort was required to extract data from multiple modules and screens, making it challenging to quickly identify and address operational problems.?

?On an operative level, these were some of the pain points:??

• To get the full data set it was necessary to switch in between different modules and screens??
• Those views then had to be filtered and manually pulled out of the system for further processing?
• The most important KPI for OneDoc, as they operate in the area of Software-as-a-Service (Saas), is the so called Monthly Recurring Revenue (MRR), which was not evaluable within the frame of Bexio.

How did FS Partners - The CFO Company and CONSENSO address the challenge?

To tackle the challenge, FS Partners and CONSENSO joined forces. Christian Nauer, CFA from FS Partners, who had been supporting OneDoc as a CFO on demand for a few months, and Arthur Germain, CEO of OneDoc, took on the product management role. Meanwhile Leandro Aeschlimann and Sergei Semenkov from CONSENSO were responsible for developing the Business Intelligence (BI) solution.

The two companies developed a standard approach for BI projects. The first step is to identify key stakeholders, end-users, data sources, and volume, hosting, and expected capabilities and benefits. This is typically done through a BI Canvas or an initial workshop where the customer's needs are assessed and key features are drafted.?

In the OneDoc project, an on-site workshop was conducted to analyze and describe the challenge at a high level. The relevant KPIs of the company were also defined and how to build them using the available data in Bexio.?

With the insights gained from the workshop and the clear requirements, the CONSENSO development team was able to create a first prototype in a matter of days. In a subsequent review meeting, the prototype was examined and refined with OneDoc and FS Partners. After several iterations and thorough end-to-end testing, the first version was delivered in the recent weeks.?

Initially, it was considered to store the data in a separate BI database, but it was decided to do the data preparation, modeling, and visualization directly in Power BI due to the manageable data volume and potential IT transformation projects in the future. It is worth noting that all data is accessed directly via the Bexio API, enabling daily refreshes and a streamlined implementation for similar customers who use Bexio for order processing, billing, and accounting.

How does the comprehensive solution appear in detail?

Introducing OneDoc's feature-rich dashboard, designed to streamline and optimize their business processes. The user-friendly interface offers an array of components that provide valuable insights into OneDoc's performance. These components include:?

Comprehensive Sales Dashboard?

This all-inclusive dashboard encompasses:?

• Customer Segments & Individual Customers?
• Product Categories & Specific Products?
• Geographic Regions & Sales Territories?
• Analysis of Paid, Pending, and Overdue Payments

MRR (Monthly Recurring Revenue) Growth Analysis?

Gain an in-depth understanding of your monthly recurring revenue by examining:?

• Regions & Sales Zones?
• Product Groups and Individual Products?
• Customer Segments & Individual Customers?
• Comparison of Monthly and Annual Subscription Plans

Detailed Profit & Loss Statement?

This section offers a clear and concise presentation of your financial performance through:?

• Tabular format displaying all accounts, including Contribution Margin 1, Contribution Margin 2, EBITDA, and EBIT levels?
• Waterfall chart illustrating the accumulation of key figures for the selected time frame?
• Visual representation of business growth trends on an annual, quarterly, and monthly basis?
• Comparative analysis with corresponding previous periods

OneDoc's dashboard provides valuable insights and data-driven decision-making capabilities to help them stay ahead in the competitive landscape. With this intuitive and comprehensive tool, businesses can efficiently manage their financial performance and drive growth.

Customers Voice: Power BI Dashboard Experience and Benefits?

“With the Power BI Dashboard, we have significantly enhanced the overview of our business operations, to get actionable insights at all times in various ways through:?

Consistent Monitoring of Monthly Recurring Revenue (MRR): Our Power BI Dashboard allows the management team to track simply and visually the growth of the MRR vs. one-time fees regularly, empowering them to remain focused on their Key Performance Indicators (KPIs) and make data-driven decisions.?

Monthly Assessment of Cost Structure Evolution: The Power BI Dashboard enables us to analyze our cost structure on a monthly basis. This helps identify potential areas of improvement and facilitates faster decision-making and action to optimize expenses.?

Identifying Distinct Trends Through Data Analysis: Our Power BI Dashboard helps us recognize patterns and trends by analyzing data based on Product/Product Groups and Customer/Customer Groups. This valuable information enables our decision makers to adjust and steer their strategies accordingly for better results.?

Single click exports of KPI’s: The Power BI Dashboard allows us to generate reports in just a few clicks without needing to consolidate reports from multiple sources”?

Arthur Germain, CEO OneDoc SA

What is important when introducing the work with data???

After completing an initial pilot phase, the objective should be to integrate the data dashboard as a core component of management processes, by establishing and monitoring key performance indicators (KPIs) based on its insights. Adopting a data-driven management approach ensures that decision-making is consistently informed by up-to-date, accurate data.

What comes next??

A noteworthy benefit of this process is that OneDoc gains full control over their own data, granting them increased flexibility for any future IT initiatives that may emerge. This positions the company to proactively respond to evolving business needs and stay ahead in an increasingly competitive landscape.?

Moreover we just agreed to move to the Phase 2 of the project, where we will do the data extraction & transformation process to Apache NIFI and the data storage to a PostgresDB in order to setup the BI Landscape for further growth.

About FS Partners?

As the largest independent partnership-based consulting boutique for manufacturing companies headquartered in Switzerland, FS Partners – the CFO Company – specializes in readying its clients’ financial processes for current challenges and future success, both in Switzerland and in their global subsidiaries.?

The FS Partners Scaleup Desk comprises of experienced entrepreneurs assisting startups on demand and peer to peer readying organizations to scale and enabling founders to own their story while focusing on where they matter most. The team provides all the necessary financial competences, including:?

• Developing financial story
• Implementing scalable accounting and reporting infrastructure?
• Identifying and tracking data to guide and communicate decisions?
• Managing cash?
• Developing scalable routines?
• Financial and legal risk management liaising with external counsel where needed?
• Managing board of directors and funding rounds?
• Mapping and sourcing investors

For more infos: www.fspartners.ch

About CONSENSO?

CONSENSO is a young and innovative IT and digital business consulting company that is specialized in application development and technical consulting across key domains such as Business Intelligence & Data Analytics, system integration, master data management, and ERP systems. Our unique offering includes "CDO, CIO and CTO as a Service", catering to SMEs that require on-demand or interim Digital & IT leadership, or seek an external expert for targeted IT initiatives.?

Our philosophy emphasizes that software should be leveraged to enhance efficiency, productivity, and informed decision-making through data transparency. To achieve this, business processes and software must be carefully aligned prior to implementation or development, and new tools should seamlessly integrate with existing processes.?

At CONSENSO, we are committed to delivering comprehensive and strategic advice to our clients, enabling them to implement and develop applications that serve as sustainable, end-to-end solutions within their existing system landscape. This approach ensures that our clients derive maximum value from their IT investments, ultimately driving their core business objectives. To accomplish this, we prioritize understanding our clients' business models and processes in detail, and thoroughly assess their current system landscape to propose the most effective solutions.

For more infos: www.consenso-solutions.ch