Data Analysis the Lazy Way

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.

Will McGuire, MeasureSchool

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.

Making Spreadsheets Great Again

FAQ

Q

Who is this course for?

If you use spreadsheets to work with data, but want to take your skills to the next level.
If you're doing marketing, sales, analytics, finance or ops, that probably means you.
As a matter of motivation, you'll get the most out of this course if you have a specific dataset you'd like to dive into.
Whether that's Google Analytics data for a website, YouTube data, Salesforce data, it doesn't matter, but it'll help you visualize how you'll make use of these skills in your day-to-day.

Q

What tools are needed for this course?

You'll need a Google Apps account (to make copies of spreadsheets), which comes for free with every GMail account.
You'll also learn how to use Blockspring, Supermetrics and Zapier to pull data into spreadsheets, but accounts are not required for the course.