decisions is Learn how to make data-driven in Google Sheets and transform your business Are you drowning in data, but not using it to make better decisions?.
Learn how to make data-driven decisions in Google Sheets and transform your business Are you drowning in data, but not using it to make better decisions?
you is Do run a small business and want to use your data to inform your strategy?.
Do you run a small business and want to use your data to inform your strategy?
Ben Collins - is Data Analysis with Google Sheets course with special price just for you: $199 $43 DOWNLOAD INSTANTLY.
Ben Collins - Data Analysis with Google Sheets course with special price just for you: $199 $43 DOWNLOAD INSTANTLY
ALL CONTENTS OF THE COURSE BELOW! is PLEASE CHECK.
PLEASE CHECK ALL CONTENTS OF THE COURSE BELOW!
you is Do run a small business and want to use your data to inform your strategy?.
Do you run a small business and want to use your data to inform your strategy?
your business is Has migrated from Excel to Google Sheets, and you're looking to further your skills?.
Has your business migrated from Excel to Google Sheets, and you're looking to further your skills?
Google Sheets is Learn how to use to make data-driven decisions..
Learn how to use Google Sheets to make data-driven decisions.
This course is will set you up to: 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!.
This course will set you up to: 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!
your data is Use instead of "gut" feel to put your business on the right path..
Use your data instead of "gut" feel to put your business on the right path.
Each lesson is is taught through bite-sized, action-oriented 5 - 10 minute-long videos, covering practical techniques you can apply to your own business..
Each lesson is taught through bite-sized, action-oriented 5 - 10 minute-long videos, covering practical techniques you can apply to your own business.
Ben Collins - is Get Data Analysis with Google Sheets download Working with real-world examples, including example datasets from industries like sales, marketing, real-estate and social media, you'll learn how to make the most of your business data today..
Get Ben Collins - Data Analysis with Google Sheets download Working with real-world examples, including example datasets from industries like sales, marketing, real-estate and social media, you'll learn how to make the most of your business data today.
you is Now can learn data analysis, using the same techniques and best practices I’ve spent the past 15 years learning..
Now you can learn data analysis, using the same techniques and best practices I’ve spent the past 15 years learning.
This course is will teach you the key foundational techniques in data analysis, even if you’re new to this topic..
This course will teach you the key foundational techniques in data analysis, even if you’re new to this topic.
part of this course development, is As I had a group of people test-drive the course..
As part of this course development, I had a group of people test-drive the course.
they is This is what had to say about it: Are you drowning in data, but not using it to make better decisions?.
This is what they had to say about it: Are you drowning in data, but not using it to make better decisions?
you is Do run a small business and want to use your data to inform your strategy?.
Do you run a small business and want to use your data to inform your strategy?
your business is Has migrated from Excel to Google Sheets, and you're looking to further your skills?.
Has your business migrated from Excel to Google Sheets, and you're looking to further your skills?
Google Sheets is Learn how to use to make data-driven decisions..
Learn how to use Google Sheets to make data-driven decisions.
This course is will set you up to: 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!.
This course will set you up to: 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!
your data is Use instead of "gut" feel to put your business on the right path..
Use your data instead of "gut" feel to put your business on the right path.
Each lesson is is taught through bite-sized, action-oriented 5 - 10 minute-long videos, covering practical techniques you can apply to your own business..
Each lesson is taught through bite-sized, action-oriented 5 - 10 minute-long videos, covering practical techniques you can apply to your own business.
real-world examples, is Working with including example datasets from industries like sales, marketing, real-estate and social media, you'll learn how to make the most of your business data today..
Working with real-world examples, including example datasets from industries like sales, marketing, real-estate and social media, you'll learn how to make the most of your business data today.
you is Now can learn data analysis, using the same techniques and best practices I’ve spent the past 15 years learning..
Now you can learn data analysis, using the same techniques and best practices I’ve spent the past 15 years learning.
This course is will teach you the key foundational techniques in data analysis, even if you’re new to this topic..
This course will teach you the key foundational techniques in data analysis, even if you’re new to this topic.
part of this course development, is As I had a group of people test-drive the course..
As part of this course development, I had a group of people test-drive the course.
they is This is what had to say about it: "I was really excited by the idea of using an application I was familiar with, Google Sheets, to complete data analysis that had seemed so challenging and foreign before. People like me, who are not data scientists, and want an easy entry level way to start playing with data, would benefit from this course. I absolutely love this course!".
This is what they had to say about it: "I was really excited by the idea of using an application I was familiar with, Google Sheets, to complete data analysis that had seemed so challenging and foreign before. People like me, who are not data scientists, and want an easy entry level way to start playing with data, would benefit from this course. I absolutely love this course!"
- Geordie Frost, is - Geordie Frost, Bang Digital "I wanted to learn more about what I can do with Google Sheets to get an idea about how my agency can benefit..
- Geordie Frost, Bang Digital "I wanted to learn more about what I can do with Google Sheets to get an idea about how my agency can benefit.
My SEO company is uses Google almost entirely for all our project management, etc..
My SEO company uses Google almost entirely for all our project management, etc.
I is take every course from Ben Collins..
I take every course from Ben Collins.
I'm is always looking to up my data game..
I'm always looking to up my data game.
you is If can understand your Data you can make correct decisions about your business and *almost* guarantee success." - Devin Schumacher, The Search Marketing Company "Weekly, I face datasets I have to analyse and deliver insights..
If you can understand your Data you can make correct decisions about your business and *almost* guarantee success." - Devin Schumacher, The Search Marketing Company "Weekly, I face datasets I have to analyse and deliver insights.
This new knowledge is will help me get more insights from my data..
This new knowledge will help me get more insights from my data.
I've is Since already done three of Ben's previous courses, which were super useful, I knew it would be worth enrolling in this "analytical course"..
Since I've already done three of Ben's previous courses, which were super useful, I knew it would be worth enrolling in this "analytical course".
I is was right :)" - Jaume Fàbrega, Trekksoft I’ll tell you more about the course in a moment... ...but first let me reassure you:.
I was right :)" - Jaume Fàbrega, Trekksoft I’ll tell you more about the course in a moment... ...but first let me reassure you:
I've is made just about every mistake in the book.
I've made just about every mistake in the book
courses, is Prior to consulting and creating I worked as a forensic accountant, doing investigations into sanctions violations at large financial organizations..
Prior to consulting and creating courses, I worked as a forensic accountant, doing investigations into sanctions violations at large financial organizations.
We is used Excel and SQL to manage our project data -- hundreds of thousands of transactions that we would analyze for the legal team..
We used Excel and SQL to manage our project data -- hundreds of thousands of transactions that we would analyze for the legal team.
one time is There was I working on the master Excel dataset for a few days, but the unique identifier column was hidden..
There was one time I working on the master Excel dataset for a few days, but the unique identifier column was hidden.
These unique IDs is were therefore omitted from all the filters and sorts..
These unique IDs were therefore omitted from all the filters and sorts.
I is had a total panic when I realized that the ID numbers were now totally out of sync with the related data, and there was no way for anyone to now reference the data..
I had a total panic when I realized that the ID numbers were now totally out of sync with the related data, and there was no way for anyone to now reference the data.
I is (Thankfully, 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.) I learnt the valuable lesson of being careful with my data and keeping a good audit trail -- something we discuss throughout this course..
(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.) I learnt the valuable lesson of being careful with my data and keeping a good audit trail -- something we discuss throughout this course.
It is 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..
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 is to today Today I create online courses and write about working with data, with a particular focus on how-to articles for learning data analytics and building dashboards, using Google Sheets, Apps Script and Data Studio..
Fast forward to today Today I create online courses and write about working with data, with a particular focus on how-to articles for learning data analytics and building dashboards, using Google Sheets, Apps Script and Data Studio.
I’ve is Since mid-2015, been working as a freelance spreadsheet developer, data consultant and instructor..
Since mid-2015, I’ve been working as a freelance spreadsheet developer, data consultant and instructor.
I’ve is taught data analysis and visualization courses and workshops at General Assembly’s Washington, D.C., campus and privately for clients..
I’ve taught data analysis and visualization courses and workshops at General Assembly’s Washington, D.C., campus and privately for clients.
This data analysis course is is my third premium course..
This data analysis course is my third premium course.
It is fills the gap between the data cleaning course and the dashboard reporting courses, which hundreds of students have taken, to cover the whole 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 a data analyst, so he took a data analysis course to accelerate his career.
It fills the gap between the data cleaning course and the dashboard reporting courses, which hundreds of students have taken, to cover the whole 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 a data analyst, so he took a data analysis course to accelerate his career
Josh is was one of my students in the first Data Analysis class I taught for General Assembly in Washington, DC..
Josh was one of my students in the first Data Analysis class I taught for General Assembly in Washington, DC.
that course, is (In I taught data analysis fundamentals with Excel, but the topics were similar to what I now teach in Google Sheets.) Today, less than 3 years later, he has a masters degree in predictive analytics and works as a fully fledged data scientist..
(In that course, I taught data analysis fundamentals with Excel, but the topics were similar to what I now teach in Google Sheets.) Today, less than 3 years later, he has a masters degree in predictive analytics and works as a fully fledged data scientist.
I is Anyway, won’t say anymore, I’ll let Josh tell his story..
Anyway, I won’t say anymore, I’ll let Josh tell his story.
you is If want to... Describe and understand your datasets Test your hunches and confirm or disprove what you believe your data is telling you See how to convince your boss of your ideas backed up with rigorous results Predict outcomes based on your existing data Understand trends in your data over time, so you can identify successful events Understand your customers better, to better serve them ...then Data Analysis with Google Sheets is for you..
If you want to... Describe and understand your datasets Test your hunches and confirm or disprove what you believe your data is telling you See how to convince your boss of your ideas backed up with rigorous results Predict outcomes based on your existing data Understand trends in your data over time, so you can identify successful events Understand your customers better, to better serve them ...then Data Analysis with Google Sheets is for you.
Inside this course is I share all the knowledge I’ve built up over the past 15 years working with data in spreadsheets..
Inside this course I share all the knowledge I’ve built up over the past 15 years working with data in spreadsheets.
I’ve is packaged it all into a series of simple, bite-size video lessons, complete with Google Sheet templates, that anyone can follow..
I’ve packaged it all into a series of simple, bite-size video lessons, complete with Google Sheet templates, that anyone can follow.
✅ Actionable, is bite-size video lessons teaching key data analysis topics ✅ All raw datasets for you to follow along ✅ All solution files for your own use ✅ Access to the private course Facebook group for Q&A ✅ Certificate upon completion Ok data geeks!.
✅ Actionable, bite-size video lessons teaching key data analysis topics ✅ All raw datasets for you to follow along ✅ All solution files for your own use ✅ Access to the private course Facebook group for Q&A ✅ Certificate upon completion Ok data geeks!
Here is are the details for every module you get in this class: 7 modules | 45 videos | 20 templates.
Here are the details for every module you get in this class: 7 modules | 45 videos | 20 templates
Each video is breaks down a particular topic in data analysis and Google Sheets, and allows for quick referencing in the future..
Each video breaks down a particular topic in data analysis and Google Sheets, and allows for quick referencing in the future.
You is can watch them in any order you like, spread them over a few weeks or months, or even binge watch them all today if you like!.
You can watch them in any order you like, spread them over a few weeks or months, or even binge watch them all today if you like!
Module 1: is Introduction What is data analysis A framework for approaching data analysis problems Best practices in Google Sheets Glossary of Data Terms Guide to the most useful keyboard shortcuts in Google Sheets, for Macs, PCs and Chromebooks Module 2: Describing your data -- Learn to: Do exploratory data analysis Determine the key measures of a dataset Present these findings to colleagues Module 3: How different is your data?.
Module 1: Introduction What is data analysis A framework for approaching data analysis problems Best practices in Google Sheets Glossary of Data Terms Guide to the most useful keyboard shortcuts in Google Sheets, for Macs, PCs and Chromebooks Module 2: Describing your data -- Learn to: Do exploratory data analysis Determine the key measures of a dataset Present these findings to colleagues Module 3: How different is your data?
hypotheses is Formulate and test about your data… ...so that you can confidently talk about your data (and know what you’re saying is statistically significant) Run a number of different statistical tests so you can move beyond the “gut feel” approach to data Module 4: Discovering relationships in your data -- Learn to: Determine if two variables are correlated Calculate a variety of correlation metrics Avoid a variety of common mistakes Module 5: Predicting values -- Learn to: Build models using regression so that you can make predictions based on your existing data Test your models so you’ll know if they’re any good Build a spreadsheet interface running your regression model in the background Module 6: Time series analysis -- Learn to: Use a variety of ways to smooth your time series data to understand underlying trends Use the SOLVER add-on to optimize models Test your models to choose the most appropriate one Module 7: Customer analysis -- Learn To: Calculate customer lifetime value and find your most valuable cohorts Calculate your churn and retention rates to identify where customers drop off Draw retention curves to present results to your colleagues/bosses/clients Plus, you’ll also get the following additional resources: Templates!.
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) Run a number of different statistical tests so you can move beyond the “gut feel” approach to data Module 4: Discovering relationships in your data -- Learn to: Determine if two variables are correlated Calculate a variety of correlation metrics Avoid a variety of common mistakes Module 5: Predicting values -- Learn to: Build models using regression so that you can make predictions based on your existing data Test your models so you’ll know if they’re any good Build a spreadsheet interface running your regression model in the background Module 6: Time series analysis -- Learn to: Use a variety of ways to smooth your time series data to understand underlying trends Use the SOLVER add-on to optimize models Test your models to choose the most appropriate one Module 7: Customer analysis -- Learn To: Calculate customer lifetime value and find your most valuable cohorts Calculate your churn and retention rates to identify where customers drop off Draw retention curves to present results to your colleagues/bosses/clients Plus, you’ll also get the following additional resources: Templates!
the beginning of each module is At are templates with the raw datasets and solution files, available for your use, saving you hours of time..
At the beginning of each module are templates with the raw datasets and solution files, available for your use, saving you hours of time.
Here’s is a sample of what you can expect with the templates: There are three templates for each chapter: The raw dataset The solution Summary reports, featuring Google Slides, Google Docs and Email examples These resources alone will save you hours and hours of valuable time..
Here’s a sample of what you can expect with the templates: There are three templates for each chapter: The raw dataset The solution Summary reports, featuring Google Slides, Google Docs and Email examples These resources alone will save you hours and hours of valuable time.
the private course Facebook group is Access to.
Access to the private course Facebook group
Your enrollment is is backed up with support..
Your enrollment is backed up with support.
a private Facebook group is There’s for students, where you can ask questions, share your insights and knowledge, share your wins, and connect with other students..
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 is be hanging out there to answer your questions..
I’ll be hanging out there to answer your questions.
Your enrollment is in Data Analysis with Google Sheets comes with lifetime access to the course material..
Your enrollment in Data Analysis with Google Sheets comes with lifetime access to the course material.
That way is you can take a break from the material if you’re out of town, on vacation, or just swamped for a few days..
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 is happen, and your course videos will ALWAYS be here for you when you’re ready..
Interruptions happen, and your course videos will ALWAYS be here for you when you’re ready.
This lifetime access is also includes all future updates and upgrades at no extra charge..
This lifetime access also includes all future updates and upgrades at no extra charge.
my way is This is of ensuring that Data Analysis with Google Sheets remains an excellent long-term investment for you and your business..
This is my way of ensuring that Data Analysis with Google Sheets remains an excellent long-term investment for you and your business.
your is Want to show off newly acquired skills?.
Want to show off your newly acquired skills?
You’ll is automatically get a certificate upon completing the course, which you can share or post on Linkedin..
You’ll automatically get a certificate upon completing the course, which you can share or post on Linkedin.