Build Dashboards With Google Sheets

Learn how to create interactive dashboards in Google Sheets. Benefit from efficient reporting and take your career to the next level.

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 give you a high-level overview of your business, showing KPIs, trends and data comparisons... so you can use that insight to grow in smart ways.


By learning some relatively simple techniques, you can create dashboards that are automated, interactive and visually appealing.

This course will set you up to:

  • Have the confidence to build your own dashboards with your own datasets
  • Know what to include in your dashboards to maximize their impact
  • Have the technical skills to manage advanced dashboard projects without feeling overwhelmed
  • Create interactive dashboards, so colleagues and clients can view the data they want to see
  • Understand and use best practices in Google Sheets, to avoid making the same mistakes I made
  • Be confident using advanced formulas and pivot tables
  • Use Apps Script to automate processes and make your dashboards work for you!

Each lesson is taught through bite-sized, action-oriented 5 - 10 minute-long videos, covering practical techniques you can apply to your own business.

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!


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.

 

I’ll tell you more about the course in a moment...

...but first let me reassure you:

I've made just about every mistake in the book


Prior to consulting and creating courses, I worked as a forensic accountant, doing investigations into sanctions violations at large financial organizations.

I remember the first time I built a dashboard in Excel at work.

After a lot of headaches and frustration, I had created a presentable dashboard that gave our team oversight of whole dataset.

The dashboard wasn’t pretty, and it probably violated dashboard best principles, but it worked. It was dynamic and I clearly remember how cool that was.

However, I had no idea what I was doing. I barely even knew what dashboards were, and I certainly didn’t know there were courses and books out there that could have saved me hours and hours (and resulted in a better end product!).

Seeing the team interact with the dashboard, I realized how valuable solid data and spreadsheet skills were -- something we address throughout this course.


Fast forward to today


Today I create online courses and write about working with data, with a particular focus on how-to articles for learning data analytics and building dashboards, using Google Sheets, Apps Script and Data Studio.

Since mid-2015, I’ve been working as a freelance spreadsheet developer, data consultant and instructor.

I’ve taught data analysis and visualization courses and workshops at General Assembly’s Washington, D.C., campus and privately for clients.

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. They'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.

Earlier this year I ran a couple of webinars, and here’s what some folks were saying about this Google Sheets dashboard training course:

Enroll now to get:

  • Actionable, bite-size video lessons that walk you step-by-step through techniques
  • Access to all the raw data files
  • Copies of the finished dashboard templates, which you can copy as many times as you like
  • Access to the private course Facebook group for Q&A
  • Certificate upon completion


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 someone 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.
 

Course Curriculum


  Next Steps
Available in days
days after you enroll

Plus, you’ll also get the following resources:

💡 Templates!


At the beginning of each module are templates with the raw datasets and solution files, available for your use, saving you hours of time.

Here’s a sample of what you can expect with the templates:

Each chapter includes:

  • The raw dataset (where required)
  • The solution

These resources alone will save you hours and hours of valuable time.


💡 Access to the private course Facebook group


Your enrollment is backed up with support.

There’s a private Facebook group for students, where you can ask questions, share your insights and knowledge, share your wins, and connect with other students.

I’ll be hanging out there to answer your questions.



💡 Lifetime access to the course


Your enrollment in Build Dashboards with Google Sheets comes with lifetime access to the course material.

That way you can take a break from the material if you’re out of town, on vacation, or just swamped for a few days.

Interruptions happen, and your course videos will ALWAYS be here for you when you’re ready. This lifetime access also includes all future updates and upgrades at no extra charge.

This is my way of ensuring that Build Dashboards with Google Sheets remains an excellent long-term investment for you and your business.


💡 Certificate of Completion


Want to show off your newly acquired skills?

You’ll automatically get a certificate upon completing the course, which you can share or post on Linkedin.

Ready to join?

 

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 14 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 here.
Do you offer Parity Purchasing Power discounts?
Yes, I want my courses to be affordable to folks overseas in developing countries, who would otherwise not be able to purchase them. How does it work? Drop me a line with proof of where you're based and which course you're interested in, and I'll be glad to offer you a PPP discount on the course.
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.
Why am I being charged VAT?
In order to comply with EU regulations, buyers in the EU will be charged VAT at checkout. This money is passed on to the relevant EU tax collection agency.
Any other questions?
Contact me here: https://www.benlcollins.com/contact/

Get started now!