Best way to create a MEDICAID Data Warehouse using Kimball Style concepts? Facts? Dims? etc...
Posted on 2016-09-18
I'm looking for input on ideas to keep in mind when planning and creating a MEDICAID data warehouse. This data will be used to help identify WASTE, FRAUD AND ABUSE.
Has anyone worked on this type of DW?
I'd be interested in hearing what you used for you BUS MATRIX concept.
What type of Fact(s) table(s) did you create, what DIMS did you create...etc..etc..
A sample STAR SCHEMA would be GREAT is you have one!