Data Analytics: Hands On

Learn all of the key concepts in the world of data analytics. This course will walk you through everything you need to know to brush up on your data analytics knowledge or introduce you to every key area if you're entirely new to the subject.
Course info
Rating
(410)
Level
Beginner
Updated
Jul 16, 2015
Duration
5h 2m
Table of contents
Getting Started
Excel Basics
Massaging Data in Excel
Analyzing Data in Excel
Databases Overview
Intro to SQL
Intro to Data Modeling
Data Warehousing Basics
Big Data
Visualizing Data in Charts
Building Charts in Tableau
Presenting Findings
Description
Course info
Rating
(410)
Level
Beginner
Updated
Jul 16, 2015
Duration
5h 2m
Description

This course covers everything from the basic concepts of data analysis, to data warehouse design and data visualization principles. If you're looking for a career change or already making your way into the world of transforming data into value, this course will help you understand all of the key concepts and get some hands-on skills, while being directed to where you can dig in deeper when you find something you're interested in. If you're already working in the data world, you can use this course as a reference. Each module is broken down into segments that answer the basic questions of what, why, how, and where so you can easily dive in where you want to learn more and jump back out without needing to start watching from the beginning.

About the author
About the author

I work as a feedback mechanism for organizations and teams to help them understand what’s going on with their products and processes. I do this by collecting and organizing their data, visually exploring it, enriching it with other data and metrics, then presenting my findings using creative information design techniques. This leads to improved business performance and often sparks a data-driven culture throughout my clients organizations.

More from the author
What's New in Tableau 10
Intermediate
1h 50m
Aug 30, 2016
Force Layout Graphs in D3
Intermediate
2h 33m
Aug 29, 2016
D3: The Big Picture
Beginner
1h 26m
Aug 16, 2016
More courses by Ben Sullins
Section Introduction Transcripts
Section Introduction Transcripts

Getting Started
Hello everyone, welcome to this course, Data Analytics: Hands On. My name is Ben Sullins, and I'm going to walk you through this module now on getting started. First let's talk about our course goals. So, we're going to learn the basics of data analytics from start to finish. You're going to understand all the pieces, how they all fit together, and a good functional understanding of each different component. The best way to do that, I think, is to follow a story, something that is a real world example of something you might encounter in the world today in the process of analyzing data to glean information out of it. There are two methods of learning that this course offers you. There's the start to finish idea where if you're new to the data analytics world or really just want to get an understanding of the whole thing, I encourage you to watch from start to finish, starting with this module all the way through the last one. It's really going to be a cohesive experience, where all the pieces throughout are going to fit together, and you'll gain a complete holistic view of how the world of data analytics actually works. The other way, is to just fill in the gaps. If you're familiar with the data analytics world, or you're new to it, but have some experience, and you just want to learn about little pieces, you can also use this as a reference library. So each module is compartmentalized to where it in itself is going to teach you about that topic. So you don't have to watch end to end if you already have a lot of other experience in a lot of other areas, and you just want to learn bits about different aspects that you may be unfamiliar with.

Excel Basics
Hey everyone, welcome to this module on Excel Basics. I'm Ben Sullins, and I'm going to teach you here today all the basic knowledge that you need to be a good data analyst and understand where Excel fits in. In this module, we're going to talk about what Excel is, why people use Excel, how to use Excel, we'll go through some basic examples, and where you can find more information about Excel.

Massaging Data in Excel
Continuing on our journey here to become awesome data analysts, we're going to go through this module now on Massaging Data in Excel. In this module we have some goals. First, we're going to talk about what massaging data is, why we would massage data to begin with, how to do it, we'll go through some functional examples, and lastly, we'll figure out where to find more info if you want to get deeper into this category.

Analyzing Data in Excel
Hello, and welcome to this module on Analyzing Data in Excel. This is our fourth module in the course on Data Analytics: Hands On. To this point, what we've done is collected and organized some data. We looked how to massage it, and now it's time to actually bring home the bacon here and bring some visualizations and some insight into what the data is going to try to tell us. In this module we're going to understand what data analysis is, why we would analyze data, how we can do it, and we'll get into a lot of demos in that section, and then we'll learn about where to find more. As always, this is a huge topic and way too much to go into depth on every little nook and cranny of it just for this module, so I'll point you in the right direction in case this is really an area you want to dive deep into.

Databases Overview
Welcome to this module on Databases. Here we're going to talk about what databases are, go through some examples conceptually to try to understand the difference between that and say a spreadsheet. We'll talk about why we would use a database, look at the different types of databases there are, figure out how they actually work, and then we'll conclude by showing some additional resources for you if you really want to dig into the databases' world. Okay, let's get started.

Intro to SQL
Welcome to this module, Intro to SQL. We're getting deeper down the path on our data analytics journey here, and here we're going to actually write some code and interact with the data we just loaded into our SQL database. We're going to talk about what SQL is, talk about the definition of it, figure out why we would use SQL in the first place, go through some SQL basics, talk about how SQL actually works under the covers, and then we'll learn where to find more. Throughout this module we're going to have demos following along with our story of Cogsley Services Inc, so I hope you're ready to get started here and really get down into the details and gain some new super powers using this programming language known as SQL.

Intro to Data Modeling
Welcome to this module on Intro to Data Modeling. We're getting pretty far down our path and becoming an awesome data analyst here, and in this module what we're going to do is take a look at what data modeling is, why we would use data modeling, some key concepts, and then where we can find more.

Data Warehousing Basics
Welcome to this module on Data Warehousing Basics. Here we're going to learn what data warehousing is, why we would use data warehousing, how it really works, we'll cover some of the key concepts so you have a basic understanding, and then I'll show you where you can find more info. Let's get started.

Big Data
Welcome to this module on Big Data. I'm Ben Sullins, and today we're going to learn what big data is, why big data exists, how big data works, some of the key concepts behind big data, and where we can find more info. Let's get started.

Visualizing Data in Charts
Welcome to this module on visualizing data in charts. I'm Ben Sullins, and in this module we're going to learn what data visualization is, why we would visualize data, how it really works, some of the key concepts that make up this whole world of data visualization, and where you can find more. Let's get started.

Building Charts in Tableau
Welcome to this module on Building Charts in Tableau. I'm Ben Sullins, and today we're going to learn what Tableau is, why we would use Tableau, how it works, we'll go through so you'll get really hands on here, we'll follow our story with Cogsley Services, and then we'll point you where you can find more information. Let's get started.

Presenting Findings
Welcome to this module on Presenting Findings. In this module we're going to talk about what presentations are, why we would use presentations and why they're so important, how we can actually do this, how the act of presenting findings can convey and move our audience, we'll go through some of the key concepts, and lastly we'll point you where you can find some more info. Let's get started.