Community Connectors: Access all your data in Google Data Studio 💥💥

Data Studio is relatively new dashboard tool from Google, launched in mid-2016. It’s a superb tool for creating professional looking reports, easily and quickly, and it connects seamlessly to other Google data sources (e.g. Analytics, AdSense, Sheets, …).

Here’s an introduction to Data Studio and a look at the more advanced features.

GitHub commit dashboard, built with the new native data Community Connector
GitHub commits dashboard, built in Data Studio using a native Data Connector

Do you work with data outside of Google’s ecosystem though?

I’ll go out on a limb here, and say, yes, most likely you do.

Perhaps you’re a digital marketing analyst looking at Facebook, Twitter, Instagram, MailChimp data (etc…) for example.

Many of us work with other web services and you want that data displayed in Data Studio. With the launch of native data Community Connectors, you can connect to your favorite web services and access data that lives outside the Google ecosystem directly!

What is a Data Studio Community Connector?

Data Studio Community Connector example
Data Studio Community Connector example with the MailChimp API (click to enlarge)

Continue reading Community Connectors: Access all your data in Google Data Studio 💥💥

Google Sheets, Apps Script and Data Studio Resources: The Ultimate List for 2019

Want tons of great Google Sheets, Apps Script and Data Studio resources in one place?

Then you’ll love this list.

These are my go-to resources when I’m building spreadsheet applications for clients or developing content for this blog. I have hundreds of bookmarks on the subject but here I’ve whittled it down to just the very best.

Feel free to suggest any other resources in the comments below!


Google Sheet Resources

Google Help Resources

Starting this list off is the official Google Sheets documentation. This guide covers everything about sheets, including all 346 formulas.

Google spreadsheets function list – all 346 of them! A good place to start when you want to find out the syntax details or how formula X works.

The Google Docs blog – the official source for product announcements, updates and tips from Google.

Forums and communities

Aka, good places to ask questions!

Google Sheets Help Forum. The place to go to get your Google Sheet questions answered. Read this getting started guide if you’re new to it. There are also forums for the other Google Docs.

Blogs

Continue reading Google Sheets, Apps Script and Data Studio Resources: The Ultimate List for 2019

Introduction to Google Data Studio: a free BI tool for small businesses

Regular readers will know of my enthusiasm for building dashboards, especially using Google apps (like this one or this how-to article).

So I was super excited in May of this year when Google launched Data Studio, a free data visualization and dashboard tool to compete against incumbent dashboard vendors Microsoft PowerBI, Tableau and Qlickview.

Here, I’m excited to share my initial impressions and show you some of the basics steps to build dashboard reports using this tool.

Continue reading Introduction to Google Data Studio: a free BI tool for small businesses