1 ITEMView cart
Subtotal: $24.00
-62%
David Krevitt – Coding is for Losers/Data Analysis the Lazy Way
Original price was: $99.00.$38.00Current price is: $38.00.
Digital Download: David Krevitt – Coding is for Losers/Data Analysis the Lazy Way
You will have access to the digital downloads in your order email.
You will also be able to access your downloads from your account dashboard.
Short Description:
Google Sheets has become a weapon of mass laziness – when combined with tools like Blockspring and Zapier, it allows you to drastically cut your time spent wrangling and analyzing data.
- Description
- Reviews (0)
Description
Description
David Krevitt – Coding is for Losers/Data Analysis the Lazy Way
gle Sheets and apps like Zapier to save hours at work
From the Other Side…
I am still applying the concepts I learned from the course every day. One of my favourite courses over the past year.
Overview
‘Data analysis’ probably isn’t in your job description – it’s something you do only out of necessity.
You get asked a question about your work, and you’re expected to present the answer. You build reports, export data from tools like Google Analytics, and make charts – not the most fun part of your job. But what if it was?
This course presents a new approach to data analysis – the lazy way. Google Sheets has become a weapon of mass laziness – when combined with tools like Blockspring and Zapier, it allows you to drastically cut your time spent wrangling and analyzing data.
In this course, you’ll learn the three-part process we use at Coding is for Losers to analyze data:
- Pulling data into Sheets using apps like Blockspring or Zapier
- The 10 key Google Sheets formulas we use to wrangle data
- Build beautiful charts and dashboards in Google Data Studio
If you’ve ever used a spreadsheet, you’re closer than you think to becoming a data analysis master. *Warning: This course is _not_ for spreadsheet beginners.
Contents
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
- 159 MB
The Cupcake Data Analysis
- 3 mins
- 21.6 MB
Asking Good Questions: the Course Project
- 3 mins
39.3 MB
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
- 72.1 MB
Preview
Why the Lazy Toolbelt?
- 2 mins
- 53.2 MB
WTF is Blockspring?
- 2 mins
- 62.1 MB
WTF is Supermetrics?
- 2 mins
- 25.9 MB
WTF is Zapier?
- 2 mins
- 30.5 MB
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
- 81.9 MB
Preview
The 3 Types of Formulas
- 3 mins
- 23.8 MB
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
- 121 MB
Preview
Copy the Example Sheet
Question 1: Top Questions
- 3 mins
- 74.2 MB
Question 2: Top Tweeters
- 5 mins
- 110 MB
Question 3: Top Day of the Week
- 6 mins
- 137 MB
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
- 99 MB
Preview
Question 4: Top Hour of the Day
- 5 mins
- 132 MB
Question 5: Top Hashtags
- 8 mins
- 148 MB
Question 6: Top Domains
- 6 mins
- 181 MB
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
- 91.6 MB
Getting Started with Data Studio
- 3 mins
- 60.6 MB
Connecting your Sheet to Data Studio
- 3 mins
- 42.5 MB
Building a Simple Table
- 3 mins
- 28 MB
Calculating Metrics in Data Studio
- 4 mins
- 86.5 MB
Building Time Series Charts
- 4 mins
- 89 MB
Styling Charts and Reports
- 1 min
- 12.9 MB
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
- 213 MB
Start your own Cupcake Data Analysis
Access the CIFL Template Vault
Case Study: The Growth Engine with Kev Kaye
- 13 mins
- 1.77 GB
Case Study: SEO Audit with Ryan Stewart
Reviews
There are no reviews yet.