Data Analyst Full Course in 11hrs | Data Analyst Roadmap in 2024

Learn the essentials of Data Analytics with our 11-hour course. This video covers the role and skills of a Data Analyst and its importance. It includes key statistics, SQL, and Python concepts, using libraries like NumPy, Pandas, Matplotlib, and Seaborn. You’ll also see how to use Excel for data analysis, create visuals with Tableau, and build machine-learning models. Additionally, the video shows how Generative AI and ChatGPT can enhance data analytics.

🏁 Topics Covered:
00:00:00 Introduction
00:01:39 Who is Data Analyst and their Key Roles
00:06:36 Real-world Applications
00:07:21 Introduction to Data Analytics
00:07:55 What is Statistics?
00:24:24 Inter-quartile Range
00:30:48 Box-plot - 5 number summary
00:37:49 Data cleaning using Excel
00:43:00 Functions in Excel
00:45:05 Types of Functions in Excel
00:55:16 Sort and Filter
01:01:05 Data Validation in Excel
01:09:52 Pivot Table in Excel
01:19:56 Data Visualization using Excel
01:35:57 SQL - Introduction and Installation
01:38:14 Data Types in SQL
1:41:06 Hands-on based on HR Database Management System
2:37:02 Python Numpy Array
2:43:36 Numpy Methods
2:57:28 Numpy Array Mathematics
3:04:54 Numpy Matrix
3:11:25 Numpy Save and Load
3:13:23 Pandas- Introduction
3:13:54 Pandas Series Object
3:16:08 Pandas- Changing Index
3:17:25 Pandas- Series object from Dictionary
3:27:14 Pandas- Dataframe in-built Function
3:30:00 Pandas- iloc and loc function
3:33:42 Pandas- Dropping Rows and Column
3:37:39 Matplotlib Library
3:37:51 Matplotlib Line Plot
3:51:55 Matplotlib- Barplot
3:58:18 Matplotlib- Scatter plot
4:06:11 Matplotlib Histogram
4:12:54 Seaborn Line plot
4:21:17 Seaborn Barplot
4:29:01 Seaborn Scatterplot
4:34:16 Seaborn Histogram/Distplot
4:41:30 Tableau- Introduction
4:47:37 Tableau Architecture
4:49:10 Tableau Dashboards
5:05:41 Regression and its Use cases
5:08:30 Types of Regression [Linear Regression and Multiple Linear Regression]
5:18:20 Hands-on Linear Regression and MLR
5:37:43 Case study on Salary Expectation
6:11:35 Logistic Regression and its use cases
6:17:38 Credit card fraud detection using Logistic Regression
6:53:01 Naive Bayes Algorithm
7:02:16 Diabetes Prediction using Naive Bayes
7:28:03 Decision Tree
7:31:16 Decision Tree - CART
7:35:27 How are Decision Tree built?
7:42:04 Hands-on Decision Tree
8:14:49 Bagging and Random Forest
8:19:40 Hands-on Random Forest
9:07:56 Hierarchical Clustering
9:20:56 Types of Hierarchical Clustering
9:26:10 Agglomerative Hierarchical Clustering- Working
9:34:52 Distance formulas for Clustering [Eucledian Distance; Manhattan Distance; Minkowski Distance; Jaccard Similarity Coefficient]
9:50:37 Finding Optimal Numbers of Clustering
9:54:44 Generative AI- Introduction
9:57:12 Discriminative vs. Generative AI
9:59:40 How Gen AI Works?
10:00:43 Types of Generative AI
10:01:26 ChatGPT Basics
10:02:06 Introduction of Data Analysis using ChatGPT
10:15:05 Loading the Dataset
10:24:15 Data Analysis Project using ChatGPT
11:26:09 Data Analysis Project using Python
11:37:28 Summary

#dataanalyticscourse #dataanalysis #dataanalytics #dataanalyticsroadmap

⚡ About Great Learning:
With more than 11 Million+ learners in 170+ countries, Great Learning is a leading global edtech company for professional and higher education offering industry-relevant programs in the blended, classroom, and purely online modes across technology, data, and business domains. These programs are developed in collaboration with top institutions like Stanford Executive Education, MIT Professional Education, Wharton, University of Arizona, Northwestern University, The University of Texas at Austin, NUS, Microsoft & more.

🔹 For more updates on courses and tips follow us on:

[Justlikethat-sjxz]

The section on Excel data visualization was spot on! Loved the hands-on examples for different chart types.

[debaratisarkar]

I appreciate the SQL segment, especially the hands-on HR database management—so practical!

[bhavya.shetty]

Data cleaning using Excel is so underrated. This video makes it look so easy!

[MahimaSrivastava-kn]

The section on Generative AI was really interesting. Love how it’s integrated into Data Analytics.

[andyjohnson]

Not bad. I studied statistics in the university. And this vid is explaining it fast

[PratikSarkarJOY]

Tableau dashboards section is gold! Perfect for anyone looking to level up their data visualization skills.

[chaitrabalraj]

Logistic Regression for credit card fraud detection? Super relevant in today’s data world .

[surabhimukherjee]

Learning pandas was amazing... Indeed a powerful tool in python

[Akash-Kumar.fsc]

@30:39 The inter quartile range is 3.25vsir but you mistakenly calculated wrong.

[riav]

Please bring one course for HR Analytics

[devaraju]

Hi Mam, My question is that for freshers is there any openings on data analyst, actaully i am learning a powerbi and sql and advanced excel from past 2 months, but my quesation is companies are hiring the freshers are not.

[Yuktabansal-fv]

could you provide the dataset used in the video so we could practice side by side

[ayaniegain]

is data analyst is really high demand or just a hype? I'm not able to find that much of opening ! compare to development or else. how is it please explain?

[michelcusson]

Can I use apple instead of window to follow the course?

[technicalgyan]

Please provide a dateset link as well if possible

[sakshi]

Anyone please guide me I've done graduation and I want to start a new journey

[vigneshm]

Mam is this same course available in Great learning for free for certification purpose

[Kalyanigoud]

Is python is necessary for data analytics plzzz reply me

[sakshi]

Please suggest me a course please anyone

[devaraju]

Hi mam, My question is that for freshers is there any openings on data analyst, actaully i am learning a powerbi and sql and advanced excel from past 2 months, but my quesation is companies are hiring the freshers are not.