Talk:Sales Report 2010

FGDB data mining

specific reports that would be useful (that involve sql)

store hours

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

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)