• Would you say the trending is fixed (as in merely year to year)? Or, do the end users need to be able to compare any periods to any periods (i.e. this quarter to last year, this month to last month, etc)?

    Also, is there a percentage compliance or a Key Performance Metric you must meet (say 80% Cardiac Nurses must be compliant by 2014--or "employee X must be 100% compliant by the end of the quarter or they're outta here!")? Are those metrics published at all?

    There are some designers that would put all the employee's compliance buckets into columns in the employee dimension (if those buckets were fixed) and, as part of the ETL process, update those buckets based upon the courses taken (courses stored in the fact table) or not taken (courses required but not existing in the fact table). It's called the "When A Dimension Becomes A Fact" concept.

    Joy Mundy of the Kimball Group wrote a nice concise article. In relating to this article, think of your employees as the entity and the courses taken as the measurement event.

    http://www.kimballgroup.com/2011/11/01/design-tip-140-is-it-a-dimension-a-fact-or-both/