Airtable Reporting Dashboard using Google Apps Script, Google Big Query and Google Data Studio

Airtable Report Dashboard Using Google Apps, Google Big Query, and Google Data Studio OVERVIEW: This blog covers the technologies I used to create a client’s Airtable Reporting Dashboard using Google Sheets/Google Apps Scripts, Big Query, and Google Data Studio. It contains links to the javascript and sql I used plus a video that demonstrates the […]

Continue reading

Moving From Excel to MS Access & SQL Server for Cleaning Up, Extracting, & Reporting on Data

Summary In our own work with data analytics, in coaching financial & business analysts, and with data conversions, we often coach clients to learn and use Microsoft Access or SQL Server, rather than (or perhaps more accurately, in conjunction with) Microsoft Excel. In this article, we explore some of the reasons why. “I suppose it […]

Continue reading