Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 3

Displaying posts with tag: Reports (reset)

Useful Reporting Queries for Your Business
+0 Vote Up -0Vote Down
I have rehashed a list of useful reporting queries from my blog which I hope people would find useful for their business or clients. These are not MySQL specific, by any means.

Orders

  • What is the total revenue (by segments)? - You are looking for 'peaks and troughs'. For example, found a peak season? you can plan better for it next year. Found an off-season? perhaps offer some deals for that period.
  • What is the total placed orders, completed orders and abandoned/uncompleted orders?
  • What is the total paid revenue vs outstanding orders? 
  • What is the total number of returned/cancelled orders and lost revenue from them?

Products (Best Sellers)

  • Which are the top 20% best selling products? (businesses love 80/20 comparisons and if you look at reports a lot, you will



  [Read more...]
Kontrollbase – graph “no data to display” on new install has been fixed
+0 Vote Up -0Vote Down
If you have been wondering why the overview and graphs pages say “no data to display” on the graphs when you first install Kontrollbase, it’s because there’s no data in the database being returned from the queries that generate the graphs – this is because a new install has no data to graph. This has […]
The Baden-Württemberg Brief
+0 Vote Up -0Vote Down
  • Two days in Frankfurt, two days in Munderkingen and two days in Heidelberg between December 5th and 17th. Mostly just ordinary working and travel days.
  • Visited Sandro Groganz of Init Marketing in Munderkingen. Worked from Sandro's house after a nice dinner on Sunday.
  • Caught up with (and was interviewed by) Rory MacDonald of Init Marketing while he was vacationing near Ulm. The interview was focused on Mozilla and should go online in the new year on http://www.initmarketing.tv
  • Visited Georg Richter of MySQL/Sun (http://www.mysql.com/) in
  [Read more...]
Showing entries 1 to 3

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.