What is the purpose of the article?
This article serves as an introduction to the Reporting tool available in Meddbase. Furthermore, the article sets out examples of reports with different complexity and the process of building them.
Each example of a report contains a link to a detailed article. Click the relevant report example title depending on the level of complexity you are interested in.
Introduction
When analytics and data tracking are at the forefront of your business, it is important to have the correct tools. The Meddbase Report Query Builder is a powerful tool for handling the vast amounts of data your system can collect. From appointments to demographics, accounts to referrals, your data can be pulled into functional, powerful reports.
Report examples (with varying complexity)
Simple report on Patient Demographics
- Quick and easy to build, no complex features used
Report on Appointments containing filters and parameters
- Utilising the Filter Builder to filter out data for a more detailed report
Report on Invoices - displaying multiple results using Aggregates
- Utilising filters as well as aggregates to organise multiple results in columns
Report on clinic utilisation using the Alias Manager
- Building sub-queries via the Alias Manager
Video Walkthroughs
To help you get started with the Report Query Builder, we have created a series of video walkthroughs. These videos provide step-by-step guidance on using the tool, covering everything from basic to advanced report-building techniques.
-
Reporting 1: Overview and Definitions
Learn about the root table, table relationships, and how to preview your data effectively. -
Reporting 2: Building a Simple Report
Follow along as we demonstrate creating a report with filters, conditions, and aggregates. -
Reporting 3: Building a Complex Report
Dive into advanced reporting by using aliases to manage complex queries.
Review date
This article was last updated on 4th December 2024.