This page is the working notebook of the process required to generate this study with 2006 data.
The plan is to repeat for the third time the raw SAP data dump of detailed transaction reports for the institute.
Also to try to link warehouse data to the DTRs using some common field. We had skipped the warehouse before as their data omitted the long-text detail of what the transaction was for, which is sometimes necessary to identify faculty purchases of equpment on credit cards, and so on.
...
- design the Brio IT Shops query on Feb 5.
- know by Feb 12 whether we can do the IT shops that way, and if not, do it by hand.
- be done with the data aggregation by Feb 22. Slides are generated by Feb 23.
Priority Work for Feb 1 to Feb 5
Chart of Accounts
- Pull out the new Chart of Accounts -- ROB
- Compare its Cost Objects to the ones from the old IT Shops list, and mark the ones that repeat this year.
- Mark the ones that are known NOT to be IT Shops based on last year.
- Examine the ones that are truly new and see if any seem to be IT Shops.
Siide Deck
- Update the charts in the slide deck to hold three years of data. ANGIE
Major Work Breakdown Structure
...