troubleshooting Question

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

Avatar of Marcus Aurelius
Marcus AureliusFlag for United States of America asked on
Microsoft SQL ServerOracle DatabaseSSASMicrosoft SQL Server 2005
3 Comments1 Solution218 ViewsLast Modified:
Experts,

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!

Thank
ASKER CERTIFIED SOLUTION
Megan Brooks
SQL Server Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros