mark.tan at 09h11
15
May
2009
Patient Re-admission Measure (count)
Dear DM Experts,
I am ponding this interesting scenario. What is the best way to resolve this requirement?
The simple is requirement is to track the patient re-admission rate in a hospital. For e.g., if patient A was admitted on 1st March 2009, 20th March 2009 and 12th May 2009. I will have 3 records in the fact table. To constitute a "re-admission" criteria, users can define a date range. Let's assume the u
Dear DM Experts,
I am ponding this interesting scenario. What is the best way to resolve this requirement?
The simple is requirement is to track the patient re-admission rate in a hospital. For e.g., if patient A was admitted on 1st March 2009, 20th March 2009 and 12th May 2009. I will have 3 records in the fact table. To constitute a "re-admission" criteria, users can define a date range. Let's assume the u
About
This topic belongs to the forum
Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.
- Numbers of topics : 1858
- Numbers of messages : 8714
- Numbers of users : 3801
- Numbers of points : 1672
Similar topics
Hi ngalemmo or fourm members,
Can I get advice on how to create a bridge table for patient diagnosis? To keep it simple, I have a patient, facilities, and doctor dimensions and one fact table. For a specific patient, I need to show all diagnosis in a
Gurus,
I have relational database where there is only one measure that is at an aggregated level whereas Dimensions are at lower level of granularity. Let me give you an
Hi all, I am currently wroking on a Star Schema [with few dimensions and one fact :-)] but ran into some issues regarding Unduplicated Aggregates.
Let me explain:
we have the following dimensions :
Ofices
Staff
I'm trying to figure out how to best model a DataWarehouse Star Schema structure to capture certain medical information that will answer the questions we ask.
First the questions to put in some context:
1) How many distinct patients had a BMI in the
I have a transactional fact table containing results of inspections. The results are non-numeric, but do represent a measurement, that is inspection result (like "pass", "fail", "pass with infraction", "failure with
Forums from same category
LEGO Island Discussion, modding, news and more!
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
HmongThoobNtiajTeb. com/
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Search
Informations
6 Replies For the topic :
"Patient Re-admission Measure (count)"
This topic has been viewed 1375 times.
Last message :
15/05/2009 at 09h11 by "mark.tan"






