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.
Learn Data Analytics using Excel, understand the key phases of a Data Analytics project, Data Cleaning, and explore essential Excel functions that support your data analytics journey. www.mygreatlearning.com/academy/learn-for-free/courses/data-analytics-using-excel?CPV_YT&Desc&DtAnlystFllCrsin11hrs_2024
Earn a prestigious Data Science certificate from MIT Professional Education. Enroll now and elevate your skills! www.mygreatlearning.com/mit-data-science-program?CPV_YT&PPDesc1&DtAnlystFllCrsin11hrs_2024
Jumpstart your career in Data Science with our course designed for freshers. Apply now to learn more! www.mygreatlearning.com/pg-program-data-science-course?CPV_YT&PPDesc2&DtAnlystFllCrsin11hrs_2024
🏁 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
🔥1000+ Free Courses With Free Certificates: www.mygreatlearning.com/academy?CPV_YT&Desc&YTVids2024
⚡ 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:
✅ Telegram: t.me/GreatLearningAcademy
✅ Facebook: GreatLearningOfficial/
✅ LinkedIn: www.linkedin.com/school/great-learning/mycompany/verification/
✅ Follow our Blog: glacad.me/GL_Blog

[@greatlearning]

Thanks for watching! If you enjoyed the video, explore our "Data Analytics using Excel" course and earn a certificate upon completion. Check it out here! www.mygreatlearning.com/academy/learn-for-free/courses/data-analytics-using-excel?CPV_YT&Comment&DtAnlystFllCrsin11hrs_2024

[@Justlikethat-sj4xz]

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

[@PratikSarkarJOY]

Totally agree! I’ve always struggled with creating meaningful visuals, but this made it so much clearer.

[@MahimaSrivastava-k4n]

Same here! The tree chart and map chart tutorials were particularly useful for my projects.

[@PratikSarkarJOY]

I also liked how the video covered pivot tables they're such a powerful tool in Excel.

[@ayaniegain]

sir, can one tell me is it worth it to learn data analyst this time? shall i get a job after making some project and skills. ! is it demanding or should i learn development! my interest more on analyst side

[@MahimaSrivastava-k4n]

The detailed walkthroughs for each chart type were amazing. Makes it much easier to apply in real-life scenarios.

[@debaratisarkar1199]

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

[@greatlearning]

Thanks for your appreciation. Explore Great Learning Academy for more such informative content. www.mygreatlearning.com/academy?CPV_YT&Comment_reply&YTVids2024

[@bhavya.shetty]

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

[@MahimaSrivastava-k4n]

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

[@greatlearning]

Thanks for your appreciation. Explore Great Learning Academy for more such informative content. www.mygreatlearning.com/academy?CPV_YT&Comment_reply&YTVids2024

[@andyjohnson9714]

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.

[@greatlearning]

We're thrilled to hear that you enjoyed the video and found it detailed and well-delivered. Your feedback means a lot to us. Stay tuned for more informative content!

[@surabhimukherjee8272]

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

[@greatlearning]

We're thrilled to hear that you enjoyed the video. Stay tuned and subscribe for more informative content! www.youtube.com/@greatlearning

[@hubertz.6560]

Great content ❤

[@Akash-Kumar.fsc2]

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

[@chaitrabalraj5080]

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

[@greatlearning]

Yes it is, Stay tuned and subscribe for more informative content! www.youtube.com/@greatlearning

[@Yuktabansal-f7v]

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

[@GoodLuck20s]

Python explained well🎉

[@GoodLuck20s]

Numpy explained well

[@devaraju1892]

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.

[@ZeeDimensionYouTube]

nice video

[@technoscopy]

Great

[@greatlearning]

Thanks for your appreciation. Explore Great Learning Academy for more such informative content. www.mygreatlearning.com/academy?CPV_YT&Comment_reply&YTVids2024

[@riav1845]

Please bring one course for HR Analytics

[@greatlearning]

Sure, thanks for your suggestion. We will definetely plan for this in future. Till then explore Great Learning Academy - www.mygreatlearning.com/academy?CPV_YT&Comment_reply&YTVids2024

[@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?

[@greatlearning]

Data analysts are in demand, but the market is competitive. Companies often prioritize developers for immediate needs, but as data-driven decision-making grows, the demand for skilled data analysts is expected to increase. It might not be hype, but finding the right opportunities can take time.

[@valentineowuor5615]

Course files for practice please?

[@Sukhendra_kewat]

Please provide a dateset link as well if possible

[@greatlearning]

We do not provide data set links. However, we do have many data related course on Great Learning Academy wth Data sets - Explore Great Learning Academy for more such informative content. www.mygreatlearning.com/academy?CPV_YT&Comment_reply&YTVids2024

[@RandomPerson-uf1ft]

Can we get access to data files

[@michelcusson2673]

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

[@devendirans6900]

Fresher ku opening irruka data analyst ku

[@mahendrapabbathi4621]

Where we can find csv files

[@pranjalmishrapandit]

i want this course in hindi

[@Zeebarback.]

you can search in hindi will get a lot of courses on youtube watch 3 or 4 different courses so become pro in it

[@FatemaAli-boss]

in hindi😍

[@greatlearning]

Thanks for your suggestion! We'll plan to create such content in the future. Meanwhile, explore our KZbin channel for more content in Hindi. www.youtube.com/@greatlearning

[@underdog9112]

1:41:34

[@durgeshsingh02]

Plz upload Data analytics in hindi

[@greatlearning]

Thanks for your suggestion! We'll plan to create such content in the future. Meanwhile, explore our KZbin channel for more content in Hindi. www.youtube.com/@greatlearning

[@aqibrazzaq2534]

How can I get this course on great learning app ?

[@mohamedfardeen5146]

Anyone finished this course??

[@vigneshm8955]

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

[@greatlearning]

We have many more free and informative courses, on Data Analytics. Explore Great Learning Academy www.mygreatlearning.com/academy?CPV_YT&Comment_reply&YTVids2024

[@cretive549]

please data engineer

[@sangavichinnadurai3711]

Plz upload in tamil

[@greatlearning]

Thanks for your suggestion! We'll plan to create such content in the future. Meanwhile, explore our KZbin channel for more content. www.youtube.com/@greatlearning

[@sakshi99304]

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

[@greatlearning]

I'm sure you will be able to find the correct guidance in time. Meanwhile, explore our KZbin channel for more content. www.youtube.com/@greatlearning

[@chiranjeevivalapadas4168]

01:39

[@Kalyanigoud90]

Is python is necessary for data analytics plzzz reply me

[@mulikinatisiddarthasiddu8245]

Its the main one man

[@ManojIrala]

Topics are spot on and regression concepts and explanation was worsee she's just reading bla bla

[@mahaadevA-ut8ru]

@greatlearning if you upload those sample worksheets which you worked in it,it would be great help

[@sakshi99304]

Please suggest me a course please anyone

[@greatlearning]

You can find multiple course on Great Learning Academy, check it out - www.mygreatlearning.com/academy?CPV_YT&Comment_reply&YTVids2024

[@FatemaAli-boss]

😍

[@greatlearning]

We're thrilled to hear that you enjoyed the video and found it detailed and well-delivered. Your feedback means a lot to us. Stay tuned for more informative content!

[@GoodLuck20s]

5:45:47 is irritating

[@devaraju1892]

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.

[@authenticagriculture]

Did you get job