Discover ways to make knowledge-pushed choices in Google Sheets and rework your enterprise. Discover ways to use Google Sheets to make knowledge-pushed choices. This course will set you as much as:
Perceive and describe what your knowledge tells you
Ben Collins – Data Analysis with Google Sheets
Discover ways to make knowledge-pushed choices in Google Sheets and rework your enterprise
Are you drowning in knowledge, however not utilizing it to make higher choices?
Do you run a small enterprise and need to use your knowledge to tell your technique?
Has your enterprise migrated from Excel to Google Sheets, and also you’re trying to additional your abilities?
Discover ways to use Google Sheets to make knowledge-pushed choices.
This course will set you as much as:
- Perceive and describe what your knowledge tells you
- Predict what issues would possibly appear like sooner or later
- Perceive your prospects to higher serve them
- Uncover what elements have an effect on your enterprise
- Finest practices for doing all of this…
- …and far, far more!
Use your knowledge as an alternative of “gut” really feel to place your enterprise on the suitable path.
Every lesson is taught by way of chew-sized, motion-oriented 5 – 10 minute-lengthy movies, overlaying sensible methods you possibly can apply to your individual enterprise.
Working with actual-world examples, together with instance datasets from industries like gross sales, advertising, actual-property and social media, you will discover ways to profit from your enterprise knowledge in the present day.
Now you possibly can study knowledge evaluation, utilizing the identical methods and finest practices I’ve spent the previous 15 years studying.
This course will educate you the important thing foundational methods in knowledge evaluation, even should you’re new to this matter.
As a part of this course growth, I had a bunch of individuals check-drive the course. That is what they needed to say about it:
Are you drowning in knowledge, however not utilizing it to make higher choices?
Do you run a small enterprise and need to use your knowledge to tell your technique?
Has your enterprise migrated from Excel to Google Sheets, and also you’re trying to additional your abilities?
Discover ways to use Google Sheets to make knowledge-pushed choices.
This course will set you as much as:
- Perceive and describe what your knowledge tells you
- Predict what issues would possibly appear like sooner or later
- Perceive your prospects to higher serve them
- Uncover what elements have an effect on your enterprise
- Finest practices for doing all of this…
- …and far, far more!
Use your knowledge as an alternative of “gut” really feel to place your enterprise on the suitable path.
Every lesson is taught by way of chew-sized, motion-oriented 5 – 10 minute-lengthy movies, overlaying sensible methods you possibly can apply to your individual enterprise.
Working with actual-world examples, together with instance datasets from industries like gross sales, advertising, actual-property and social media, you will discover ways to profit from your enterprise knowledge in the present day.
Now you possibly can study knowledge evaluation, utilizing the identical methods and finest practices I’ve spent the previous 15 years studying.
This course will educate you the important thing foundational methods in knowledge evaluation, even should you’re new to this matter.
As a part of this course growth, I had a bunch of individuals check-drive the course. That is what they needed to say about it:
“I used to be actually excited by the concept of utilizing an software I used to be acquainted with, Google Sheets, to finish knowledge evaluation that had appeared so difficult and overseas earlier than.
Individuals like me, who will not be knowledge scientists, and wish a simple entry degree approach to begin enjoying with knowledge, would profit from this course.
I completely love this course!”
– Geordie Frost, Bang Digital
“I wished to study extra about what I can do with Google Sheets to get an concept about how my company can profit. My search engine optimization firm makes use of Google virtually fully for all our venture administration, and so on.
I take each course from Ben Collins. I am at all times trying to up my knowledge sport. If you happen to can perceive your Data you may make appropriate choices about your enterprise and *virtually* assure success.“
– Devin Schumacher, The Search Advertising and marketing Firm
“Weekly, I face datasets I’ve to analyse and ship insights. This new data will assist me get extra insights from my knowledge.
Since I’ve already carried out three of Ben’s earlier programs, which had been tremendous helpful, I knew it might be price enrolling on this “analytical course”. I used to be proper :)”
– Jaume Fàbrega, Trekksoft
I’ll let you know extra in regards to the course in a second…
…however first let me reassure you:
I’ve made nearly each mistake within the guide
Previous to consulting and creating programs, I labored as a forensic accountant, doing investigations into sanctions violations at giant monetary organizations.
We used Excel and SQL to handle our venture knowledge — tons of of hundreds of transactions that we’d analyze for the authorized group.
There was one time I engaged on the grasp Excel dataset for a number of days, however the distinctive identifier column was hidden. These distinctive IDs had been subsequently omitted from all of the filters and kinds.
I had a complete panic after I realized that the ID numbers had been now completely out of sync with the associated knowledge, and there was no method for anybody to now reference the info.
(Fortunately, I used to be in a position to create a brand new distinctive identifier primarily based on the info, and use that to retrieve the IDs from an older copy of the dataset, the place they weren’t tousled.)
I learnt the dear lesson of being cautious with my knowledge and retaining a very good audit path — one thing we focus on all through this course.
It was additionally round this time that I noticed how beneficial strong knowledge and spreadsheet abilities had been, and I’ve taken each alternative to additional my abilities since then.
Quick ahead to in the present day
At the moment I create on-line programs and write about working with knowledge, with a selected deal with how-to articles for studying knowledge analytics and constructing dashboards, utilizing Google Sheets, Apps Script and Data Studio.
Since mid-2015, I’ve been working as a contract spreadsheet developer, knowledge guide and teacher.
I’ve taught knowledge evaluation and visualization programs and workshops at Basic Meeting’s Washington, D.C., campus and privately for shoppers.
The lacking piece
This knowledge evaluation course is my third premium course.
It fills the hole between the info cleansing course and the dashboard reporting programs, which tons of of scholars have taken, to cowl the entire knowledge evaluation course of:
Earlier this 12 months I ran a few webinars in regards to the QUERY perform (which options on this knowledge evaluation course), and right here’s what some of us had been saying about my different Google Sheets coaching programs:
Josh wished to be an information analyst, so he took an information evaluation course to speed up his profession
Josh was one in every of my college students within the first Data Analysis class I taught for Basic Meeting in Washington, DC. (In that course, I taught knowledge evaluation fundamentals with Excel, however the subjects had been much like what I now educate in Google Sheets.)
At the moment, lower than 3 years later, he has a masters diploma in predictive analytics and works as a totally fledged knowledge scientist. Wow!
Anyway, I gained’t say anymore, I’ll let Josh inform his story.
Concerning the course
If you wish to…
- Describe and perceive your datasets
- Check your hunches and make sure or disprove what you consider your knowledge is telling you
- See how one can persuade your boss of your concepts backed up with rigorous outcomes
- Predict outcomes primarily based in your current knowledge
- Perceive traits in your knowledge over time, so you possibly can determine profitable occasions
- Perceive your prospects higher, to higher serve them
…then Data Analysis with Google Sheets is for you.
Inside this course I share all of the data I’ve constructed up over the previous 15 years working with knowledge in spreadsheets.
I’ve packaged all of it right into a sequence of easy, chew-dimension video classes, full with Google Sheet templates, that anybody can observe.
Enroll now to get:
✅ Actionable, chew-dimension video classes instructing key knowledge evaluation subjects
✅ All uncooked datasets so that you can observe alongside
✅ All answer recordsdata to your personal use
✅ Entry to the personal course Fb group for Q&A
✅ Certificates upon completion
Okay knowledge geeks! Listed below are the small print for each module you get on this class:
_x0001F4DA_ 7 modules | 45 movies | 20 templates
Every video breaks down a selected matter in knowledge evaluation and Google Sheets, and permits for fast referencing sooner or later. You may watch them in any order you want, unfold them over a number of weeks or months, and even binge watch all of them in the present day should you like!
Module 1: Introduction
- What’s knowledge evaluation
- A framework for approaching knowledge evaluation issues
- Finest practices in Google Sheets
- Glossary of Data Phrases
- Information to essentially the most helpful keyboard shortcuts in Google Sheets, for Macs, PCs and Chromebooks
Module 2: Describing your knowledge — Study to:
- Do exploratory knowledge evaluation
- Decide the important thing measures of a dataset
- Current these findings to colleagues
Module 3: How completely different is your knowledge? Study to:
- Check, check, check!
- Formulate and check hypotheses about your knowledge…
- …as a way to confidently speak about your knowledge (and know what you’re saying is statistically important)
- Run quite a lot of completely different statistical assessments so you possibly can transfer past the “gut feel” strategy to knowledge
Module 4: Discovering relationships in your knowledge — Study to:
- Decide if two variables are correlated
- Calculate quite a lot of correlation metrics
- Keep away from quite a lot of frequent errors
Module 5: Predicting values — Study to:
- Construct fashions utilizing regression as a way to make predictions primarily based in your current knowledge
- Check your fashions so that you’ll know in the event that they’re any good
- Construct a spreadsheet interface working your regression mannequin within the background
Module 6: Time sequence evaluation — Study to:
- Use quite a lot of methods to clean your time sequence knowledge to know underlying traits
- Use the SOLVER add-on to optimize fashions
- Check your fashions to decide on essentially the most applicable one
Module 7: Buyer evaluation — Study To:
- Calculate buyer lifetime worth and discover your most beneficial cohorts
- Calculate your churn and retention charges to determine the place prospects drop off
- Draw retention curves to current outcomes to your colleagues/bosses/shoppers
Plus, you’ll additionally get the next extra assets:
_x0001F4A1_ Templates!
Originally of every module are templates with the uncooked datasets and answer recordsdata, out there to your use, saving you hours of time.
Right here’s a pattern of what you possibly can count on with the templates:
There are three templates for every chapter:
- The uncooked dataset
- The answer
- Abstract experiences, that includes Google Slides, Google Docs and E-mail examples
These assets alone will prevent hours and hours of beneficial time.
_x0001F4A1_ Entry to the personal course Fb group
Your enrollment is backed up with assist.
There’s a non-public Fb group for college students, the place you possibly can ask questions, share your insights and data, share your wins, and join with different college students.
I’ll be hanging on the market to reply your questions.
_x0001F4A1_ Lifetime entry to the course
Your enrollment in Data Analysis with Google Sheets comes with lifetime entry to the course materials.
That method you possibly can take a break from the fabric should you’re out of city, on trip, or simply swamped for a number of days.
Interruptions occur, and your course movies will ALWAYS be right here for you while you’re prepared. This lifetime entry additionally consists of all future updates and upgrades at no additional cost.
That is my method of guaranteeing that Data Analysis with Google Sheets stays a wonderful lengthy-time period funding for you and your enterprise.
_x0001F4A1_ Certificates of Completion
Wish to exhibit your newly acquired abilities?
You’ll mechanically get a certificates upon finishing the course, which you’ll share or submit on Linkedin.
Prepared to affix?
This is What You may 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