🚀 GOOGLE Data Analyst Roadmap l For Absolute Beginners l 2 Months Strategy #dataanalytics #google
Summary
TLDRThe video introduces essential free resources to learn data analytics skills for beginners. It recommends a Google professional certificate course to understand data analytics concepts, Excel specialization courses on Coursera to master Excel, a Khan Academy SQL course to learn SQL basics, a Coursera Python specialization to learn Python programming, and a Power BI certification course to learn data visualization. It provides an effective learning path, from basics to advanced skills, to become job-ready as a data analyst.
Takeaways
- 😊 The speaker works at Google in the data analytics domain and wants to share essential free resources to become a data analyst
- 📊 The key skills needed to become a data analyst are: Excel, SQL, Python/R, and data visualization tools like Tableau/Power BI
- 🎓 The Google Data Analytics Professional Certificate course provides an overview of the data analytics process and skills
- 👨💻 To learn Excel, the Excel Skills for Business Specialization course on Coursera is recommended
- 🐍 SQL is very important for data analysts. Scan Academy's SQL course is great for beginners
- 🐍 For learning Python, the Python for Everybody specialization course on Coursera is suggested
- 📈 For data visualization, the Power BI course from Microsoft covers analysis with Excel and data modeling
- 🔗 All course links are provided in the video description
- 💡 You can audit Coursera courses for free without paying for certificates
- 💬 Feel free to reach out to the speaker over LinkedIn/Instagram for any doubts
Q & A
What are the four key skills one needs to master to become a data analyst according to Haran?
-The four key skills are: Excel, SQL, a programming language like Python or R, and a data visualization tool like Tableau or Power BI.
What was Haran's background before he started learning data analytics skills?
-Haran had a mechanical engineering background and was preparing for the UPSC exams. He had taken a 2.5 year break and had zero coding knowledge when he started learning data analytics.
Which course does Haran recommend for learning Excel skills?
-Haran recommends the 'Excel Skills for Business Specialization' course on Coursera which has four modules - Essentials, Intermediate 1, Intermediate 2, and Advanced.
Why does Haran emphasize learning SQL skills?
-Haran says SQL skills are very important to work in the data analytics domain. He uses SQL a lot in his role at Google.
Which Python course does Haran suggest for beginners?
-Haran suggests the 'Python for Everybody Specialization' course on Coursera for learning Python, especially for beginners.
What options does Haran provide for learning data visualization skills?
-Haran suggests learning either Power BI using Microsoft's Power BI Certification course, or Tableau.
Why does Haran recommend auditing some of the paid Coursera courses?
-Haran says the main objective should be learning skills rather than getting certificates. So auditing allows you to complete courses without paying if you don't need the certificate.
What resources does Haran provide for getting help?
-Haran provides his LinkedIn and Instagram handles to reach out to him to get doubts clarified.
Does Haran have any prior experience in data analytics?
-No, Haran was completely new to data analytics. He says he was at zero when he started learning data analytics skills.
What project does the Google Data Analytics Certificate course contain?
-The Google Data Analytics Certificate course contains a capstone project at the end to implement the skills learned throughout the program.
Outlines
😊 Introducing Useful Free Online Courses for Learning Data Analytics
The paragraph introduces Haran who works at Google in data analytics. He shares free online courses based on his and his friends' recommendations to learn data analytics without spending money. The key skills needed are Excel, SQL, Python/R programming, and data visualization tools like Tableau or Power BI. The Google Data Analytics Professional Certificate covers the basics of the field.
😃 Recommended Courses for Each Key Data Analytics Skill
The paragraph provides specific course recommendations on Coursera and Khan Academy to learn each key skill - Excel, SQL, Python programming, and Power BI data visualization. It emphasizes learning skills over getting certificates. Links to the courses are in the video description.
Mindmap
Keywords
💡data analytics
💡Excel
💡SQL
💡Python
💡data visualization
💡data preparation
💡data processing
💡data analysis
💡data sharing
💡capstone project
Highlights
The key skills to master to become a data analyst: Excel, SQL, Python/R, data visualization tools
The Google Data Analytics Professional Certificate provides an overview of the data analysis process
The Excel Skills for Business Specialization on Coursera helps master Excel
SQL is very important to work in data analytics
Khan Academy's SQL course is great for beginners with videos and practice questions
Python is useful for data manipulation in data analysis
Python for Everybody Specialization on Coursera teaches Python from basics
Learning a data visualization tool like Power BI or Tableau is key
Microsoft Power BI course on Coursera covers analysis, ETL, modeling
Links to all the course recommendations are in the video description
Focus should be on learning skills over getting certificates
You can audit Coursera courses for free without paying
Reach out on LinkedIn or Instagram for any doubts
Learning the skills is what will be tested, not certificates
Check video description for course links
Transcripts
hello everyone I'm haran I work in the
DAT analytics domain at Google in this
video we'll be seeing the essential
resources which would be required to
become a data analyst and when I was in
the Journey of learning the skills I
reached out to my friends who work in
the domain of data analytics and also to
my sister who works in the tech industry
they all suggested me that I can learn
more skills without spending a rupee on
online platforms where you can learn it
for free so I just took that as a
challenge and I found the resources
which helped me to learn the skill sets
which is required to become a data
analyst so I'll be sharing you those
courses right
now so the key skills which you need to
master to become a data analyst would be
these four things one is Excel SQL
programming language like python or R
and a data visualization tool like tblo
or powerbi so we'll be seeing every
course for each topic so to start with
since we are freser like for me I I was
having a break of 2.5 years because of
preparation for upsc and also I had a
mechanical background where I had like
zero coding so I had to start from the
scratch I didn't know anything about
data analytics so I was a zero in this
and I had to start from the scratch so I
took this course on ker called Google
data analytics professional certificate
which will give you every basic idea
about what is data analytics what a data
analyst does and how is the process of a
data analyst look like so I'll show you
the course right now
so uh these are the different modules in
the course uh the first one is the basic
introduction to how what is data and how
data works and it operates in the module
of of like different skill sets in each
program so the first is to ask right
questions you can expand on this and you
can see uh the different things which
you will learn in this course and
further like how to prepare the data so
a data's life cycle is fully replicated
in this program so it's like first you
prepare the data then you process the
data and then you analyze the data then
sharing the data it means making
visualizations out of the data and you
have a art programming course included
in this you can also Learn Python if you
want parallely and also there's a capon
project in the end which would help you
to implement all the skills which you
have learned throughout the
program so this is for the basics so
next I would start with Excel because
that is a common tool which you had
which you would have been interacted
from our uh school days so it's pretty
much exploring more deeper into Excel so
I would suggest this course on corsera
which is Excel skills for business
specialization this course has four
modules namely I'll show you
that so the first is Essentials then the
intermediate one intermediate 2 and
advanced like these four courses are
pretty good so if you do these courses
you'll get really mastered in Excel and
it's pretty exciting and interesting to
work with Excel and numbers and they
have like excellent practice modules in
these courses which will help you
practice the skills which they teach you
teach you in the uh courses
also and the next course is the next
skill set which you have to learn is SQL
so SQL is very important to work in the
domain of data analytics even when I
work at Google I use SQL a lot here so
this is a very important skill to master
to become a data analyst so to start
with like pretty basic you know nothing
about programming you know nothing about
coding you just have to start SQL so
this is the right place to start it's
scan Academy SQL
course so this course has like very
small 3 minute four 4 minute videos and
also they have practice questions at the
end of each video so you can learn the
skill you can practice and this is for
pretty much who wants to know from the
basics of SQL so this explains like
every basic things up to group by which
can be used in data analytics process uh
so to learn Advanced you can do it later
but for starting with the basic this is
the best
course and the next skill which you have
to acquire where is python or R
programming and it is your choice you
can choose either python or R to work in
data domain it will be used much for
data manipulation and you'll get to know
that later when you do the course so
this is more about a python course this
is the python every for everybody
specialization course which is a very
well known course for learning python
for beginners this is also from
coera so this course is also structured
in different modules so first initially
you'll be learning the basics then
you'll be learning the data structures
then you'll be using python to do
different uh uh different
functionalities in the later and you
also have a capson project in this where
you can implement the skills which you
have learned in the
program and and then the last skill
which you would like which you should
Master is a vis data visualization tool
it can either be powerbi or Tablo so
this is the powerbi certification from
Microsoft itself they own the tool and
they have also have a course on this on
course app you can also look into this
course this course also pretty much
starts starts with analysis with Excel
and later it goes to powerbi and it also
teaches about the ETL process in data
analytics and also data modeling and you
can see there's also like material to
learn for the pl 300 exam which is known
well in the DAT domain for showing Your
Excellence in the uh skill set of
powerbi so these are the courses which I
would suggest and you can find all the
links of all these courses in the
description and if you have any doubts
regarding any of these courses how to
take and I would say that like you would
find these courses to be paid on corser
but you can do it without paying if you
don't need a certificate you can just
audit the course and you can complete
the scor so the main objective should be
learning the skill rather than getting a
certificate so you can have a lot of
certificates on your resume but the
skills will be tested at the end of the
day so learning the skills is very
important so you can do this on corser
and KH Academy is for free so you can
audit the course and get this done so
the links are in the description you can
check them out and you can reach out to
me on LinkedIn or on Instagram I will
clear your doubts if you have any thank
you
استعرض المزيد من الفيديوهات ذات الصلة
Data Analytics: La MEJOR RUTA para aprenderlo en 2023
The Exact Skills and Certifications for an Entry Level Machine Learning Engineer
Introduzione interfaccia - EXCEL TUTORIAL ITALIANO 01 [Corso 2024]
Introduction to Python for Data Science
Curso de Programação Básico - Estruturas de dados heterogêneas
3 Developer Roadmaps That Actually Work
5.0 / 5 (0 votes)