Ben Collins
I’m an experienced data analytics instructor and freelance spreadsheet developer, helping businesses better understand their data through analytical insights and visualizations, including dashboards.
I work primarily with Google Sheets, Apps Script and Data Studio, and also have extensive experience with Excel, SQL and Tableau. I’ve previously taught data courses and workshops for General Assembly in Washington, D.C.
In early 2019, Google recognized me as a Google Developer Expert for G Suite Technology, one of only a small number worldwide.
Enhance your Google Sheets skills with this three course bundle, covering the entire data workflow, from dealing with raw data through to creating beautiful reports.
Here are the details of what you get in this bootcamp:
Course 1: Data Cleaning in Google Sheets
What is data cleaning and why is it important?
Best practices for working with data in Google Sheets
Formulas covering common scenarios when working with data in Google Sheets
Tips and tricks, such as shortcut keys, to make your workflow more efficient
Professional techniques for creating cleaned, orderly data sets for your analysis
Two in-depth case studies that show all these techniques together, in the wider context of a real-world problem
Course 2: Data Analysis with Google Sheets
Understand and describe what your data tells you
Predict what things might look like in the future
Understand your customers to better serve them
Discover what factors affect your business
Best practices for doing all of this…and much, much more!
TOPICS INCLUDE: Data Analysis framework, measuring data, hypothesis testing, correlation, linear regression, time series analysis, customer lifetime value, churn, retention and cohort analysis
Course 3: Build Dashboards with Google Sheets
Understand what dashboards are and why they’re so valuable
Have the confidence to build your own dashboards with your own datasets, in Google Sheets
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!
Review:
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.
