Articles

Hello!

My goal here is to provide the best online resource for helping you to learn data analysis, data visualization, building dashboards and other data-related topics using Google Apps, specifically Sheets, Apps Script and Data Studio.

Before you start, why not sign up for my rather lovely Google Sheets and Data Studio email a couple of times a month?

You’ll be joining my community of over 5,000 data analysts, digital marketers, educators and YOU! 👍

If you’re interested in professional Google Sheets training, be sure to check out my online courses.

Here you’ll find all my articles, grouped (as best I can) into:
Data Studio | Google Sheets | Apps Script


Data Studio Articles

An introduction to Data Studio

6 advanced techniques in Data Studio

Community connectors to access any data in Data Studio

Data Studio resources


Google Sheets Articles

10 techniques to use when building budget templates in Google Sheets

Filtering with dates in the QUERY function

Data Cleaning and Pivot Tables in Google Sheets — course launch!

How to add a total row to a Query Function table in Google Sheets

How to create an annotated line graph in Google Sheets

Dashboard Design Checklist: From a Blank Google Sheet to Business Insights (incl. Facebook example)

Learn how to build dashboards with Google Sheets and Data Studio – Course launch!

How to create a funnel chart in Google Sheets

How to create a waterfall chart in Google Sheets

Friday reading: resources and inspiration for spreadsheet buffs

Format your Google Sheets so they look good GREAT

Vlookup in Google Sheets using wildcards for partial matches

Web traffic chart with dynamic banding in Google Sheets

Spice Up Your Sheet Life – Google Sheets/Excel Ebook

Creating dynamic charts using Google Sheets drop down menus

Premier League Social Media Dashboard in Google Sheets

Histogram and Normal Distribution Curves in Google Sheets

Everything you ever wanted to know about Sparklines in Google Sheets

How to use the FILTER function to return specific values in a Google Sheet

Google Sheets Query function: Learn the most powerful function in Google Sheets

Using Google Sheets as a basic web scraper

10 techniques for building a Google Sheets dashboard

How to create CSS pie charts in Geckoboard dashboards with data from Google sheets

Building a dynamic dashboard for a 3-day digital flash sale

Creating a custom Google Analytics report in a Google spreadsheet

Creating a dynamic dashboard in Google Spreadsheets to track sales for a digital product launch

How do I zoom in or out in Google Sheets?

How do I get the first and last days of the current month?

How do I get the first and last days of the prior month?

How do I do a vlookup in Google Sheets with wildcards for partial matches?

How do I do a VLOOKUP to the left in Google Sheets?

How do I return multiple values with a single VLOOKUP formula in Google Sheets?

How can I combine text and numbers in a cell and keep the number formatting?

How do I reverse text in a cell in Google Sheets?

How do I create a drop down list in Google Sheets?

How can I use an OR condition inside the FILTER() function?

How to create dynamic named ranges in Google Sheets

How does the array formula work in Google Sheets?

Use Array Formulas to auto-fill calculation columns when using Google Forms

How do I create a multi-colored line chart in Google Sheets?

How can I import Facebook Page metrics into a Google Sheet?

How can I import Twitter Follower counts into a Google Sheet?

How can I import Instagram Follower counts into a Google Sheet?

How can I import Google+ Follower counts into a Google Sheet?

How can I import YouTube channel counts into a Google Sheet?

How can I import Pinterest channel counts into a Google Sheet?

How can I import Alexa ranking data into a Google Sheet?

How can I import Quora follower data into a Google Sheet?

How can I import Reddit data into a Google Sheet?

How can I import Spotify data into a Google Sheet?

How can I import Soundcloud data into a Google Sheet?

Help, my formula doesn’t work! (Dealing with errors)

Google Sheets Resources


Apps Script Articles

Guide to getting started with Apps Script (for absolute beginners)

Guide to getting started with APIs using Apps Script

Saving data in your Google Sheets with Apps Script

How to set up time-based triggers to run your Apps Script code

How to add a hyperlinked index sheet or sidebar to your large Google Sheet workbooks

Google Sheets Slack bot: how to push data from your Google Sheets into the popular messaging app

Google Sheets and D3 charts

Multi-series D3 line chart (D3 only)

Creating a dynamic d3 visualization from the GitHub API (D3 only)

How to extract email addresses tagged with a specific Gmail label

How to reply to Google Forms survey responses quickly with Sheets & Apps Script

Connecting to the Crunchbase API with Google Sheets

Google Sheets and Mailchimp integration using Apps Script

Show data from the GitHub API in Google Sheets, using Apps Script and Oauth

How to build a real-time sales dashboard for E-junkie using Google Sheets and Apps Script

How to automatically create waterfall charts using Apps Script

How to automatically create funnel charts using Apps Script

Recreating Tufte’s famous temperature chart with the Google Chart API

Animated temperature chart using the Google Chart API

One way to animate a chart in Google Sheets

How to create a Data Studio Community Connector with Apps Script

Apps Script resources

Check out my apps script and apps script API repositories on GitHub.


Annual Reviews

2016 in review and a look forward to 2017

2015 in review and a look forward to 2016


Other, non-Google related articles

Makeover Monday Tableau Challenge: Theft in Japan

Human Trafficking Data Visualization: Reviz Project

Makeover Monday: Wage growth in English Football leagues

Multi-line chart with custom range banding in Tableau

Excel guru Chandoo’s AMA on Reddit

Excel tutorial: build a dynamic bump chart of the English Premier League

Suicide: The Gun Issue No One Talks About (Tableau)

Stand-up comedy routine involving Spreadsheets?

Excel-fficiency: 10 tips for boosting productivity in Excel

Refugees resettling in the US in 2015: where from, where to and who? (SQL and Tableau)

Data Analytics Resources (Excel, SQL, Tableau, Statistics, Data Viz)

Excel tutorial: Building a dynamic, animated dashboard for U.S. political data

Hang on a Median, whaddya Mean there’s no Mode function in MySQL?

Survival and retention analysis using MySQL

Creating a histogram from MailChimp data using MySQL

Deep dive into Mailchimp email data using MySQL