Aidbox FHIR - DBT Sample project

Docs | PowerBI demo | Aidbox/dbt_fhir package | Aidbox

---

This project demonstrates the work with Aidbox FHIR data with the Aidbox/dbt_fhir package. In this project, you can find examples how to create a flat representation of FHIR data and building analytical models.

Quick start

• Run aidbox - Install and run Aidbox following getting starter guide
• Load synthetic data usign Synthea and Aidbox bulk api
• Connect to the Aidbox database. Create dbt connection profile via ~/.dbt/profiles.yml

  AidboxProject:
    target: dev
    outputs:
      dev:
        type: postgres
        host: "<aidbox_db_host>" 
        port: "<aidbox_db_port>"
        user: "<aidbox_db_user>"
        password: "<aidbox_db_password>" 
        dbname: "<aidbox_db_name>"
        schema: public
        threads: 5
        keepalives_idle: 3 # default 0, indicating the system default. See below
        connect_timeout: 100 # default 10 seconds
        retries: 5  # default 1 retry on error/timeout when opening connections

Install

dbt deps
dbt seed

Features

• Incremental ts, id
• Parallel optimized parallel workers
• Dimensional Kimbal model fact_* and dim_ models
• OLAP Cube examples marts
• Cohort analyses ....

Framework

3 layers

• RAW fhir data (here is dbt project with fhir helpers)

• Flat usable views (dimensional/star model)

• Aggregate your date (OLAP cube)

• Flat your data - star model

  • List facts and dimentions

• Create pre aggregated views (cubes)

• Use BI

Analytics framework ...

• Flat dimentional model ...
• Build CUBE`s data marts ...
• Use cube data mart on BI ...

---

Powered by Health Samurai | Aidbox | Fhirbase