Avatar of Marcus Aurelius
Marcus Aurelius
Flag for United States of America

asked on 

Best way to create a MEDICAID Data Warehouse using Kimball Style concepts? Facts? Dims? etc...


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!

Microsoft SQL ServerOracle DatabaseSSASMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
Marcus Aurelius

8/22/2022 - Mon