Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Model review

I would like some feedback on this data model I have created for my organization. The model contains about 110 million rows. The performance in Ajax is actually quite fast. I would just like to hear what people think about this type of design. I used the patients as the center of the snowflake and then branched off on hospital visits, ambulatory visits, and home health visits. I could not use a master calendar with this table, nor do I think I would want to, as I want to see all a patients visits say in the hospital, when I choose their ambulatory encounter.

I also had to reload many of the dimension tables, as the dimensions are attached to each fact table with a left keep. So if I use a resident pull from them, I only get those providers from that fact table. I just would like to hear what people think and I am open to suggestions on how to make this better!

0 Replies