Dashboards are a powerful way to communicate data to your team. One use for dashboards is tracking the progress of key performance indicators (KPIs). One KPI tracked at Lucid is the ranking and performance of our products in third-party marketplaces. Although there are enterprise-grade products to gather and visualize this type of data, you can generate automated dashboards with only Google Apps Script and Google Sheets.
Finally, create the dashboards from the formatted data. See How to Make a Killer Data Dashboard with Google Sheets for tips and tricks.
Via: How to Build Automated Dashboards With Google Apps Script and Google Sheets
I have used D3 in concert with C3 to create a data visualization front end to a data warehouse. D3 has a ton of features but is difficult to use out of the box for the novice user. The C3 library puts a layer of smarts on top of D3 making it much easier to get started in graphic visualizations. I’ve also used CData product to get an ODBC connection to Google sheets in order to analyze and transfer results from a Google form survey to a data warehouse. CData products are very good just be willing to pay for that excellence.
This article is a good read because it combines the two to assemble a REST service and use it to provide the data feed to D3.
via Building Dynamic D3.js Web Apps With Database Data — DZone Web Dev Zone