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!