NetTuts.com has continued their "Building Your Startup" series with this latest post focusing on the dashboard for the users of the meeting planner - a "quick look" into the current stats for their account.
For my initial statistics reporting, I focused on simple real-time data and detailed historical data. For example, real-time data would tell you the number of users and meetings built on the system to date and their status.
The historical data would tell you the number of users and meetings completed over time as well as other interesting data—especially growth curves that I and prospective investors may care about.
He then walks through the creation of the dashboard view, gathering together various pieces of real-time and historical data and displaying them in a simple table view. All code and SQL required is included as well as a few screenshots showing the results.