Automated IPEDS HR reporting, taking the time required from 7 weeks to 7 hours. Created a table storing all values to answer the governments questions regarding University staff and faculty. IPEDS is similar in detail and scope to HEDIS reporting in healthcare. Wrote procedures to harvest, standardize and aggregate data to load into warehouse table from ERP. Gave the HR dept tools by which they could evaluate the results to produce the reporting.
Next time, will break down the results into dim and fact tables. This will be part of a beginning effort to create a datamart or extend an existing warehouse with HR analytical objects.