Skip to navigation
Skip to navigation
Skip to search form
Skip to login form
Skip to footer
Skip to main content
Accessibility options
Accessibility profiles
Visual impairment
Seizure and epileptic
Color vision deficiency
ADHD
Learning
Content adjustments
Readable font
Highlight titles
Highlight links
Stop animations
Text size
+
+ +
+ + +
Line height
+
+ +
+ + +
Text spacing
+
+ +
+ + +
Color adjustments
Dark contrast
Light contrast
High contrast
High saturation
Low saturation
Monochrome
Orientation adjustments
Reading guide
Reading Mask
Big black cursor
Big white cursor
Email: it@huph.edu.vn
Email: it@huph.edu.vn
Các khóa học
Đổi giao diện
Giao diện cũ
Giao diện mới
en
English
Data Science Courses
The Complete Data Analyst Course From Zero to Data Hero
0 students
Last updated
Jan 2025
Enrol now
Overview
Course content
Instructors
About the course
Show more...
Course content
Sections:
21
•
Activities:
0
•
Resources:
83
Expand all
Section 1
Welcome!
001 The Complete Data Analyst Course From Zero to Data Hero cYPz gitir
Section 2
Data Analysis Fundamentals and Career Path
003 Introduction to Data Analysis c3Qz gitir
004 Types of Data The Data Analysis Stages 9MHf gitir
006 Data Analyst vs Data Scientist Career Path gXVz gitir
Section 3
Microsoft Excel Fundamentals
007 Introduction to Excel 0bUb gitir
008 Excel Basics 8okk gitir
009 Basic Formulas and Functions Gm3K gitir
Section 4
Working With Data - Data Tools
010 Importing Data nePv gitir
011 Sorting Data gmJv gitir
012 Filtering Data 9izr gitir
013 What if Analysis Goal Seek Scenario Manager JgB4 gitir
014 Conditional Formatting 1XDF gitir
015 Additional Excel Tools MuoX gitir
016 Data Analysis Addon Pack 4V4T gitir
Section 5
Working with Data - Essential Functions
017 Ultimate LOOKUP Tutorial VLOOKUP HLOOKUP XLOOKUP X7zs gitir
018 Conditional Functions IF IFERROR Nested Functions and More 0G5j gitir
019 Text based Functions Part 1 LEFT MID RIGHT Tel5 gitir
020 Text based Functions Part 2 TRIM CONCAT LEN 2fWq gitir
021 Date time Functions KE7Q gitir
022 Mathematical Functions Part 1 COUNTIF SUMIF COUNTA wgpN gitir
023 Mathematical Functions Part 2 SEQUENCE LARGE SMALL RANK and More Pkng gitir
Section 6
Microsoft Excel Data Visualisation & Graphs
024 The Importance of Data Visualisation Creating our First Chart zimX gitir
025 Chart Formatting Chart Elements vWj8 gitir
026 Additional Advanced Chart Types SQJk gitir
Section 7
PivotTables & PivotCharts
027 Introduction to PivotTables ekx7 gitir
028 PivotTable Formatting moHo gitir
029 PivotCharts Ktx1 gitir
Section 8
Microsoft Excel for Data Analysis - An Example
030 Cleaning Data with Microsoft Excel Vxh4 gitir
031 Data Analysis EDA with Microsoft Excel Jb8x gitir
Section 9
Environment Setup and Overview
032 Python Anaconda Installation MdUk gitir
033 Anaconda Jupyter Notebook Overview sZsq gitir
Section 10
Python Crash Course
034 Data Types Variables and Printing 62Pg gitir
035 Data Structures and Operators P6j8 gitir
036 If Else if Else Statements Loops and Functions 5iEC gitir
037 Lambda Expressions Map Filter Reduce and Modues ZzBw gitir
038 Python Practice Activities DmY0 gitir
039 Python Practice Activities Solutions J7fC gitir
Section 11
NumPy Basics
040 Introduction to NumPy PgY4 gitir
041 NumPy Arrays ndarrays FwrE gitir
042 Indexing and Slicing uOui gitir
043 Universal Functions and Other Array Manipulations 7klb gitir
044 NumPy Practice Activities Overview qHwV gitir
045 NumPy Practice Activities Solutions YJ0W gitir
Section 12
Pandas Fundamentals
046 Introduction to Pandas jg0X gitir
047 Data Structures Series JeAm gitir
048 Data Structures DataFrames Part 1 NieQ gitir
049 Data Structures DataFrames Part 2 oOCR gitir
050 Grouping and Sorting Data ynl3 gitir
051 Missing Data Uyon gitir
052 Combining Datasets k6Qs gitir
053 Dataset Operations JaE0 gitir
Section 13
Pandas Practice Activities
054 Pandas Practice Activities Overview T8kn gitir
055 Pandas Practice Activities Solutions GI9a gitir
Section 14
Matplotlib Fundamentals
056 Introduction to Matplotlib vKug gitir
057 Matplotlib Fundamentals LV0U gitir
058 Exploring Different Plot Types gtKk gitir
059 Plot Customisation and Styling UuSy gitir
060 Figures and Subplots tPeM gitir
061 Matplotlib Practice Activities Overview x4C6 gitir
062 Matplotlib Practice Activities Solutions H54z gitir
Section 15
Seaborn Fundamentals
063 Introduction to Seaborn 10cq gitir
064 Seaborn Fundamentals FYxA gitir
065 Categorical Plots ti89 gitir
066 Matrix Plots uk5N gitir
067 Grid Plots kb99 gitir
068 Styling and Colour eIHH gitir
069 Seaborn Practice Activities Overview JSAi gitir
070 Seaborn Practice Activities Solutions WZ39 gitir
Section 16
Python Data Analysis Example – Data Loading & Cleaning
071 Project Introduction and Loading our Data LK8J gitir
072 Cleaning our Data with Python gDw8 gitir
Section 17
Python Data Analysis Example – Exploratory Data Analysis
073 Exploratory Data Analysis with Python Part 1 i3X6 gitir
074 Exploratory Data Analysis with Python Part 2 tkP3 gitir
Section 18
Python Portfolio Project
075 Python Portfolio Project Overview mQai gitir
076 Python Portfolio Project Solutions ZFKv gitir
Section 19
Introduction to Machine Learning (scikit-learn)
077 Introduction to Machine Learning wACK gitir
078 Preparing our Data NtaR gitir
079 Creating our Machine Learning Model Logistic Regression VMhq gitir
Section 20
SQL Essentials for Data Analysis
080 Introduction to Databases and SQL Ct2n gitir
081 Installing SQL Server Importing our Data KGRV gitir
082 Querying Data with SQL FROM SELECT and WHERE 7ug6 gitir
083 Effective SQL Joins Grouping and Aggregate Functions qbyd gitir
084 Exporting Data from SQL roXR gitir
Section 21
The End!
085 Congratulations Next Steps WaXh gitir
Instructors
Enrolment options
The Complete Data Analyst Course From Zero to Data Hero
Course modified date:
11 Jan 2025
Enrolled students:
There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Continue
Enrol now
This course includes
Resources
Share this course
Scroll to top
×
Close
×
Close