Data Analysis Basics Course (How To)

Learn how to make better decisions with data in this course on data analysis. We'll start by looking at what data analysis is, and then we'll see how we can use data analysis to create better outcomes.

What you'll learn

• Cleaning and preparing data in spreadsheets
• Summarizing data with formulae
• Normal distributions and standard deviations
• Simple visualizations in spreadsheets
• Presenting findings

Introducing Data Analysis

From the daily weather forecast to the nightly sports results, data is all around us. Let's take a look at how we can analyse data to draw conclusions and uncover hidden insights!

Chevron 5 steps

• Making Better Decisions with Data Analysis

  3:17

• Data is Everywhere

  3:13

• Creating a Spreadsheet

  3:54

• Getting Good Data is Hard

  4:28

• Introducing Data Analysis

  5 questions

Getting to Know Your Data

There's a lot of ways we can look at our data. We can look at it as rows in columns in a spreadsheet, or we can try and represent it visually as a chart. We can even summarize our data into just a few numbers to help us make decision making less of a chore and more of a step-by-step process!

Chevron 9 steps

• Summarizing Data: Maximum, Minimum, Range

  4:02

• Summarizing Data: Mean, Median, Mode

  2:35

• Getting Friendly with Data

  5 questions

• Analyzing Data Spread

  3:53

• Is Our Data Normal?

  5:15

• Visualizing Data

  3:47

• Charting Our Data: Part 1

  3:06

• Charting Our Data: Part 2

  4:30

• Becoming the Data

  5 questions

The Data Analysis Process

There are a lot of ways to perform an analysis of data. In this stage, we'll talk about metrics and look at one way to work through the data analysis process.

Chevron 5 steps

• Understanding Metrics

  4:03

• Defining Terms

  4:38

• Analyzing the Data

  6:34

• Presenting Your Findings

  4:04

• Mastering Data Analysis

  5 questions