Talk:Sales Report 2010

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

Specific sales stuff:

How much did we make from printers, NOT including sales to Gentech?

show sales income in category printers where contact not equal to Gentech (tony's pseudo sql)

Totals for each gizmo cat. for Gentech

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)