php - Steps to creating a Google Analytics-like data visualization system -

i wish create web dashboard team (day-to-day visualization). looking insight how proceed (perhaps steps, best technologies, etc). confortable jquery, php, html/css, lack in terms of mysql, needed in case.

so, here requirements:

1/ need create input interface manually enter data day (which possibly replaced api calls services, making manual now)

2/ database capture data

3/ dashboard display info 3.1/ various chart types, 3.2/ * date range selection tool 3.3/ data itself, values in table

so can see, google analytics-ish.

can me figuring technologies should use, best practices, resources such tutorials, techniques, , examples.

thanks in advance!

jonas

you migh consider using highcharts purpose. highcharts can talk json interface, have here examples: http://www.highcharts.com/documentation/how-to-use#live-charts

a sample database call might work this:

<?php mysql_connect("hostname", "user", "password"); mysql_select_db("mydb"); $result = mysql_query("select * mytable"); $obj = mysql_fetch_object($result); mysql_free_result($result);  echo json_decode($obj);  ?> 

this return valid json server, can point highcharts , build charts. luck!