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 readingTag Archives: data analytics
Solving line breaks and other unstructured data when importing CSV files
I’m going to provide a sample text file and a sample Excel VBA macro file for you to test. You can find the download below. Structured Data is Nice but Not Always Possible It would nice if every system had the ability to export data in more structured formats, like XML or json, rather than […]
Continue readingMoving 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