I would like to track different categories of user compliance across our organization each month and place the data in the data warehouse so that I can show improvement over time on a dashboard. For example, I would like to track the extent to which the required documents are present as appropriate to the current phase of each project. I don't need to track a monthly score on each individual project, but would like to record the average compliance for the organization in that particular category for each month.
What would you recommend as the best way to store these monthly stats?
Don't know whether its the "best" (how do you define "best"?) way, but a way could be;
Custom sub-object of the project object to store your "score" (at project level) per month
Custom process to determine (via SQL) the "score" and create (via XOG) a new instance of the sub-object containing the "score" every month.
Could then report on the organisation/department score then (by adding up the "scores" from the projects within the organisation/department) in a fairly simple query-based portlet in the main application or in some richer MI in wherever you run your MI from (Jaspersoft?).
That's very helpful, thanks.
Check out the Rego Adoption Metrics.