4 ms·

This may be a good place to ask this question -- We are a small startup that has its data in MySQL database and google analytics. We are now focusing a lot more

by sinatra 12y ago

This may be a good place to ask this question -- We are a small startup that has its data in MySQL database and google analytics. We are now focusing a lot more on our marketing/advertising efforts, and would love to have a dashboard on a big screen that can collect, show, and update this data everyday (or better still, real-time). What do people use for something like this?

rahilsondhi 12y ago
At InternMatch.com, we use Geckoboard - it pings our Rails app periodically for stats. Our Rails app uses this gem to expose endpoints to Geckoboard: https://github.com/ejdraper/chameleon https://github.com/ejdraper/chameleon We do a bunch of other cool stuff too for stats. I'd be happy to help you if you ping me :)
- sinatra 12y ago
  Thank you! I'll definitely have to ping you in a day or two. BTW, Geckoboard seems to have most integrations that we would need. I'm wondering if you used any of them and if you'll say that the integration was very straight forward or if it needed to be told a lot to be useful
Maxious 12y ago
If you can't afford Geckoboard, Dashing is open source https://shopify.github.io/dashing/ https://shopify.github.io/dashing/ There's a tutorial specifically about MySQL https://github.com/Shopify/dashing/wiki/How-to%3A-send-mysql-data-to-your-widgets https://github.com/Shopify/dashing/wiki/How-to%3A-send-mysql... And a variety of Google Analytics (and other platform) widgets https://github.com/Shopify/dashing/wiki/Additional-Widgets https://github.com/Shopify/dashing/wiki/Additional-Widgets
cheald 12y ago
Elasticsearch + Logstash + Kibana is a wonderful match for this if you want really deep dive into your data. You can slice and dice and aggregate and display it in a ton of different ways. For counters, statsd + Librato is dead easy to set up and is really nice for communicating key metrics easily.
zhte415 12y ago
Big screens are great for dashboards. I don't use Google Analytics (access and reliability of Google products is unstable where I am) so turned to Piwik, which stores analytical data in a database, so you have immediate access to, well, everything. Querying this can be easily automated.
IndianAstronaut 12y ago
Check out Shiny, which is a super easy platform I R to make dashboards.
alexcash 12y ago
Check out http://www.sqldashboards.com/ http://www.sqldashboards.com/ live database charting and a command line version is available on the site aswell for generating reports.
takemikazuchi 12y ago
Chartkick is amazing: http://ankane.github.io/chartkick/ http://ankane.github.io/chartkick/

by sinatra 12y ago

rahilsondhi 12y ago

At InternMatch.com, we use Geckoboard - it pings our Rails app periodically for stats. Our Rails app uses this gem to expose endpoints to Geckoboard: https://github.com/ejdraper/chameleon https://github.com/ejdraper/chameleon We do a bunch of other cool stuff too for stats. I'd be happy to help you if you ping me :)

sinatra 12y ago
Thank you! I'll definitely have to ping you in a day or two. BTW, Geckoboard seems to have most integrations that we would need. I'm wondering if you used any of them and if you'll say that the integration was very straight forward or if it needed to be told a lot to be useful

Maxious 12y ago

If you can't afford Geckoboard, Dashing is open source https://shopify.github.io/dashing/ https://shopify.github.io/dashing/ There's a tutorial specifically about MySQL https://github.com/Shopify/dashing/wiki/How-to%3A-send-mysql-data-to-your-widgets https://github.com/Shopify/dashing/wiki/How-to%3A-send-mysql... And a variety of Google Analytics (and other platform) widgets https://github.com/Shopify/dashing/wiki/Additional-Widgets https://github.com/Shopify/dashing/wiki/Additional-Widgets

cheald 12y ago

Elasticsearch + Logstash + Kibana is a wonderful match for this if you want really deep dive into your data. You can slice and dice and aggregate and display it in a ton of different ways. For counters, statsd + Librato is dead easy to set up and is really nice for communicating key metrics easily.

zhte415 12y ago

Big screens are great for dashboards. I don't use Google Analytics (access and reliability of Google products is unstable where I am) so turned to Piwik, which stores analytical data in a database, so you have immediate access to, well, everything. Querying this can be easily automated.

IndianAstronaut 12y ago

Check out Shiny, which is a super easy platform I R to make dashboards.

alexcash 12y ago

Check out http://www.sqldashboards.com/ http://www.sqldashboards.com/ live database charting and a command line version is available on the site aswell for generating reports.

takemikazuchi 12y ago

Chartkick is amazing: http://ankane.github.io/chartkick/ http://ankane.github.io/chartkick/