Talk:Sales Report 2010

From FreekiWiki
Revision as of 14:22, 21 January 2011 by Tonyc (talk | contribs) (starting discusison tab with sql ideas)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

data mining

specific reports that would be useful (that involve sql)

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)

data mining for Online Sales

From Beancountes: Income from online sales, broken down to monthly

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)