Are you a data hound who spends hours assembling the data and then updating it in a format that isn’t read by anyone? Perhaps you are so engrossed in data that you don’t know what to do with it?
Ben Collins – Build Dashboards With Google Sheets
Create interactive dashboards with this tutorial Google Sheets. You can benefit from effective reporting to take your career to new heights.
Are you a data collector who spends hours assembling the data and formatting it in a format that is useful to you, then updating the report that no one ever sees?
Perhaps you are buried in data and don’t know how it can be used to make good business and marketing decisions.
Dashboards Give you a high level of satisfaction-You can get a high-level overview of the business by showing KPIs and trends as well as data comparisons… to help you grow smarter.
You can make dashboards that are interactive, automated, and visually appealing by using a few easy techniques.
This course will prepare you to:
- You can build your dashboards using your own data
- To maximize your impact, know what you should include in your dashboards
- Are you able to manage dashboard projects with technical expertise without feeling overwhelmed?
- Interactive dashboards can be created so clients and colleagues can see the data they need
- Learn and implement best practices Google SheetsTo avoid repeating the mistakes that I made
- Use advanced formulas and pivot tables with confidence
- Apps Script allows you to automate your processes and make your dashboards work better for you.
Every lesson is presented in bites-sized, Take action-Oriented 5-10 minutes-long videosThis book covers practical tips that you can use in your business.
I will be there with you every step of this process, showing you how to setup sheets and formulas as well as the charts we use.
Each example will include all necessary data and formulas as well as a final template.
I’ll tell you more about the course in a moment…
But first, let me assure you:
I’ve made every mistake in this book.
Before consulting and creating courses, my previous job was as a forensic accountant. I did investigations into financial institutions that had sanctioned large amounts of people.
I can still remember the first Excel dashboard I created 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 still remember how amazing that was.
However, I did not know 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!).
As I watched the team interact with it, I was struck by the importance of spreadsheet and data skills. This is something that we will address in this course.
Now, fast forward to today
Today, I offer online courses and write about data work. My focus is on how to do it.-Learn data analytics and create dashboards with these articles Google SheetsApps Script, 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 is a dashboard?
Dashboards Are high-Side-by-side summaries of the data in your organization.-By-Side-by-side on a single page to highlight key metrics and trends at glance These will help you:
- You can quickly understand the pulse and health of your business
- Visually summarize key metrics to help stakeholders who don’t have time or the ability to read through the data
- Your data side can give you new insight-By-Side
- Explore the data using interactive features
- Automate and accelerate your reporting pipeline
Here’s how dashboards might be used.
- You can track traffic and social media metrics over time to show growth on your website or the websites of clients.
- Real-time user data analysis will help you better understand your business.-time.
- You can compare sales data over different time periods, sales channels, or geographical regions to gain deeper insight into your potential opportunities.
- To easily determine where resources should be allocated, measure student attendance and performance.
- To find high- and low-level financial data, track and visualize it.-You can adjust your business’s performance areas to make it more efficient.
Earlier this year I ran a couple of webinars, and here’s what some folks were saying about this Google Sheets dashboard training course:
Register now to receive:
✅ Take-Action, Actionable Bite-Size video lessons that will walk you through each step-By-Step through techniques
✅ All raw data files available for access
✅ The dashboard templates are available in multiple copies, which you can use as many as you’d like.
✅ Access to the private course Facebook group for Q&A
✅ Certificate upon completion
Who is this course for
- Anyone who works in data Google Sheets.
- Person who is curious to find out more Google Sheets Dashboards
- You might be a data analyst or a technical marketer, educator, scientist, or something in between.
- Anyone who wishes to improve their career by learning how to build dashboards.
What are the prerequisites for success?
- A Google account.
- Access to Google Sheets.
- Basic familiarity Google Sheets spreadsheets and Excels, but the first few dashboards have been set up so that everyone can follow along.
- Access to a Google Analytics account to get maximum benefit from the Digital Marketing Dashboard lectures.
Class Curriculum
- Lesson 1: Introduction (3:28)
- Lesson 2: About The Author (2:20).
- Lesson 3 – How is this course structured (1:22)
- Lesson 4 – Why Use Google Sheets To build your dashboards (4:25)
- Lesson 5 – What is a Dashboard? (6:28)
- Google Sheets Chart Tool Update (3.13)
- Join the Facebook Group Course
- Lesson 6: Introduction To The Static Sales Dashboard (1.20)
- Lesson 7: The raw data (8.34)
- Lesson 8: Setting Up the Summary Data Table (4.00)
- Lesson 9 – Introduction to Pivot Tables (7.56)
- Lesson 10 – Creating the Revenue Chart (2.19)
- Lesson 11 – Using Pivot tables to break down sales by channel (5:21)
- Lesson 12: How to Create the Sales Channel Chart (2.04)
- Lesson 13: More pivot table practice! (4:27)
- Lesson 14: How to create a Geographic Chart to show US State Sales (3:18).
- Lesson 15 – Advanced features of pivot tables for finding the Top 10 Products (4:54).
- Lesson 16: Building our Sales Dashboard Part 1 (9:46)
- Lesson 17: Building our Sales Dashboard Part 2 (2:30)
- Lesson 18: Building our Sales Dashboard Part 3 (9:13)
- Lesson 19: Building our Sales Dashboard Part 4 (3:39)
- Lesson 20: Sharing your dashboard (9:21)
- Lesson 21: Interactive dashboard introduction (1:38)
- Lesson 22: The raw data used to create the interactive dashboard (4.56).
- Lesson 23 – Named ranges Google Sheets (alternative method for lesson 23) (4.38)
- Lesson 24: Interactive dashboard data validation (4:57)
- Lesson 25: Interactive Dashboard Staging Tables 1 (10:24).
- Lesson 26: Interactive Dashboard Staging Tables 2 (10:59).
- Lesson 27 – Dynamic charts (4.42)
- Lesson 28: Interactive dashboard build 1 (15:24)
- Lesson 29: Interactive dashboard build 2 (6:27)
- Lesson 30: Introduction to Dynamic Sales Dashboard (1:17).
- Lesson 31: Interactive sales data validation (3:00)
- Lesson 32: Dynamic Key Performance Indiators (4:19).
- Lesson 33: Dynamic revenues table and chart (5.33)
- Lesson 34: Dynamic sales channel chart (3:22)
- Lesson 35: Dynamic geographic sales chart (4.58)
- Lesson 36: Dynamic Top 10 table (9.16)
- Lesson 37: Interactive sales dashboard final construction (6:44)
- Lesson 38: Real estate dashboard introduction (3:42)
- Lesson 39: Real estate dashboard raw data (2:20)
- Lesson 40: Using Google Formulas for collecting data (8:42).
- Lesson 41: Real estate sales funnel chart (7:42)
- Lesson 42: Agent performance stacked bar chart (6.36)
- Lesson 43: Real estate financial charts (11:38)
- Lesson 44: Real-estate detailed agent breakdown charts (10.13)
- Lesson 45: Real estate dashboard build 1 (11:59)
- Lesson 46: Real estate dashboard build 2 (6:08)
- Lesson 47: Digital marketing dashboard introduction (5:17)
- Lesson 48: Creating a dashboard settings tab (5:49)
- Lesson 49: Introducing The Google Analytics add-On (4:49).
- Lesson 50: Advanced usage of the Google Analytics add-(14.18)
- Lesson 51: Data staging part 1 (14:11)
- Lesson 52: Data staging part 2 (15:16)
- Lesson 53: Dashboard panels, sparklines and our Digital Marketing dashboard (15.10)
- Lesson 54: Add charts to our Digital Marketing Dashboard (9:12).
- Lesson 55: Alternative sparkline chart (4:31)
- Lesson 56 – Advanced formulas to enhance our Digital marketing dashboard (7.27)
- Lesson 57: Use comparison formulas to analyze our Digital Marketing Dashboard (19:13).
- Lesson 58 – Make the Digital Marketing Dashboard look professional (5.57)
- Lesson 59: Fire emoji bonus! (5:45)
- Lesson 60: Social Media metrics and Apps script dashboard tricks (2.36)
- Lesson 61: Importing formulas to scrape data from social media (12:10)
- Lesson 62: Use import formulas to get Alexa web ranking data (6.02).
- Lesson 63 – Introduction to the Apps Script language (11.28)
- Lesson 64: Save copy of social media data using Apps Script (10:49).
- Lesson 65: Build social media panels in our dashboard (21:57)
- Lesson 66: Build Our dashboard shows the Alexa web rank panel (5:36).
- Lesson 67: Add website uptime monitors to your dashboard (13:39).
- Lesson 68 – Add themes to our dashboard using Apps Script (5.33)
- Lesson 69 – Automatically distribute dashboards via Email using AppsScript (5:02).
- Lesson 70: Set up triggers so that our dashboard runs automatically (5:48).
- Lesson 71 – Introduction to Google Data Studio (8:33)
- Lesson 72: Data Studio basics (20:28).
- Lesson 73 – Control data with filters in Data Studio (6.59)
- Lesson 74 – Data Sources and Calculated fields in Data Studio (12.42).
- Lesson 75: Mobile Reporting dashboard example in Data Studio (15:33)
Plus, you’ll also get the following resources:
_x0001F4A1_ Templates!
Templates with solution files and raw datasets are included at the beginning of every module. This saves you time and can be used to save hours.
Here’s a sample of what you can expect with the templates:
Each chapter includes:
- The raw data (where applicable)
- The solution
These resources will save you hours of valuable time.
Access to private course Facebook group _x0001F4A1_
You will be supported throughout your enrollment.
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.
_x0001F4A1_ Unlimited access for life to the course
Your enrollment in Build Dashboards With Google Sheets Access to all course materials for life.
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. You will also receive all future updates and upgrade at no additional charge.
This is my way to ensure that Build Dashboards With Google Sheets It remains an excellent choice for the long term-Term investment is a good option for your business and you.
_x0001F4A1_ Certification of Completion
You want to display your newly acquired skills?
You’ll automatically get a certificate upon completing the course, which you can share or post on Linkedin.
Are you interested in joining?
Learn morehttp://archive.is/7IUgx
Here’s what you’ll get in Ben Collins – Build Dashboards With Google Sheets
Course Features
- Lectures 1
- Quizzes 0
- Duration Lifetime access
- Skill level All levels
- Language English
- Students 125
- Assessments Yes
