Do you spend hours gathering data, transforming it into the format you need, and then updating the same report that no-one ever reads? Perhaps you are so engrossed in data that you don’t know how best to use it for business and marketing decisions.
Ben Collins – Build Dashboards With Google Sheets
Learn how interactive dashboards can be created in Google Sheets. You can benefit from effective reporting and take you career to the next level.
Do you spend hours gathering data and then transforming it into the format that you need? Then, do you update the same report that no-one ever reads?
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-A high-level overview of your business. Showing KPIs, trends, and data comparisons… so that you can use that insight for smart growth.
You can create dashboards that you are able to interact with and automate using a few basic techniques.
This course will prepare you to:
You can build your dashboards using your own data
To maximize your dashboards’ impact, know what to include
You have the technical skills to manage complex dashboard projects without feeling overwhelmed
Create interactive dashboards for clients and colleagues to view the data they are interested in.
Learn and apply best practices Google SheetsTo avoid making the same mistakes as me.
Use pivot tables and advanced formulas with confidence
Apps Script can automate processes and make dashboards work for your business!
Each lesson is taught through bites-sized, Action-Oriented for 5-10 minutes-long videosThe book contains practical advice that you can use to grow your business.
I’ll be there every step of your way, showing you how to set up the sheets, the formulas, and the charts we use.
You’ll find all the data and formulas for each example, as well a final, completed template!
I’ll tell you more about the course in a moment…
Let me assure you first:
I have made almost every mistake in the book
Before I started consulting and creating courses, however, I was a forensic accountant. This involved investigating financial institutions for sanctions violations.
I can still remember the first time I created a dashboard in Excel for 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 awesome that was.
But I didn’t 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!).
I was amazed at how the team interacted with the dashboard. This is something that we address throughout this course.
Fast forward to today
Today, I offer online courses and write about data work. My focus is on how to do it.-To learn data analytics and build dashboards, please refer to the following 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 are dashboards?
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 They will assist you:
You can quickly understand the pulse of what is happening in your business
Visually summarize key metrics to help stakeholders who don’t have the time or patience to look through the data
Get new insights from your data side-By-Side
Interactive features allow you to explore the data
Automate and speed up your reporting process
Here’s how dashboards might be used:
Track traffic and social media metrics over time to show growth for your website or those of your clients.
Real-time user data analysis will help you better understand your business.-time.
To gain deeper insight into your opportunities, compare sales data from different periods, sales channels, or geographic regions.
To see where resources can be allocated, you can easily measure student attendance.
To find high- and low-level financial data, track and visualize it.-You can adjust your company’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:
✅ Get it done!-Size video lessons that will walk you through each step-By-Step by step techniques
✅ Access to all raw data files
✅ You can get copies of the final dashboard templates that you can copy as many as you wish
✅ 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 learn more Google Sheets Dashboards
You might be a data analyst, technical marketer, educator, scientist, or something in between.
Anyone who is interested in gaining new skills, such as building dashboards. It will help you to advance your career.
What are the prerequisites?
A Google account.
Access to Google Sheets.
Basic familiarity with Google Sheets spreadsheets and Excels, although the first couple dashboards were set up so that everyone is able to follow along.
Access to a Google Analytics account to get maximum benefit from the Digital Marketing dashboard lectures.
Class Curriculum
Introduction to Chapter 1
Lesson 1: Introduction (3:28)
Lesson 2: About The Author (2:20).
Lesson 3: How is the course structured? (1:22)
Lesson 4: Why Use Google Sheets To build your dashboards (4:25)
Lesson 5 – What is a dashboard and how do you use it? (6:28)
Google Sheets Chart Tool Update (3.13)
Join the Facebook Group Course
Chapter 2: Static sales dashboard
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 a Revenue Chart (2.19)
Lesson 11 – Using Pivot tables to break down sales by channel (5:21).
Lesson 12: Creating a Sales Channel Chart (2.04)
Lesson 13: More pivot table practice! (4:27)
Lesson 14 – Creating a Geographical 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)
Chapter 3: Dynamic dashboards
Lesson 21: Interactive dashboard introduction (1:38)
Lesson 22: The raw data used to create the interactive dashboard (4.56)
Lesson 23 – Named ranges in 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)
Chapter 4: Dynamic sales dashboard
Lesson 30 – Introduction to Dynamic sales dashboard (1:17).
Lesson 31: Interactive sales data validation (3:00)
Lesson 32: Dynamic key performance indicators (4:19)
Lesson 33: Dynamic revenue chart and table (5:33)
Lesson 34: Dynamic sales channel chart (3:22)
Lesson 35: Dynamic sales geographical chart (4:58).
Lesson 36: Dynamic Top 10 table (9.16)
Lesson 37: Final build for Interactive Sales Dashboard (6.44)
Chapter 5: Real Estate dashboard using Google Formulas
Lesson 38: Real estate dashboard introduction (3:42)
Lesson 39: Real estate dashboard raw data (2:20)
Lesson 40: Using Google Forms to collect information (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)
Chapter 6: Digital marketing dashboard
Lesson 47: Digital marketing dashboard introduction (5:17)
Lesson 48: Creating a dashboard settings tab (5:49)
Lesson 49: Introduction to the Google Analytics add-On (4:49)
Lesson 50: Advanced usage of the Google Analytics add-on (14.18)
Lesson 51: Data staging part 1 (14:11)
Lesson 52: Data staging part 2 (15:16)
Lesson 53: Dashboard panels for our Digital Marketing Dashboard (15:10)
Lesson 54: Adding charts and graphs to our Digital marketing dashboard (9.12)
Lesson 55: Alternative sparkline chart (4:31)
Lesson 56: Advanced formulas for adding context to our Digital Marketing Dashboard (7:27).
Lesson 57 – Add comparison formulas to our Digital Marketing dashboard (19.13).
Lesson 58: Make your Digital Marketing Dashboard professional (5:57).
Lesson 59: Fire emoji bonus! (5:45)
Chapter 7: Customizing your web dashboard with Apps script and adding social metrics
Lesson 60: Introduction of the Apps Script dashboard tricks and Social Media metrics (2:36).
Lesson 61: Importing formulas to scrape data from social media (12:10)
Lesson 62 – Import formulas for scraping Alexa web ranking data (6.02)
Lesson 63 – Introduction to the Apps Script Language (11:28).
Lesson 64: To save copy of social media data, use Apps Script (10.49)
Lesson 65: Build social media panels in our dashboard (21:57)
Lesson 66: Build The Alexa web rank panel in our dashboard (5.36)
Lesson 67 – Add a website monitoring service to our dashboard (13.39)
Lesson 68 : Add themes and icons to our dashboard with Apps Script (5.33)
Lesson 69 – Automatically distribute dashboards via Email using Apps Script (5.02)
Lesson 70: Set up triggers that will run our dashboard automatically (5.48)
Chapter 8: Data Studio
Lesson 71: Introduction Google Data Studio (8:33)
Lesson 72: Data Studio basics (20.28)
Lesson 73 – Control data using 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!
You will find templates at the beginning each module with the raw datasets as well as the solution files. These templates can be used to save you hours of time.
Here’s a sample of what you can expect with the templates:
Each chapter includes:
The raw dataset (where available)
The solution
These resources alone can save you hours of valuable time.
_x0001F4A1_ – Access to the private Facebook course group
Support is available to back up 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 to the course
Your enrollment in Build Dashboards With Google Sheets Includes lifetime access to 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 includes all future updates, upgrades, and more at no additional charge.
This is how I ensure that Build Dashboards With Google Sheets It remains an excellent long-term investment-Term investment for you and/or your business.
_x0001F4A1_ Certification of Completion
Do you want to show off your newly acquired skills and talents?
You’ll automatically get a certificate upon completing the course, which you can share or post on Linkedin.
Are you ready?
Continue reading:http://archive.is/7IUgx
Here’s what you’ll get in Ben Collins – Build Dashboards With Google Sheets
