Build Dashboards With Google Sheets and Data Studio
Everything you need to know about building beautiful business and marketing dashboards to help you make key decisions in real-time.
Enroll in Course for $149
Do you spend hours collecting data, wrestling it into the format you need and then updating the same report that no one ever reads?
Or maybe you’re neck deep in data but don’t know how to use it to make sound business and marketing decisions?
Dashboards are fantastic tools that give you a high-level view of your business, showing KPIs, trends and data comparisons… so you can use that insight to grow your company in smart ways.
By learning some relatively simple techniques, you can create dashboards that are automated, interactive and visually appealing. They’ll get people’s attention and wow your colleagues and bosses.
This course covers everything you need to know about building beautiful business dashboards with Google Sheets and Google Data Studio.
What are dashboards?
Dashboards are high-level summaries of your organization’s data, displayed side-by-side in a single page to highlight the key metrics and trends at a glance. It’ll help you:
Quickly understand the pulse of your business
Visually summarize key metrics for stakeholders who don’t have time to review the data
See new insights with your data side-by-side
Explore the data with interactive features
Speed up and automate your reporting pipeline
Here’s how you might use dashboards:
Show growth of your website or clients’ websites, by tracking traffic and social media metrics over time.
Understand your business better by collecting and analyzing user data in real-time.
Compare sales data across different time periods, sales channels or geographic regions to get deeper insights into your opportunities.
Measure student attendance and performance to easily see where to allocate resources.
Track and visualize financial data to uncover high- and low-performing areas of your company, so you can make adjustments going forward.
What this course will do for you:
This comprehensive course will teach all the key techniques for building beautiful, interactive dashboards in Google Sheet and Google’s new dashboard tool, Data Studio.
The core curriculum is five dashboards that we build together from the ground up. We’ll also take a foray into the world of advanced formulas to scrape social media data and then use Apps Script to make our dashboard work for us!
The final section of the course is a deep dive into Google’s new dashboard tool, Data Studio, which is a super quick way to create information-rich reports.
I’ll be with you every step of the way, showing you the sheet setup, the formulas and the charts we use. For each example you’ll have all the necessary raw data and formulas, as well as a final, finished template!
What you get with this course:
Over 9 hours of video tutorials that walk you step-by-step through techniques for building dashboards.
Access to all the raw data files, copies of the formulas and links to online documentation and other great resources.
Copies of the finished dashboard templates for the five dashboard examples and the one Data Studio report. You’ll be able to make your own copies for editing and reverse engineering as many times as you like.
Membership to our dedicated Facebook group, where you can post questions and get answers, share insights and interact with other students.
All the videos are online and you’ll have 24/7 access for life.
Who is this course for?
Anyone who works with data in Google Sheets.
Someone who is curious to learn more about Google Sheets and dashboards.
Maybe you’re a data analyst, a technical marketer, an educator, a scientist or anything in between.
Anyone who wants to add new a skill, building dashboards, that will help you advance your career.
What are the prerequisites?
A Google account.
Access to Google Sheets.
Basic familiarity with Google Sheets and spreadsheets, although the first couple of dashboards are set up so that everyone should be able to follow along.
Access to a Google Analytics account to get the most out of the Digital Marketing dashboard lectures.
Access to Google Data Studio.
Everyone talks about data culture in companies, but only a few know how to do it. Good dashboards are a great first step to democratize access to data in a simple way, and this course will definitely change the way you see your data today.
– Gabriel O.
This course is a fantastic way to discover how to build dashboards. Ben takes you step by step through what you need to do and his approach is well thought out and organised. The information covers the basics and introduces more complex subjects in a simple and easy to follow format.
– Marilyn C.
I’d recommend this course for anyone trying to make great dashboards in Google Sheets. Ben is a great teacher and he explains everything very thoroughly. Five stars from me.
– Jakob R.
Enroll in Course for $149
Who is teaching the course?
Ben Collins is an experienced data analytics instructor and freelance spreadsheet developer, helping businesses better understand their data through analytical insights and visualizations, including dashboards. He works primarily with Google Sheets, Apps Script and Data Studio, and also has extensive experience with Excel, SQL and Tableau. He teaches data workshops for General Assembly in Washington, D.C.
Chapter 1: Course Introduction
Preview Lesson 1: Introduction (3:28)
Preview Lesson 2: About the Author (2:20)
Preview Lesson 3: How is this course structured? (1:22)
Start Lesson 4: Why use Google Sheets to build your dashboards? (4:25)
Start Lesson 5: What is a dashboard? (6:28)
Start Join the course Facebook Group
Chapter 2: Static Sales Dashboard
Preview Lesson 6: Introduction to the Static Sales Dashboard (1:20)
Preview Lesson 7: The raw data (8:34)
Start Lesson 8: Setting up the Summary Data Table (4:00)
Start Lesson 9: Introduction to Pivot Tables (7:57)
Start Lesson 10: Creating the Revenue Chart (5:21)
Start Lesson 11: Using Pivot Tables to breakdown Sales by Channel (5:21)
Start Lesson 12: Creating the Sales Channel Chart (3:16)
Start Lesson 13: More pivot table practice! (4:39)
Start Lesson 14: Creating a Geographic chart to show sales by US State (5:28)
Start Lesson 15: Advanced features of pivot tables to find the Top 10 products (5:07)
Start Lesson 16: Building our Sales Dashboard Part 1 (9:47)
Start Lesson 17: Building our Sales Dashboard Part 2 (6:22)
Start Lesson 18: Building our Sales Dashboard Part 3 (9:32)
Start Lesson 19: Building our Sales Dashboard Part 4 (5:40)
Start Lesson 20: Sharing your dashboard (10:14)
Chapter 3: Dynamic dashboards
Preview Lesson 21: Interactive dashboard introduction (1:38)
Start Lesson 22: The raw data for the interactive dashboard (4:56)
Preview Lesson 23: Named ranges in Google Sheets (alternative method to lesson 23) (4:38)
Start Lesson 24: Interactive dashboard data validation (4:57)
Start Lesson 25: Interactive dashboard staging tables 1 (10:24)
Start Lesson 26: Interactive dashboard staging tables 2 (10:59)
Start Lesson 27: Dynamic charts (4:44)
Start Lesson 28: Interactive dashboard build 1 (15:24)
Start Lesson 29: Interactive dashboard build 2 (6:27)
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course — you decide when you start and when you finish.
Will I get copies of the finished dashboards?
Yes! All the raw data templates and the final, finished dashboard templates are provided, so you can download your own copies. The raw data file links are in the lectures titled RAW DATA and the final dashboard links are at the end of each chapter.
How is this course different from other online courses?
This course is dashboard-focused and entirely practical. We start building dashboards immediately and concepts are taught through practical examples.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you’ll have unlimited access to this course for as long as you like — across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.
What if I discover a mistake or want to comment on the material?
Great, I’d really love to hear from you. Drop me a line at [email protected]
Can you provide an invoice for my company?
Yes, of course! After the purchase is complete, please forward me your receipt and the name/address you’d like to see on the invoice and I’ll send one right back to you.
Any other questions?
Contact me here: http://www.benlcollins.com/contact/
Get started now!
Enroll in Course for $149