Difference between revisions of "Talk:Sales Report 2010"
| Line 1: | Line 1: | ||
==FGDB data mining for Store== | ==FGDB data mining for Store== | ||
specific reports that would be useful (that involve sql) | specific reports that would be useful (that involve sql) | ||
| + | Once we start acquiring these, maybe should be dumping data into a spreadsheet that is linked to from here (store folder on talon?) All these seem to break down pretty easily into grids: | ||
| + | |||
| + | Page for each worker, with axes for Job category and month, for 2010. | ||
| + | |||
===store hours=== | ===store hours=== | ||
| + | |||
| + | For 2010: | ||
;Monthly breakdown by work category, by all workers: | ;Monthly breakdown by work category, by all workers: | ||
| Line 31: | Line 37: | ||
Determine which month Luiz took over Tech Support (and when he dropped hours in store) | Determine which month Luiz took over Tech Support (and when he dropped hours in store) | ||
Easiest to just look at when he started logging "tech support" hours? [[User:Tonyc|Tonyc]] | Easiest to just look at when he started logging "tech support" hours? [[User:Tonyc|Tonyc]] | ||
| + | |||
| + | |||
| + | For context, total hours by each of these categories could be mined (without breaking into each worker, etc), monthly dating back to 2008 (far enough?)[[User:Tonyc|Tonyc]] | ||
Volunteer data: | Volunteer data: | ||
Revision as of 15:12, 21 January 2011
FGDB data mining for Store
specific reports that would be useful (that involve sql) Once we start acquiring these, maybe should be dumping data into a spreadsheet that is linked to from here (store folder on talon?) All these seem to break down pretty easily into grids:
Page for each worker, with axes for Job category and month, for 2010.
store hours
For 2010:
- Monthly breakdown by work category, by all workers
- Thrift Store
- Sales Admin
- Thrift Store Admin
- Safari
- Monthly breakdown only for Sales regular staff
- Meeting
- Mtg Prep (small, but what the heck?)
- Training (I've used this sometimes while training interns, but it'll be trivial)
- Thrift Store regular staff
(would want to look at all hours from above categories, by month)
- Leah
- Paco
- Ian
- Mike
- Tony
- Luiz (before Day X)
- Store/Sales Part timers
(These folks have other primary focus, so we should only look at the sales-specific categories)
- Ebeth
- Sergio
- Luiz (after Day X)
Determine which month Luiz took over Tech Support (and when he dropped hours in store) Easiest to just look at when he started logging "tech support" hours? Tonyc
For context, total hours by each of these categories could be mined (without breaking into each worker, etc), monthly dating back to 2008 (far enough?)Tonyc
Volunteer data:
- Number of volunteers, total for 2010
- Number of hours logged in 2010, by each intern
seems silly, but we can build total hours from this, and spot if there's a large turnover, or any superstars we're relying on, e.g. Jesse Tonyc
FGDB data mining for Online Sales
From Beancountes: Income from online sales, broken down to monthly (michael will provide from 2008-2010)
From FGDB: Monthly hours breakdown for category "online sales"
- Santiago
- Ebeth
- Sergio
- anyone else (if the totals of these three don't add to actual total)