topic Data Model review in QlikView https://community.qlik.com/t5/QlikView/Data-Model-review/m-p/923989#M529984 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>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!</P></BODY></HTML> Fri, 31 Jul 2015 13:09:18 GMT 2015-07-31T13:09:18Z Data Model review https://community.qlik.com/t5/QlikView/Data-Model-review/m-p/923989#M529984 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>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!</P></BODY></HTML> Fri, 31 Jul 2015 13:09:18 GMT https://community.qlik.com/t5/QlikView/Data-Model-review/m-p/923989#M529984 2015-07-31T13:09:18Z