0
0
banner

Ben Collins – Build Dashboards With Google Sheets

img

Ben Collins – Build Dashboards With Google Sheets

Ben Collins - 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!

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.

Class Curriculum

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

    Google Sheets Chart Tool Update (3:13)

  • 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:56)

  • Start

    Lesson 10: Creating the Revenue Chart (2:19)

  • Start

    Lesson 11: Using Pivot Tables to breakdown Sales by Channel (5:21)

  • Start

    Lesson 12: Creating the Sales Channel Chart (2:04)

  • Start

    Lesson 13: More pivot table practice! (4:27)

  • Start

    Lesson 14: Creating a Geographic chart to show sales by US State (3:18)

  • Start

    Lesson 15: Advanced features of pivot tables to find the Top 10 products (4:54)

  • Start

    Lesson 16: Building our Sales Dashboard Part 1 (9:46)

  • Start

    Lesson 17: Building our Sales Dashboard Part 2 (2:30)

  • Start

    Lesson 18: Building our Sales Dashboard Part 3 (9:13)

  • Start

    Lesson 19: Building our Sales Dashboard Part 4 (3:39)

  • Start

    Lesson 20: Sharing your dashboard (9:21)

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:42)

  • Start

    Lesson 28: Interactive dashboard build 1 (15:24)

  • Start

    Lesson 29: Interactive dashboard build 2 (6:27)

 

Chapter 4: Dynamic Sales Dashboard
  • Preview

    Lesson 30: Dynamic sales dashboard introduction (1:17)

  • Start

    Lesson 31: Interactive sales data validation (3:00)

  • Start

    Lesson 32: Dynamic Key Performance Indicators (4:19)

  • Start

    Lesson 33: Dynamic revenue table and chart (5:33)

  • Start

    Lesson 34: Dynamic sales channel chart (3:22)

  • Start

    Lesson 35: Dynamic sales geographic chart (4:58)

  • Start

    Lesson 36: Dynamic Top 10 table (9:16)

  • Start

    Lesson 37: Interactive sales dashboard final build (6:44)

Chapter 5: Real Estate dashboard using Google Forms
  • Preview

    Lesson 38: Real estate dashboard introduction (3:42)

  • Start

    Lesson 39: Real estate dashboard raw data (2:20)

  • Start

    Lesson 40: Using Google Forms to collect data (8:42)

  • Start

    Lesson 41: Real estate sales funnel chart (7:42)

  • Preview

    Lesson 42: Agent Performance stacked bar chart (6:36)

  • Start

    Lesson 43: Real estate financial charts (11:38)

  • Start

    Lesson 44: Real estate detailed agent breakdown charts (10:13)

  • Start

    Lesson 45: Real estate dashboard build 1 (11:59)

  • Start

    Lesson 46: Real estate dashboard build 2 (6:08)

Chapter 6: Digital marketing dashboard
  • Preview

    Lesson 47: Digital marketing dashboard introduction (5:17)

  • Start

    Lesson 48: Creating a dashboard settings tab (5:49)

  • Start

    Lesson 49: Introducing the Google Analytics add-on (4:49)

  • Start

    Lesson 50: Advanced use of the Google Analytics add-on (14:18)

  • Start

    Lesson 51: Data staging part 1 (14:11)

  • Start

    Lesson 52: Data staging part 2 (15:16)

  • Start

    Lesson 53: Dashboard panels and sparklines for our Digital Marketing dashboard (15:10)

  • Start

    Lesson 54: Adding charts to our Digital marketing dashboard (9:12)

  • Start

    Lesson 55: Alternative sparkline chart (4:31)

  • Start

    Lesson 56: Advanced formulas to add context to our Digital marketing dashboard (7:27)

  • Start

    Lesson 57: Add comparison formulas for analysis to our Digital Marketing dashboard (19:13)

  • Start

    Lesson 58: Format the Digital Marketing dashboard to make it look professional (5:57)

  • Start

    Lesson 59: Fire emoji bonus! (5:45)

Chapter 7: Adding social metrics and customizing web dashboard with Apps Script
Get immediately download Ben Collins – Build Dashboards With Google Sheets
  • Preview

    Lesson 60: Introduction to the Social Media metrics and Apps Script dashboard tricks (2:36)

  • Start

    Lesson 61: Import formulas to scrape social media data (12:10)

  • Start

    Lesson 62: Import formulas to scrape Alexa web ranking data (6:02)

  • Preview

    Lesson 63: Introduction to the Apps Script language (11:28)

  • Start

    Lesson 64: Use Apps Script to save copy of social media data (10:49)

  • Start

    Lesson 65: Build social media panels in our dashboard (21:57)

  • Start

    Lesson 66: Build the Alexa web ranking panel in our dashboard (5:36)

  • Start

    Lesson 67: Add a website uptime monitor to our dashboard (13:39)

  • Start

    Lesson 68: Add themes to our dashboard with Apps Script (5:33)

  • Start

    Lesson 69: Automatically distribute dashboards via email using Apps Script (5:02)

  • Start

    Lesson 70: Set up triggers to run our dashboard automatically (5:48)

