Will McGuire – Coding is for Losers/Data Analysis the Lazy Way

‘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 can create reports, export data from Google Analytics and create charts. the Your job is the most enjoyable part. What if it were?

This course presents a fresh approach to data analysis. the lazy way. Google Sheets has been a tool of mass laziness. It can be combined with tools such as Blockspring or Zapier to dramatically cut down the time you spend on data analysis and wrangling.

In this course, you’ll learn the Three-We use part of the process at Coding is for Analyzing data is difficult for those who aren’t able to pay: 

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

All data analysis is a cupcake.

This section will explain why. the Twitter data analysis project that analyzes Twitter data the This course is the core.
Google Sheets: Why?

2 mins159MB

Preview
Cupcake Data Analysis

3 minutes21.6 MB

Preview
Asking good questions: the Course Project

3 minutes39.3MB

Preview
The Lazy Toolbelt

Learn the Our tools Lazy Trade: Apps like Supermetrics, Blockspring and Zapier allow you to pull data directly from the Google Sheet comfort.

You can now enjoy iced coffee without having to do any data entry manually.
Intro to the Lazy Toolbelt

1 min72.1MB

Preview
Why? the Lazy Toolbelt?

2 mins53.2MB

WTF is Blockspring?

2 mins62.1MB

WTF is Supermetrics?

2 mins25.9 Mb

WTF is Zapier?

2 minutes30.5 MB

10 Sheets Formulas To Know

These are the key to data analysis success.

Pay close attention the The QUERY function will soon become your best friend.
Intro to Data Wrangling

1 min81.9MB

Preview
The 3 Types of Formulas

3 minutes23.8 MB

Learn the 10 Formulas

Answering basic questions

Diversifying into the Zapier has collected Twitter data that can be used to answer questions regarding how to interact with the sample Twitter list.
Intro: How to bake your first cupcake

1 min121MB

Preview
Copy the Example Sheet

Question 1: Top questions

3 minutes74.2 MB

Question 2: Top Twitterers

5 mins110MB

Question 3: Top Day of the Week

6 minutes 137 MB

Quiz 1: Basic querying

Answering Advanced Questions

Now, you have the Hang on the We’ll explore the QUERY function and how it can be used. for Complex analysis. You can follow along by using the Same sample spreadsheet that you copied in the Section last.
Intro: Diving Deeper

1 min99 MB

Preview
Question 4: The Top Hour of the Day the Day

5 minutes132 MB

Question 5: Top Hashtags

8 mins148MB

Question 6: Top Domains

6 minutes181 MB

Quiz 2: Advanced Queries

Data Studio: Visualizing Your Answers

We’ll dive into the The basics of Google Data Studio. You can connect it to any Google Sheet to create beautiful charts.

At the End of the section, you will have the Chance to design your own dashboard
Intro to Data Visualization

1 min91.6 MB

Preview
Data Studio: How to Get Started

3 minutes60.6 MB

Connecting your Sheet with Data Studio

3 minutes42.5 MB

A Simple Table

3 minutes28 MB

Data Studio – Calculating Metrics

4 minutes86.5MB

Building Time Series Diagrams

4 mins89MB

Reports and Style Charts

1 min12.9 MB

Quiz 3: Build your own Dashboard

The Lazy Way In Action

Find out how the Lazy Way is Used in the Real life, in case studies together with SEO expert Ryan Stewart or Kev Kaye, growth marketer.

There are also two other options. for Get started with your Cupcake data analysis

1. A worksheet for Your Cupcake analysis project:
2. Access to the Trello contains entire CIFL repository of spreadsheet templates

This is Where the rubber meets the road, for Addition the Lazy Way Your daily workflow.
Cupcake Data Analysis And You

2 minutes213 MB

Preview
Cupcake Data: Start your own Cupcake Data Analysis

Access the Vault of CIFL Templates

Case Study: The Growth Engine with Kev Jaye

13 minutes1.77 GB

Case Study: Ryan Stewart’s SEO Audit

—————

Google Sheets, Data Studio, and BigQuery: How to Master It

We help you to organize your data and automate your work without ever leaving. the Google stack.

—————

If you are familiar with spreadsheets and want to learn more about data manipulation, the next level.

You are probably in marketing, sales, finance, or operations.

Motivating yourself will make you a better person. the If you have a particular dataset that you would like to explore, you will get the most benefit from this course.

Google Analytics data or not for It doesn’t matter if you have a website or Salesforce data. But it will help you see how these skills can be used in your day.-To-day.

“NOTE: The content above has been rewritten by our library.”

“To read more original content please visit here. Powered by Will McGuire.”