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.
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:
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!
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.
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 previously taught data courses and workshops for General Assembly in Washington, D.C.