How to Build Automated Dashboards With Google Apps Script and Google Sheets

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.

I have been using the power of the Google platform more often now. Why?  The power of Google Apps Script, a Javascript-like language with plenty of power and a large ecosystem of developers willing to share.  Mind you this is not easy for the typical spreadsheet user but, if you are a developer then you can rock this easily.  The same thing could be done with Microsoft office using Excel and some VBA scripts.  Most companies I work with don’t allow VBA because of the security issues.  Those concerns mostly go away when you use the Google platform.

Via: How to Build Automated Dashboards With Google Apps Script and Google Sheets




Data Driven Documents (D3), API Server (Cdata) Generate REST Server 80+ Data Sources.



D3.js is a JavaScript library for producing dynamic, interactive data visualizations in Web browsers, using the widely implemented SVG, HTML5, and CSS standards. The CData API Server enables you to generate REST APIs for 80+ data sources, including both on-premises and cloud-based databases. This article walks through setting up the CData API Server to create a REST…

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