Skip to content

Healthcare and clinical researchBI, AI and ML for the business

Screening programmes by district

A screening programme's invitations, uptake and tests sit in the invitation system, the laboratory's results and the clinics' schedules. Muvia joins them district by district: who takes part least, where the follow-up test takes longest, and Athena explaining why and saving the analysis.

Illustrative scenario: it describes a typical case, not a customer project.

The regional average hides the districts that fall behind.

A screening programme is measured by uptake and by time: how many invited people take the test, and how long someone with a positive test waits for the follow-up exam. The regional average can look fine while one district takes part little and another makes people wait twice as long.

Spotting it takes invitations, results and schedules in one place, read by district and age group. And it takes clear answers for whoever decides where to open new sessions or step up reminders.

Who it's for
Health authority management and prevention departments, screening programme leads, epidemiologists and analysts.
Invitations from the screening system on SQL Server, laboratory test results over SFTP, colonoscopy schedules from an Oracle database and population by district in Excel flow into Muvia; out come the Analysis of waiting times, an uptake dashboard, Athena's answers and a notebook for management.

In Muvia, step by step

Real product screens, recorded on a project with sample data.

1 of 5

The video · A screening programme's invitations, uptake and tests sit in the invitation system, the laboratory's results and the clinics' schedules. Muvia joins them district by district: who takes part least, where the follow-up test takes longest, and Athena explaining why and saving the analysis.

What you get

The lagging district has a name
Uptake and waits are read district by district, not only in the regional average.
The why, with numbers
Athena explains what holds a district back and shows the query it ran: the answer can be checked.
The analysis stays
Query and notebook stay in the Lab, ready to rerun next month on new data.
Decisions on sessions and reminders
Where to open sessions or step up reminders is decided on the same numbers.

For the technical team

How it is built in Muvia

  1. 1

    Connect invitations, results and schedules

    The screening and scheduling databases are copied on a schedule, incrementally; laboratory results arrive as files. Every source becomes a table.

  2. 2

    Measure uptake and waits

    Two queries work out uptake by district and age group and the days from positive test to colonoscopy; they become datasets with stable fields.

  3. 3

    Read the distributions in Analysis

    In Analysis, compare the distribution of waits by district and week and follow uptake over time, with reminder campaigns annotated on the chart.

  4. 4

    Ask Athena who is lagging

    The programme lead asks, in their own words, which districts are falling behind. Athena answers with the numbers and the query it ran, saves the query in the Lab and writes the notebook for management. It is a module the organisation chooses to switch on.

  5. 5

    Schedule the summary

    The notebook becomes a monthly PDF for management, always built on the latest copy of the data.

The data it needs
  • Invitations and uptake by person, district and age group, from the screening system on SQL Server
  • Test results, laboratory files received over SFTP
  • Colonoscopy schedules and procedures, from an Oracle database
  • Target population by district, from an Excel file
Parts of Muvia used

Bring us a question you can't answer today.

We start from a real question your business has and walk the path from source to dashboard with your systems, not a demo dataset.