The Complete Data Analyst Course: From Zero to Data Hero!

سرفصل های دوره

Learn how to use Excel, Python, NumPy, Pandas, Matplotlib, Seaborn, Sckit-Learn and SQL for data analysis!

1. Welcome!

1. The Complete Data Analyst Course From Zero to Data Hero!

2.1 002 - Course Materials.zip

2. Read Before Starting.html

2. Data Analysis Fundamentals and Career Path

1. Introduction to Data Analysis

2. Types of Data & The Data Analysis Stages

3. Quiz Categorising Data Types of Data.html

4. Data Analyst vs. Data Scientist & Career Path

3. Microsoft Excel Fundamentals

1. Introduction to Excel

2. Excel Basics

3. Basic Formulas and Functions

4. Working With Data - Data Tools

1. Importing Data

2. Sorting Data

3. Filtering Data

4. What-if Analysis (Goal Seek + Scenario Manager)

5. Conditional Formatting

6. Additional Excel Tools

7. Data Analysis Addon Pack

5. Working with Data - Essential Functions

1. Ultimate LOOKUP Tutorial (VLOOKUP, HLOOKUP, XLOOKUP)

2. Conditional Functions (IF, IFERROR, Nested Functions and More!)

3. Text-based Functions Part 1 (LEFT, MID, RIGHT)

4. Text-based Functions Part 2 (TRIM, CONCAT, LEN )

5. Date-time Functions

6. Mathematical Functions Part 1 (COUNTIF, SUMIF, COUNTA)

7. Mathematical Functions Part 2 (SEQUENCE, LARGESMALL, RANK and More!)

6. Microsoft Excel Data Visualisation & Graphs

1.1 data-visualisation-starter.xlsx

1. The Importance of Data Visualisation & Creating our First Chart

2. Chart Formatting + Chart Elements

3. Additional Advanced Chart Types

7. PivotTables & PivotCharts

1. Introduction to PivotTables

2. PivotTable Formatting

3. PivotCharts

8. Microsoft Excel for Data Analysis - An Example

1. Cleaning Data with Microsoft Excel

2. Data Analysis EDA with Microsoft Excel

9. Environment Setup and Overview

1.1 002 - Course Materials.zip

1. Python Anaconda Installation

2.1 002 - Course Materials.zip

2. Anaconda & Jupyter Notebook Overview

10. Python Crash Course

1. Data Types, Variables and Printing

2. Data Structures and Operators

3. If Else-if Else Statements, Loops and Functions

4. Lambda Expressions, MapFilterReduce and Modues

5. Python Practice Activities

6. Python Practice Activities Solutions

11. NumPy Basics

1. Introduction to NumPy

2. NumPy Arrays (ndarrays)

3. Indexing and Slicing

4. Universal Functions and Other Array Manipulations

5. NumPy Practice Activities Overview

6. NumPy Practice Activities Solutions

12. Pandas Fundamentals

1. Introduction to Pandas

2. Data Structures - Series

3. Data Structures - DataFrames (Part 1)

4. Data Structures - DataFrames (Part 2)

5. Grouping and Sorting Data

6. Missing Data

7. Combining Datasets

8. Dataset Operations

13. Pandas Practice Activities

1. Pandas Practice Activities Overview

2. Pandas Practice Activities Solutions

14. Matplotlib Fundamentals

1.1 Matplotlib Gallery.html

1. Introduction to Matplotlib

2. Matplotlib Fundamentals

3. Exploring Different Plot Types

4. Plot Customisation and Styling

5. Figures and Subplots

6. Matplotlib Practice Activities Overview

7. Matplotlib Practice Activities Solutions

15. Seaborn Fundamentals

1.1 Seaborn Gallery.html

1. Introduction to Seaborn

2. Seaborn Fundamentals

3. Categorical Plots

4. Matrix Plots

5. Grid Plots

6. Styling and Colour

7. Seaborn Practice Activities Overview

8. Seaborn Practice Activities Solutions

16. Python Data Analysis Example Data Loading & Cleaning

1. Project Introduction and Loading our Data

2. Cleaning our Data with Python

17. Python Data Analysis Example Exploratory Data Analysis

1. Exploratory Data Analysis with Python (Part 1)

2. Exploratory Data Analysis with Python (Part 2)

18. Python Portfolio Project

1. Python Portfolio Project Overview

2. Python Portfolio Project Solutions

19. Introduction to Machine Learning (scikit-learn)

1. Introduction to Machine Learning

2. Preparing our Data

3. Creating our Machine Learning Model (Logistic Regression)

20. SQL Essentials for Data Analysis

1. Introduction to Databases and SQL

2.1 AdventureWorks Database.html

2.2 Microsoft SQL Server Download.html

2.3 MySQL Installation Guide (macOS).html

2. Installing SQL Server + Importing our Data

3. Querying Data with SQL FROM, SELECT and WHERE

4. Effective SQL Joins, Grouping, and Aggregate Functions

5. Exporting Data from SQL

21. The End!

1. Congratulations & Next Steps

2. Accessing & Downloading your Certificate.html

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy