Software & data systems · 2026

BusiIndex

Explore healthcare markets without working around a workbook.

A substantial body of healthcare analysis lived inside Tableau workbooks. BusiIndex gives that work a purpose-built interface: choose a sector, explore an area and inspect the measures behind the map. The migration preserves the established calculations while making individual parts of a dashboard easier to maintain and improve.

Status
Active development
Domain
Healthcare analytics · Geographic tools
Role
Application architecture, workbook migration and interaction design
Year
2026
BusiIndex · Interactive concept

Explore the workflow with illustrative content.

Stage 03 / 03

Compare the nearby activity

Sample sites and a route sit above the catchment. Switch between locations to see the area of interest move across the map.

Illustrative content · no live data

Build a view of the market, layer by layer

Stack

  • Python
  • FastAPI
  • PostgreSQL
  • JavaScript
  • GeoJSON
  • Tableau Hyper

A web application bringing healthcare, dental and veterinary analytics into one place, with interactive maps, editable dashboard layouts and the existing data models behind them.

01

Keep the knowledge, improve the interface

The project brings the health, dental and veterinary workbooks into a shared application.

Maps, tables and summaries retain their analytical roles, with a consistent way to move between sectors and inspect an area.

02

Check the migration against the original

A new interface is only useful if it preserves the meaning of the numbers.

The rebuild reads established demand and supply measures from PostgreSQL and compares outputs with Tableau extracts. Any deliberate difference is recorded separately from the migration checks.

03

Change one part without rebuilding the whole

Each chart, map or table has its own definition.

A dashboard brings those definitions together as a layout, which makes a targeted change easier to review and reduces the chance of affecting unrelated analysis.

04

An ongoing product

The work has progressed from workbook reconstruction into site tools, map interactions and editing states.

Health, dental and veterinary analysis are the current focus; radiology remains a separate, unfinished extension of the interface.

Behind the work

The skills
that came together.

Migration

  • Workbook and calculation reconstruction
  • Result comparison against source workbooks
  • Modular dashboard architecture

Experience

  • Interactive geographic exploration
  • Cross-sector dashboard design
  • Site tools and editable layouts

Project highlights

  • Three sectors together

    Health, dental and veterinary analysis

  • Familiar calculations

    Outputs checked against the original workbooks

  • Geography first

    Maps and site tools alongside the underlying measures

  • Smaller, safer changes

    Each dashboard element is maintained independently