Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Healthcare, diagnosis and Dimension model

Go down

Healthcare, diagnosis and Dimension model Empty Healthcare, diagnosis and Dimension model

Post  RogerS Sat Sep 29, 2012 8:12 am

Hi, I'm current in research for doing some major improvements in our healthcare data warehouse. I have few questions regarding using a dimensional model for our healthcare data. Hopefully, they are trivial to some of you.

Here is our problem

Currently we do not have a data model in the proper meaning of the word. We have several data marts who sometimes are dependent and sometimes not. My idea is to introduce a data model and I'm currently checking if dimensional models is an approach. I can also say that we work mainly with the SAS software.

When I read about Dimensional models, it's mostly about some type of economical approach and therefore it's practical to store billing information in the fact table. In our data, we mainly have yes/no answers to questions like "Do you have Diabetes". We have only a few measurements like blood pressure, radiation dose but I don't think they are Fact-material. Is this a problem? Are they any examples on successful healtcare implementations?

My main concern is the question of how the model supports diagnosis, when a patient can have any number of diagnois. Is this Hierarchy or Level? We have several one to many answers in our data.

I understand that we can use conformed dimension to link a patient-dimensional model with a operation-dimension model. Is this correct?

I have one more question.
Is the ETL goal to create a data model and from the model create different datamarts?

With regards
Roger Svensson

RogerS

Posts : 5
Join date : 2012-09-29
Age : 53
Location : Sweden

Back to top Go down

Healthcare, diagnosis and Dimension model Empty Multivalued Diagnosis Dimension

Post  RogerS Sun Sep 30, 2012 12:21 pm

I actually found an entry of this in the "The Data Warehouse Toolkit, 2nd ed., p.262-" ;o) This may help...

RogerS

Posts : 5
Join date : 2012-09-29
Age : 53
Location : Sweden

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum