2011-04-29 02:27 阅读 76

创建类似Google Analytics的数据可视化系统的步骤

I wish to create a web dashboard for my team (day-to-day visualization). I am looking for some insight as to how to proceed (perhaps steps, best technologies, etc). I am confortable with jQuery, PHP, HTML/CSS, but I lack in terms of mySQL, which is probably needed in this case.

So, here are the requirements:

1/ I need to create an input interface where I would manually enter the data for the day (which could possibly be replaced eventually with API calls to the services, but I am making it manual for now)

2/ A database to capture the data

3/ A dashboard to display the info 3.1/ Various Chart types, 3.2/ * A DATE RANGE SELECTION TOOL 3.3/ The data itself, values only in a table

So as you can see, it is really Google Analytics-ish.

Can you help me figuring what technologies I should use, best practices, good resources such as tutorials, techniques, and examples.

Thanks in advance!


  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

2条回答 默认 最新

  • 已采纳
    dtlzdofl66441 dtlzdofl66441 2011-04-29 02:49

    you migh consider using HighCharts for this purpose. HighCharts can talk easily to any JSON interface, have a look here for examples:

    A sample Database call might work like this:

    mysql_connect("hostname", "user", "password");
    $result = mysql_query("select * from mytable");
    $obj = mysql_fetch_object($result);
    echo json_decode($obj);

    This would return a valid JSON from the server, to which you can point your highcharts and build the charts. Good Luck!

    点赞 评论 复制链接分享
  • dragonhong641016 dragonhong641016 2011-05-15 07:38

    You can use embeddable chart widgets and update them automatically without SQL queries or database -- simply using Dropbox and CSV files (or FTP). Here is step-by-step guide how to do this:

    Example of a web-page with several widgets:

    The widgets have date range selection, zooming and comments linked to date ranges. Only line charts are available.

    点赞 评论 复制链接分享