PowerBI Data Model for CCMDB

From CCMDB Wiki
Revision as of 17:37, 11 December 2024 by Ttenbergen (talk | contribs) (Created page with "I am setting up a data model for CCMDB in PowerBI for some of the data I am doing for Dr. Robert's project. Needed to document some stuff and thought this was a better place for that than my email or similar. Rough notes for now. == state of setup == * I have things mostly set up to work with current data, ie I have not necessarily dealt with old style dates or dxs etc * currently only working with content from CCMDB, CFE, Centralized, ie not labs or any legacy data =...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

I am setting up a data model for CCMDB in PowerBI for some of the data I am doing for Dr. Robert's project. Needed to document some stuff and thought this was a better place for that than my email or similar. Rough notes for now.

state of setup

  • I have things mostly set up to work with current data, ie I have not necessarily dealt with old style dates or dxs etc
  • currently only working with content from CCMDB, CFE, Centralized, ie not labs or any legacy data

File Location

  • currently on my desktop

copy to x:

Modelling

general notes about modelling in PowerBI

  • requires a different way of thinking since it is designed around being able to slice and dice the data, ie if you set the model up right you should no longer need to decide if you calculate by admit or dispo, because you can just range right into the middle of things.

things modelled

  • Hospitalization table to group data for easy access to first and last records of a hospitalization and all D_IDs in it
  • L_Boarding which
  • LOSs contains measures to calculate LOS_ER, LOS_Reg (legit med stay), and LOS_Over (time between initial transfer ready and the last dispo for the hospitalization