Yes, it is important to know previous years deparment's compliance for comparison and trending and later on predictions.

This is correct. My compliance can move through finite steps, however it has to be based on a set of courses having a 'Completed/Passed' status.

I have been able to upload the dimensions that I will be using (most of them covers the suggestions given).

My process. I have several source data tables.

I create a...

The top 10 are:

1. What training has each staff member done or need to do

2. Is each staff member compliant

3. When next do they need to do their training

4. Have...

the diagram is not of the dimensions and fact table but of the OLTP at the second stage.

Stage 1. RawData into generic table

Stage 2. Data cleaned and loaded which...

For the most part, yes. It is geared to L&D rather than clinical systems.

Dear Nick,

I have already done the first step. so, what's in my dimension tabls have both the source keys and new surrogate keys.

the schema posted is not my Datawarehouse...

Dear All,

Thank you for your comments. I will be getting rid of the NULL values and reducing the size of my int(s) pronto!

I have Amazoned the MS Data Warehouse Tookit...