Learn how to create data-driven decisions in Google Sheets Your business can be transformed Learn how to use Google Sheets To access data-driven decisions. This course will help you achieve:
Describe and understand the data you have
Ben Collins – Data Analysis with Google Sheets
Learn how to create data-driven decisions in Google Sheets Your business can be transformed
Are you drowning in dataHowever, it should not be used to make better decisions.
Are you a small-business owner and would you like to expand your business? Use your data to inform and improve your strategy?
Has your business Migrated from Excel to Google SheetsAre you looking to improve your skills?
Learn how to use Google Sheets To access data-driven decisions.
This course will teach you how to:
- Describe and understand the data you have
- You can predict what the future will look like
- Understanding your customers will help you better serve them
- Learn what factors can affect your business
- These are the best practices…
- … and much, much more!
Your data should be used instead “gut” You can feel confident in putting your business on a good track.
Every lesson is presented in bites-Action!-Oriented 5-10 minutes-These videos are long and cover many practical methods that you can implement in your own business.
Working with Real-World examples, including sample datasets from different industries such as sales, marketing and real-You’ll be able to learn how to make the most out of your business data, including social media and estate.
Now you can learn data analysis, using the same techniques and best practices I’ve spent the past 15 years learning.
This course will teach you the key foundational techniques in data analysis, even if you’re new to this topic.
I developed this course with a group of people.-Drive the course. Here’s what they had to say:
Are you drowning in dataHowever, it should not be used to make better decisions.
Are you a small-business owner and would you like to expand your business? Use your data to inform and improve your strategy?
Has your business Migrated from Excel to Google SheetsAre you looking to improve your skills?
Learn how to use Google Sheets To access data-driven decisions.
This course will teach you how to:
- Describe and understand the data you have
- You can predict what the future will look like
- Understanding your customers will help you better serve them
- Learn what factors can affect your business
- These are the best practices…
- … and much, much more!
Your data should be used instead “gut” You can feel confident in putting your business on a good track.
Every lesson is presented in bites-Action, in a sizeable package-Oriented 5-10 minutes-These videos are long and cover many practical methods that you can implement in your own business.
Working with Real-World examples, including sample datasets from different industries such as sales, marketing and real-You’ll be able to learn how to make the most out of your business data, including social media and estate.
Now you can learn data analysis, using the same techniques and best practices I’ve spent the past 15 years learning.
This course will teach you the key foundational techniques in data analysis, even if you’re new to this topic.
As part of my course development, I had a number of people test it.-Drive the course. Here’s what they had to say:
“The idea of using an app that I was familiar with was exciting to me. with, Google SheetsTo complete the data analysis that seemed so difficult and foreign previously.
People like me, who do not have data science backgrounds, want to play quickly and easily. with This course would be of great benefit to data.
This course is amazing!”
– Geordie Frost, Bang Digital
“I wanted more information about what I could do.” with Google Sheets Get an idea of how your agency could benefit. My SEO company uses Google We use almost all of it for project management, etc.
I take every course. Ben Collins. I am always trying to improve my data skills. You can help me understand my data. Data you can make correct decisions about your business and *almost* guarantee success.“
Devin Schumacher is The Search Marketing Company
“Weekly I am faced with datasets that I must analyse and present insights. I will be able to gain more insight from my data with this new knowledge.
Three of these I’ve done before. BenI had taken a number of the previous courses and found them extremely useful. So, I decided it was worth signing up for this course. “analytical course”. I was right.
– Jaume Fàbrega, Trekksoft
I’ll tell you more about the course in a moment…
But first, let me assure you:
I have made almost every mistake in the book
Prior to creating and consulting courses, I was a forensic accountant. This involved investigating financial institutions for sanctions violations.
Excel and SQL were used to manage project data, hundreds of thousands of transactions which we would analyse for the legal team.
The unique identifier column of the Excel master Excel dataset was not visible to me at one point. These unique IDs have been removed from all sorts and filters.
I panicked when I realized that the ID numbers were completely out of sync. with The data was not available for reference.
(Thankfully, I was able to create a new unique identifier based on the data, and use that to retrieve the IDs from an older copy of the dataset, where they weren’t messed up.)
The valuable lesson I learned was to be careful with We discuss data management and maintaining a good audit trail throughout the course.
It was also around this time that I realized how valuable solid data and spreadsheet skills were, and I’ve taken every opportunity to further my skills since then.
Fast forward to today
I am a writer and creator of online courses. with data, with Particular attention is given to how-Learn data analytics and create dashboards with these articles Google SheetsApps Script Data Studio.
Seit Mitte-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.
The missing piece
This is my third premium course in data analysis.
It bridges the gap between the data cleansing course and dashboard reporting courses that hundreds of students have taken to learn the entire data analysis process.
Earlier this year I ran a couple of webinars about the QUERY function (which features in this data analysis course), and here’s what some folks were saying about my other Google Sheets Training courses
Josh wanted to be data analyst. To help his career grow, he took a Data Analysis course.
Josh was one my first students. Data Analysis General Assembly class that I taught in Washington, DC. (In that course I taught data analysis basics with Excel was not my first choice, but the topics were very similar to what I teach now. Google Sheets.)
He has a masters in predictive analytics and is now a fully-fledged data scientist, just three years after his graduation. Wow!
Anyway, I won’t say anymore, I’ll let Josh tell his story.
About the course
You can do it if you…
- Description and understanding of your data
- Check your gut and confirm or disprove the information your data is telling.
- Learn how to convince your boss that your ideas are supported with rigorous results
- Based on your data, predict outcomes
- You can understand trends in your data over time so that you can identify successful events
- Better understand your customers to serve them better
…then Data Analysis with Google Sheets This is for YOU.
Inside this course I share all the knowledge I’ve built up over the past 15 years working with data in spreadsheets.
I’ve packaged it all into a series of simple, bite-Complete size video lessons with Google These sheet templates are easy to follow.
Get:
✅ Take-Action, Actionable Bite-Video lessons in size on key data analysis topics
✅ Follow along with all raw datasets
✅ All solution files are available for your use
✅ Access to the private course Facebook group for Q&A
✅ Certificate upon completion
Ok data geeks! These are the details of every module in this class.
_x0001F4DA_ 7 modules | 45 videos | 20 templates
Each video focuses on a specific topic in data analysis. Google SheetsThis allows you to easily refer to them in the future. You can view them in any order that you want, spread them out over several weeks or months, and even binge-watch them all at once, if you so desire.
Module 1 Introduction
- What is data analytics?
- An approach to data analysis
- Here are the best practices Google Sheets
- Glossary Data Terms
- The best keyboard shortcuts guide Google SheetsFor Macs, Chromebooks, and PCs
Module 2: Describing your data — Learn to:
- Analyze exploratory data
- Find out the key measures in a dataset
- Share these findings with colleagues
Module 3: What is the difference between your data and others? Learn how to:
- Test, test, test!
- Formulate and test hypotheses about your data…
- …so that you can confidently talk about your data (and know what you’re saying is statistically significant)
- To move beyond the initial results, run several statistical tests. “gut feel” Approach to data
Module 4: Find relationships in your data — Learn how to:
- Find out if two variables have a correlation
- A variety of correlation metrics can be calculated
- Avoid common mistakes
Module 5: Predicting values — Learn to:
- You can build regression models to predict based on the data you have.
- Test your models so you’ll know if they’re any good
- Create a spreadsheet interface to run your regression model in background
Module 6: Time Series Analysis — Learn how to:
- To understand the underlying trends, you can smooth your time series data in a variety of ways
- Use the SOLVER addition-To optimize models
- To find the best model, test it
Module 7: Customer Analysis — Learn to:
- Calculate the customer’s lifetime value to find your most valuable clients
- Calculate your retention and churn to determine which customers go away.
- Draw retention curves to present results to your colleagues/bosses/clients
Plus, you’ll also get the following additional resources:
_x0001F4A1_ Templates!
Templates are located at the beginning of every module. with You can save time by downloading the solution files and raw datasets.
Here’s a sample of what you can expect with The templates:
Each chapter has three templates:
- The raw dataset
- The solution
- Summary reports featuring Google Slides, Google Examples of Docs and Emails
These resources will save you hours of valuable time.
_x0001F4A1_ Get access to the private Facebook course group
Your enrollment is protected 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.
_x0001F4A1_ Access to the course for life
Your enrollment in Data Analysis with Google Sheets This is with Access to the course material 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 extra cost.
This is how I ensure that Data Analysis with Google Sheets It remains an excellent choice for the long term-Your business and your term investment.
_x0001F4A1_ Certificate 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?
Here’s what you’ll get in Ben Collins – Data Analysis with Google Sheets
Course Features
- Lectures 1
- Quizzes 0
- Duration Lifetime access
- Skill level All levels
- Language English
- Students 0
- Assessments Yes
