🚀 GOOGLE Data Analyst Roadmap l For Absolute Beginners l 2 Months Strategy #dataanalytics #google

Summary

The 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

00:00

😊 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.

05:02

😃 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.

Keywords

💡data analytics

Data analytics refers to the analysis of data to discover useful information and support decision-making. In the video, the presenter aims to provide essential resources to become a data analyst and describes the data analytics process including preparing, processing, analyzing, and sharing data.

💡Excel

Excel is a widely used spreadsheet program and an important tool for data analysts. The presenter recommends an Excel course on Coursera to learn essential, intermediate, and advanced Excel skills like working with numbers and data.

💡SQL

SQL (Structured Query Language) is a standard programming language used to manage and analyze data in databases. The presenter emphasizes that SQL is a very important skill for data analysts and suggests a SQL basics course on Khan Academy.

💡Python

Python is a popular programming language used for data analysis and manipulation. The presenter offers the choice between Python or R and suggests a Python specialization course on Coursera focused on basics and data structures.

💡data visualization

Data visualization refers to representing data graphically to make insights and trends clearer. The presenter recommends learning Power BI, a data visualization tool, through a certification course.

💡data preparation

Data preparation involves cleaning, transforming, and consolidating raw data to prepare it for analysis. It's an early stage in the data analytics process covered in the suggested Google certificate course.

💡data processing

Data processing means performing operations on data to convert it into a more usable format. According to the video, it follows data preparation in the data analytics workflow.

💡data analysis

Data analysis means inspecting, cleaning, transforming and modeling data to discover useful information and support decision-making. The video depicts it as the next phase after processing data.

💡data sharing

Data sharing means making data available to relevant stakeholders through visualizations, reports, and other mediums. The presenter relates it to creating data visualizations.

💡capstone project

A capstone project allows learners to integrate and apply skills gained during a program or course. Both the Google certificate and Python Coursera courses suggested include capstone projects.

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