Here’s What’s Included:
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.
Proof: