The Data Analyst Course: Complete Data Analyst Bootcamp
All LevelsBusinessData Analysis

The Data Analyst Course: Complete Data Analyst Bootcamp

Complete Data Analyst Training: Python, NumPy, Pandas, Data Collection, Preprocessing, Data Types, Data Visualization

Created by 365 Careers
21 hours
Video Content
285
Lectures
156,914
Students
4.5
Rating
4.5
(156,914 students enrolled)

What you'll learn

The course provides the complete preparation you need to become a data analyst
Fill up your resume with in-demand data skills: Python programming, NumPy, pandas, data preparation - data collection, data cleaning, data preprocessing, data visualization; data analysis, data analytics
Acquire a big picture understanding of the data analyst role
Learn beginner and advanced Python
Study mathematics for Python
We will teach you NumPy and pandas, basics and advanced
Be able to work with text files
Understand different data types and their memory usage
Learn how to obtain interesting, real-time information from an API with a simple script
Clean data with pandas Series and DataFrames
Complete a data cleaning exercise on absenteeism rate
Expand your knowledge of NumPy – statistics and preprocessing
Go through a complete loan data case study and apply your NumPy skills
Master data visualization
Learn how to create pie, bar, line, area, histogram, scatter, regression, and combo charts
Engage with coding exercises that will prepare you for the job
Practice with real-world data
Solve a final capstone project

Course Content

27 sections • 285 lectures • 21:27:52 total length

Introduction to the Course

4 lectures • 21:07

A Practical Example - What Will You Learn in This Course?04:46
What Does the Course Cover?05:36
Download All Resources00:15
FAQ10:29

Introduction to Data Analytics

5 lectures • 22:02

Introduction to the World of Business and Data02:26
Relevant Terms Explained05:45
Data Analyst Compared to Other Data Jobs02:27
Data Analyst Job Description05:42
Why Python05:42

Setting up the Environment

9 lectures • 34:05

Introduction01:24
Programming Explained in a Few Minutes05:04
Programming Explained in a Few Minutes2 questions
Jupyter - Introduction03:28
Jupyter - Installing Anaconda03:34
+6 more lectures

Python Basics

39 lectures • 02:00:37

Python Variables03:37
Python Coding Exercises - Part I04:58
Python Variables - Exercise #11 question
Python Variables - Exercise #21 question
Python Variables - Exercise #31 question
+151 more lectures

Fundamentals for Coding in Python

6 lectures • 32:17

Object-Oriented Programming (OOP)05:00
Modules, Packages, and the Python Standard Library04:24
Importing Modules03:24
Introduction to Using NumPy and pandas09:09
What is Software Documentation?03:57
+1 more lectures

Mathematics for Python

11 lectures • 51:01

What Is а Matrix?03:37
Scalars and Vectors02:58
Linear Algebra and Geometry03:06
Arrays in Python05:09
What Is a Tensor?03:00
+6 more lectures

NumPy Basics

6 lectures • 19:42

The NumPy Package and Why We Use It04:03
Installing/Upgrading NumPy02:01
Ndarray03:06
The NumPy Documentation04:42
NumPy Basics - Exercise00:15
+4 more lectures

Pandas - Basics

17 lectures • 01:22:16

Introduction to the pandas Library05:41
Installing and Running pandas05:57
Installing and Running pandas - Exercise #11 question
A Note on Completing the Upcoming Coding Exercises01:22
Installing and Running pandas - Exercise #21 question
+50 more lectures

Working with Text Files

30 lectures • 01:59:22

Working with Files in Python - An Introduction03:46
File vs File Object, Read vs Parse02:52
Structured vs Semi-Structured and Unstructured Data03:10
Data Connectivity through Text Files03:06
Principles of Importing Data in Python04:50
+79 more lectures

Working with Text Data

6 lectures • 40:57

Working with Text Data and Argument Specifiers09:18
Text Data and Argument Specifiers - Exercise #11 question
Text Data and Argument Specifiers - Exercise #21 question
Text Data and Argument Specifiers - Exercise #31 question
Manipulating Python Strings04:13
+39 more lectures

Must-Know Python Tools

5 lectures • 31:23

Iterating Over Range Objects04:17
Nested For Loops - Introduction05:59
Triple Nested For Loops05:37
Triple Nested For Loops - Exercise #11 question
Triple Nested For Loops - Exercise #21 question
+16 more lectures

Data Gathering/Data Collection

1 lectures • 06:32

What is data gathering/data collection?06:32

APIs (POST requests are not needed for this course)

12 lectures • 37:33

Overview of APIs03:10
GET and POST Requests02:35
Data Exchange Format for APIs: JSON02:24
Introducing the Exchange Rates API04:57
Including Parameters in a GET Request03:18
+7 more lectures

Data Cleaning and Data Preprocessing

1 lectures • 05:27

Data Cleaning and Data Preprocessing05:27

pandas Series

5 lectures • 21:36

Running pandas - Exercise #11 question
.unique(), .nunique()03:49
.unique(), .nunique() - Exercise #11 question
.unique(), .nunique() - Exercise #21 question
.unique(), .nunique() - Exercise #31 question
+21 more lectures

pandas DataFrames

7 lectures • 42:33

A Revision to pandas DataFrames05:05
A Revision to pandas DataFrames - Exercise #01 question
A Revision to pandas DataFrames - Exercise #11 question
A Revision to pandas DataFrames - Exercise #21 question
A Revision to pandas DataFrames - Exercise #31 question
+49 more lectures

NumPy Fundamentals

7 lectures • 28:59

Indexing in NumPy05:51
Indexing in NumPy - Exercise #11 question
Indexing in NumPy - Exercise #21 question
Indexing in NumPy - Exercise #31 question
Assigning Values in NumPy04:16
+12 more lectures

NumPy DataTypes

4 lectures • 24:15

ndarrays09:52
Arrays vs Lists06:55
Strings vs Object vs Number07:14
NumPy DataTypes - Exercise00:14

Working with Arrays

5 lectures • 27:00

Basic Slicing in NumPy10:04
Slicing in NumPy - Exercise #11 question
Stepwise Slicing in NumPy04:58
Slicing in NumPy - Exercise #21 question
Conditional Slicing in NumPy04:51
+8 more lectures

Generating Data with NumPy

8 lectures • 32:47

Arrays of 0s and 1s05:32
NumPy - Arrays of 0s and 1s - Exercise #11 question
"_like" functions in NumPy03:13
"_like" functions in NumPy - Exercise #11 question
A Non-Random Sequence of Numbers05:02
+12 more lectures

Statistics with NumPy

9 lectures • 42:41

Using Statistical Functions in NumPy07:44
Minimal and Maximal Values in NumPy06:02
Minimal and Maximal Values in NumPy - Exercise #11 question
Statistical Order Functions in NumPy06:25
Statistical Order Functions in NumPy - Exercise #11 question
+10 more lectures

NumPy - Preprocessing

13 lectures • 01:35:18

Checking for Missing Values in Ndarrays09:23
Substituting Missing Values in Ndarrays08:29
Reshaping Ndarrays06:31
Removing Values from Ndarrays04:20
Sorting Ndarrays09:45
+8 more lectures

A Loan Data Example with NumPy

15 lectures • 01:27:40

Setting Up: Introduction to the Practical Example04:50
Setting Up: Importing the Data Set04:10
Setting Up: Checking for Incomplete Data04:35
Setting Up: Splitting the Dataset05:27
Setting Up: Creating Checkpoints02:50
+10 more lectures

The "Absenteeism" Exercise - Introduction

3 lectures • 05:04

An Introduction to the "Absenteeism" Exercise01:11
The "Absenteeism" Exercise from a Business Perspective02:19
The Dataset01:34

Solution to the "Absenteeism" Exercise

18 lectures • 01:18:11

How to Complete the Absenteeism Exercise01:57
Eyeball Your Data First05:53
Note: Programming vs the Rest of the World03:27
Using a Statistical Approach to Solve Our Exercise02:17
Dropping the 'ID' Column06:27
+13 more lectures

Data Visualization

37 lectures • 02:54:32

What Is Data Visualization and Why Is It Important?04:31
Why Learn Data Visualization?06:08
Choosing the Right Visualization – What Are Some Popular Approaches and Framewor06:58
Introduction into Colors and Color Theory08:56
Bar Chart - Introduction - General Theory and Getting to Know the Dataset01:29
+32 more lectures

Conclusion

2 lectures • 02:51

Conclusion02:22
Bonus00:29

Description

The problem

Most data analyst, data science, and coding courses miss a critical practical step. They don’t teach you how to work with raw data, how to clean, and preprocess it. This creates a sizeable gap between the skills you need on the job and the abilities you have acquired in training. Truth be told, real-world data is messy, so you need to know how to overcome this obstacle to become an independent data professional.

The bootcamps we have seen online and even live classes neglect this aspect and show you how to work with ‘clean’ data. But this isn’t doing you a favour. In reality, it will set you back both when you are applying for jobs, and when you’re on the job.

The solution

Our goal is to provide you with complete preparation. And this course will turn you into a job-ready data analyst. To take you there, we will cover the following fundamental topics extensively.

  • Theory about the field of data analytics

  • Basic Python

  • Advanced Python

  • NumPy

  • Pandas

  • Working with text files

  • Data collection

  • Data cleaning

  • Data preprocessing

  • Data visualization

  • Final practical example

Each of these subjects builds on the previous ones. And this is precisely what makes our curriculum so valuable. Everything is shown in the right order and we guarantee that you are not going to get lost along the way, as we have provided all necessary steps in video (not a single one skipped). In other words, we are not going to teach you how to analyse data before you know how to gather and clean it.

So, to prepare you for the entry-level job that leads to a data science position - data analyst - we created The Data Analyst Course.

This is a rather unique training program because it teaches the fundamentals you need on the job. A frequently neglected aspect of vital importance.

Moreover, our focus is to teach topics that flow smoothly and complement each other. The course provides complete preparation for someone who wants to become a data analyst at a fraction of the cost of traditional programs (not to mention the amount of time you will save). We believe that this resource will significantly boost your chances of landing a job, as it will prepare you for practical tasks and concepts that are frequently included in interviews.

The topics we will cover

1. Theory about the field of data analytics

2. Basic Python

3. Advanced Python

4. NumPy

5. Pandas

6. Working with text files

7. Data collection

8. Data cleaning

9. Data preprocessing

10. Data visualization

11. Final practical example


1. Theory about the field of data analytics

Here we will focus on the big picture. But don’t imagine long boring pages with terms you’ll have to check up in a dictionary every minute. Instead, this is where we want to define who a data analyst is, what they do, and how they create value for an organization.

Why learn it?

You need a general understanding to appreciate how every part of the course fits in with the rest of the content. As they say, if you know where you are going, chances are that you will eventually get there. And since data analyst and other data jobs are relatively new and constantly evolving, we want to provide you with a good grasp of the data analyst role specifically. Then, in the following chapters, we will teach you the actual tools you need to become a data analyst.

2. Basic Python

This course is centred around Python. So, we’ll start from the very basics. Don’t be afraid if you do not have prior programming experience.

Why learn it?

You need to learn a programming language to take full advantage of the data-rich world we live in. Unless you are equipped with such a skill, you will always be dependent on other people’s ability to extract and manipulate data, and you want to be independent while doing analysis, right? Also, you don’t necessarily need to learn many programming languages at once. It is enough to be very skilled at just one, and we’ve naturally chosen Python which has established itself as the number one language for data analysis and data science (thanks to its rich libraries and versatility).

3. Advanced Python

We will introduce advanced Python topics such as working with text data and using tools such as list comprehensions and anonymous functions.

Why learn it?

These lessons will turn you into a proficient Python user who is independent on the job. You will be able to use Python’s core strengths to your advantage. So, here it is not just about the topics, it is also about the depth in which we explore the most relevant Python tools.

4. NumPy

NumPy is Python’s fundamental package for scientific computing. It has established itself as the go-to tool when you need to compute mathematical and statical operations.

Why learn it?

A large portion of a data analyst’s work is dedicated to preprocessing datasets. Unquestionably, this involves tons of mathematical and statistical techniques that NumPy is renowned for. In addition, the package introduces multi-dimensional array structures and provides a plethora of built-in functions and methods to use while working with them. In other words, NumPy can be described as a computationally stable state-of-the-art Python instrument that provides flexibility and can take your analysis to the next level.

5. Pandas

The pandas library is one of the most popular Python tools that facilitate data manipulation and analysis. It is very valuable because you can use it to manipulate all sorts of information - numerical tables and time series data, as well as text.

Why learn it?

Pandas is the other main tool an analyst needs to clean and preprocess the data they are working with. Its data manipulation features are second to none in Python because of the diversity and richness it provides in terms of methods and functions. The combined ability to work with both NumPy and pandas is extremely powerful as the two libraries complement each other. You need to be capable to operate with both to produce a complete and consistent analysis independently.

6. Working with text files

Exchanging information with text files is practically how we exchange information today. In this part of the course, we will use the Python, pandas, and NumPy tools learned earlier to give you the essentials you need when importing or saving data.

Why learn it?

In many courses, you are just given a dataset to practice your analytical and programming skills. However, we don’t want to close our eyes to reality, where converting a raw dataset from an external file into a workable Python format can be a massive challenge.

7. Data collection

In the real world, you don’t always have the data readily available for you. In this part of the course, you will learn how to retrieve data from an API.

Why learn it?

You need to know how to source your data, right? To be a well-rounded analyst you must be able to collect data from outside sources. This is rarely a one-click process. This section aims at providing you with all the necessary tools to do that on your own.

8. Data cleaning

The next logical step is to clean your data. This is where you will apply the pandas skills acquired earlier in practice. All lessons throughout the course have a real-world perspective.

Why learn it?

A large part of a data analyst’s job in the real world involves cleaning data and preparing it for the actual analysis. You can’t expect that you’ll deal with flawless data sources, right? So, it will be up to you to overcome this stage and clean your data.

9. Data preprocessing

Even when your dataset is clean and in an understandable shape, it isn’t quite ready to be processed for visualizations and analysis just yet. There is a crucial step in between, and that’s data preprocessing.

Why learn it?

Data preprocessing is where a data analyst can demonstrate how good or great they are at their job. This stage of the work requires the ability to choose the right statistical tool that will improve the quality of your dataset and the knowledge to implement it with advanced pandas and NumPy techniques. Only when you’ve completed this step can you say that your dataset is preprocessed and ready for the next part, which is data visualization.

10. Data visualization

Data visualization is the face of data. Many people look at the data and see nothing. The reason for that is that they are not creating good visualizations. Or even worse – they are creating nice graphs but cannot interpret them accurately.

Why learn it?

This part of the course will teach you how to use your data to produce meaningful insights. At the end of the day, data charts are what conveys the most information in the shortest amount of time. And nothing speaks better than a well crafted and meaningful data visualization.

11. Practical example

The course contains plenty of exercises and practical cases. In the end, we have included a comprehensive practical example that will show you how everything you have learned along the way comes nicely together. This is where you will be able to appreciate how far you have come in your journey to becoming a data analyst and starting your data career.

What you get

  • A program worth $1,250

  • Active Q&A support

  • All the knowledge to become a data analyst

  • A community of aspiring data analysts

  • A certificate of completion

  • Access to frequent future updates

  • Real-world training

  • Get ready to become a data analyst from scratch

Why wait? Every day is a missed opportunity.

Click the “Buy Now” button and become a part of our data analyst program today.

Who this course is for:

  • You should take this course if you want to become a Data Analyst and Data Scientist
  • This course is for you if you want a great career
  • The course is also ideal for beginners, as it starts from the fundamentals and gradually builds up your skills

This course includes:

  • 21 hours on-demand video
  • 18 articles
  • 143 downloadable resources
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion

Instructor

365 Careers

Students also download

Explore related courses to expand your learning journey.