Data Analysis the Lazy Way

Using Google Sheets and apps like Zapier to save hours at work
The Course Project
Why Google Sheets?
2 mins
The Cupcake Data Analysis
3 mins
Asking Good Questions: the Course Project
3 mins
The Lazy Toolbelt
Intro to the Lazy Toolbelt
1 min
Why the Lazy Toolbelt?
2 mins
WTF is Blockspring?
2 mins
WTF is Supermetrics?
2 mins
WTF is Zapier?
2 mins
10 Sheets Formulas to Know
Intro to Data Wrangling
1 min
The 3 Types of Formulas
3 mins
Learn the 10 Formulas
Answering Basic Questions
Intro: Baking your First Cupcake
1 min
Copy the Example Sheet
Question 1: Top Questions
3 mins
Question 2: Top Tweeters
5 mins
Question 3: Top Day of the Week
6 mins
Quiz 1: Basic Querying
Answering Advanced Questions
Intro: Diving Deeper
1 min
Question 4: Top Hour of the Day
5 mins
Question 5: Top Hashtags
8 mins
Question 6: Top Domains
6 mins
Quiz 2: Advanced Querying
Visualizing your Answers in Data Studio
Intro to Data Visualization
1 min
Getting Started with Data Studio
3 mins
Connecting your Sheet to Data Studio
3 mins
Building a Simple Table
3 mins
Calculating Metrics in Data Studio
4 mins
Building Time Series Charts
4 mins
Styling Charts and Reports
1 min
Quiz 3: Building your own Dashboard
The Lazy Way in Action
Cupcake Data Analysis and You
2 mins
Start your own Cupcake Data Analysis
Access the CIFL Template Vault
Case Study: The Growth Engine with Kev Kaye
13 mins
Case Study: SEO Audit with Ryan Stewart