Data Analysis the Lazy Way

Using Google Sheets and apps like Zapier to save hours at work
The Course Project
Every data analysis is a cupcake. We'll find out why in this section, and walk through the Twitter data analysis project that makes up the core of this course.
Why Google Sheets?
2 mins
The Cupcake Data Analysis
3 mins
Asking Good Questions: the Course Project
3 mins
The Lazy Toolbelt
Learn the tools of our Lazy trade: apps like Blockspring, Supermetrics and Zapier that allow you to pull data from the comfort of your Google Sheet. No more pulling data by hand = lots of free time to drink iced coffee.
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
Learn these and you'll be a data analysis master. Pay close attention to the QUERY function - it'll soon be your best friend.
Intro to Data Wrangling
1 min
The 3 Types of Formulas
3 mins
Learn the 10 Formulas
Answering Basic Questions
Diving into the Twitter data we've collected using Zapier, to answer questions about how best to engage with our sample Twitter list.
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
Now that you've got the hang of the QUERY function, we'll dive further into how you can use it for complex analysis. You can follow along using the same sample spreadsheet you copied in the last section.
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
We'll dive into the nuts and bolts of Google Data Studio, which you can connect to any Google Sheet to make beautiful charts. At the end of the section, you'll have the chance to build your own dashboard.
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
Learn how the Lazy Way is used in the real world, in case studies with friends like SEO expert Ryan Stewart and growth marketer Kev Kaye. Also included are two ways for you to get up and running with your own Cupcake data analysis: 1. A worksheet for mapping out your own Cupcake analysis project 2. Access to the entire CIFL vault of spreadsheet templates on Trello This is where the rubber meets the road, for adding the Lazy Way to your daily workflow.
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