Johnny Ho
Menu
All projects

UNSWCoursework

Hospital data model & Power BI insights

Hospital data modelled, then visualised in Power BI

  • Power BI
Animated overview of the steps below (an illustration, not recorded footage).

From data model to dashboards

  1. 01Step 1 of 3

    ERD

    Entity relationship diagram of the hospital data.

  2. 02Step 2 of 3

    Schemas

    Relational schema, then a snowflake schema for analysis.

  3. 03Step 3 of 3, Power BI

    Power BI

    Dashboards on patient distribution and health-fund usage.

Tech stack in this project

  • Power BIDashboards on patients and health funds
  • ERD
  • Relational schema
  • Snowflake schema

Why it matters for supply chain

  • Snowflake schema = warehouse design for ERP reporting
  • Distribution views = demand by location for network planning

Linked to my Master of Logistics & SCM, University of Sydney

Read the full case study

Problem

Model hospital data so it can be analysed, and surface insights on patient distribution and health-fund usage.

Approach

  1. Designed an entity relationship diagram and relational schema.
  2. Designed a snowflake schema for analysis.
  3. Built Power BI dashboards on patient distribution and health-fund usage.