If there’s one thing guaranteed to drive an analyst to drink or violence, it’s a request to update a 500-slide Powerpoint deck with thousands of once-tidy datapoints into a wipe-right-on-click abomination. I suspect that marketers are doing everything in their power to drag us analysts into the mud, to suffer as they suffer. Luckily, with help from Google’s Apps Script and their APIs, analysts can output all their data into a nice, tidy Google Sheet and auto-populate it into a Google Slides document with a single button press.

Author's picture

Donal Phipps

Analytical & data plumber

United Kingdom