Get immediately download Ben Collins – Build Dashboards With Google Sheets

Chapter 8: Data Studio
  • Preview

    Lesson 71: Introduction to Google Data Studio (8:33)

  • Start

    Lesson 72: The basics of Data Studio (20:28)

  • Start

    Lesson 73: Control data using filters in Data Studio (6:59)

  • Start

    Lesson 74: Data Sources and Calculated Fields in Data Studio (12:42)

  • Start

    Lesson 75: Mobile Reporting dashboard example in Data Studio (15:33)

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?

 Get immediately download Ben Collins – Build Dashboards With Google Sheets

Read more: http://archive.is/7IUgx

Here’s What You’ll Get in Build Dashboards With Google Sheets

Build Dashboards With Google Sheets and Data Studio proof

– Download Sample files “Ben Collins – Build Dashboards With Google Sheets”

Course Requirement: Ben Collins – Build Dashboards With Google Sheets
Real Value: $199.0000
One time cost: USD47.0000

Frequently Asked Questions For “Ben Collins – Build Dashboards With Google Sheets”

How to make payment for “Ben Collins – Build Dashboards With Google Sheets” ?

  • Please add to cart on this page and go to checkout page. You can also add as many other products as you like and make a one-time payment.
  • We accept several type of Stripe payments such as Visa, Mastercard, American Express, Discover, Diners Club, Google Pay, Apple Pay and JCB, payments from customers worldwide. Paypal & Bitcoin please contact us.
  • We strongly recommend our customers to make a payment through Stripe & Paypal . Because it is a safest and super security for you as well as for us.

Is it safe?

  • 100% Secure Checkout Privacy Policy
  • Encryption of sensitive data and communication.
  • All card numbers are encrypted at rest with AES-256 and transmitting card numbers runs in a separate hosting environment, and doesn’t share or save any info.

How can we deliver you the course?

How long do I have access to the course?

How to download “Ben Collins – Build Dashboards With Google Sheets” ?

  • Enjoy “Ben Collins – Build Dashboards With Google Sheets” in your account page.
  • Download only one file at a time. Sometimes doing all of the files at once will lead to them all freezing.
  • Also, please do not attempt to download to a mobile device. These should be saved to a computer and then synced to devices such as phones and tablets.
  • You can also learn online instead of downloading, but we encourage you to download for better results and viewing quality during your learn. Lastly, download times are much quicker in the mornings, before noon, Pacific time. during download make sure your device is not sleeping off screen.

What is the refund policy “Ben Collins – Build Dashboards With Google Sheets”?

  • We’ll Bear The Risk, You’ll Take The Results…
  • Within 30 days of purchased |Ben Collins – Build Dashboards With Google Sheets  |, if you don’t get anything out of the program, or if your order has any problem, or maybe for some reason, you just don’t like the way it is. Please contact us and we will do our best to assist. Thank you for your understanding.

Have More Questions?

Our support staff is the best by far! please do not hesitate to contact us at email: [email protected] and we’ll be happy to help!

You want to get “Ben Collins – Build Dashboards With Google Sheets” now right?!!!

YES! I’M READY TO ADD TO CART BUTTON ON THIS PAGE NOW !

Original price was: $199.00.Current price is: $47.00.

Get Ben Collins - Build Dashboards With Google Sheets immediately when you secure your purchase by clicking on the order button on this page 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? File Size: 1.5 GB...

Purchase this product now and earn 47 Points!
10 Points = $1

Check Out the best coupon today code:

HAPPYDAY

Related Products

Sale! Ben Collins – Data Analysis with Google Sheets
buy now
Business and Marketing
Original price was: $199.00.Current price is: $47.00.

Ben Collins – Data Analysis with Google Sheets

In Business and Marketing

Sale! Ben Collins – Google Sheets Training Bundle
buy now
Business and Marketing
Original price was: $249.00.Current price is: $57.00.

Ben Collins – Google Sheets Training Bundle

In Business and Marketing

Sale!
buy now
Business and Marketing
Original price was: $89.00.Current price is: $22.00.

Ben Collins – Data Cleaning and Pivot Tables in Google Sheets

In Business and Marketing