ये Free IBM Courses जीवन बदल देंगी | 6-Month Free Data Analyst Certification Course - YouTube

Friends you are once again welcome in a new exciting video of courses and career

today we will learn how to become data analyst in free, because google itself has launched a free online complete 6 months job oriented course on it

Data Analyst is from the top in demand skills, once you learn this you will be able to easily get a handsome salary job

because in our beloved India more than 90k job openings are vacant, there a lack of skilled candidates in this field

I have serched 3 free courses in hindi as well as english language which also includes Google and IBM courses

which you can do freely, this is not introductory course of 1-2 hours, these are complete job oriented courses

in which you will get free certificates, if you have problem in english then first learn all these in hindi language

then become certified by doing Google and IBM free courses, this video is going to be super interesting

because we will get to know in detail that who is a data analyst, what actually he does, and how you can become a professional data analyst

and that too free of cost, so without any further delay Let's Get Started!!

Friends you must have heard this, "Data is the new oil"

because like oil was used to run engines in 20th century, likewise today data is driving the economy

the more one have data and information, the more money he will have, Facebook's founder Mark Zukerberg

net worth is more than 90 billion USD, Facebook is a free platform but how it is creating such wealth

more than 90 billion USD, this is such an amount that many small countries can be purchased, because all companies want data of the users

so that they can understand their need, behaviour and can sell their product maximum through digital advertisement

and facebook has 2.5 billion active user's data, likewise this Amazon, Youtube, Google, Apple, Flipkart and thousands other compaies are there

which has lots of user based data, in today's time globally everyday 2.5 Quintillion data is being created

1 Quintillion includes 100 crore GB, think this much data is being created everyday

beacuse every person is creating 1.7 mb data on an average in every second, either is he is sharing any photo

giving any rewiew, giving a like, purchasing something, searching anything, any tweet, any email,

like from many activities you are creating on an average 1.7 MB data in your every second

like you 522 crore other people in the world is continuing creating data like this

which is getting stored in different website's database, now this raw data is semi-structured or on structured

means getting stored orderly or disorderly, analyzing this raw data useful information, facts, statics is extracted

so that companies can take the right decisions and actions for their growth and with the help of these information, facts, statics

companies easily finds out our behaviour, interest, need, and actions. Now this raw data is very vast and complex

traditional data processing, analysis systems cannot handle this, so by processing this vast raw data

for taking out useful insights Data Science, Data Analytics, Machine Learning is been used

now number of companies working with data is increasing, that's why job profile of Data Analyst, Data Scientist is increasing

this field has more jobs and less skilled candidates, if you learn any in-demand skill in a short period of time

want to get a handsome salary job very quickly then becoming a Data Analyst can be the best option for you

but before becoming something, explore the job profile in detail and see is this field, job profile suits your personality or not

can you work in this field, in this job profile passionately with dedication for a long period of time or not

now for exploring this, come let's understand who is a Data Analyst, what all daily responsibilities are there

what skills one should have and how can learn freely, after this video watch 2-3 videos on "A day in the life of Data Analyst"

also watch interviews of some data analysts, you're all pending doubts will get cleared and you will clearly get to know

that this job profile suits your personality or not, okay so exactly who is a data analyst

a data analyst collects and analyze any the specific topic given to the need of the company

and provides useful information, trends, facts, statics, on behalf of which company takes important decisions for its growth

now come let's understand in detail the responsibilities and duties of a data analyst in a company

a data analyst's first important work is to determine the organizational goals

means to work according to their need by understanding their business and goals in whichever company or organization you are working

for this, a data analyst has to work with IT team management and the company's data scientist

after this second work is data mining from the primary source to a secondary source, data analyst with the help of software, survey, and other data collection tool

collects data in a large volume and does its mining. Data Mining is a process in with the help of some software, a computational algorithm extracts large raw data

some hidden pattern is discovered in that, to make data usable, after this the third task is data cleaning

in this by analyzing massive raw data whichever incorrect, duplicated, or incomplete data is fix removed and corrected

and after this the most important task is data analyzing, we have already known about it

in this, we have to study every component of data and find out patterns, correlation, trends, to analyze the data in this

many standard statical tools like Microsoft Excel, SAS, R are being used and some programming language like Python and R programming is also used

after finally analyzing this raw data, the useful information, trends, facts, the correlation has been founded

Its clear visual report has to be made, for this data analyst uses high quality charts, graphs to present their findings in a clear concise way

with the help of this result company monitors its business, and take important decisions by seeing and understanding it

data analyst also has to maintain database and database the system, okay so we have seen who is a data analyst

what are the duties and responsibilities, come let's know how you can freely become a data analyst and that too under 6 months

becoming a data analyst and getting a job is easy compared to becoming a data scientist and getting a job

data scientists know the work of data analysts as well as these skills like maths, statics, machine learning, and strong programming

so if you are not good at maths, statics, but likes working with data, then becoming a data analyst could be the best option for you

later by gaining more experience and learning you can also become a data scientist

I have seen many data analyst's interviews who started learning with 0 and within 6 months they got the first internship as well

according to experts, these are those skills which you have to learn in order to become a data analyst, NO.1 Microsoft Excel

yes friends to become a data analyst you should know Microsoft excel, NO.2 SQL

NO.3 you should have to learn any one programming language from Python or R, learning python is easy and interesting

On most websites on the internet, Python is considered best in comparison of R, NO.4 Presentation & BI tool

BI means Business Intelligence tool like Microsoft Power BI or tableau, NO.5 Soft Skills

in which you have to improve problem solving, communication skills, and story telling skills

now let's see one by one what are the best free courses to learn these skills freely, NO.1 Excel

now to learn excel you can do this free course of IBM, "Analyzing Data with Excel", this course is freely available on edx.com, a very good course

because it itself was made by the instructors of IBM, now what all things are to be known by a data analyst in excel

so for these friends, if you search on google "Excel Functions every Data Analyst must know" so these 8 functions will come

now in excel, you have to specially learn these functions, you will not get a certificate in any free course of edx

you can access and learn complete courses freely but if want to take certificate then you have to pay this amount

just freely learn from here, you do not have to take certificate because taking excel certificate is not necessary

those who want to learn excel in Hindi the best platform for them is youtube, just go in youtube's search box and search data analyzing using excel

as soon as you search the same keyword, many mini courses and full courses will come in front of you like the one which is on number 1

is edureka's one hour, second number is of simplylearn four hours full course "Data Analytics in Excel"

both these course are in english, but as soon as you search data analysis in hindi you will see saima academy's this playlist

data analysis in excel pivot table urdu/hindi, if you go in their channel and see they have made 48 videos on this topic

from here you can learn basic to advance in hindi, you will get direct link of all these all courses & playlist video's description or in FzFacts telegram channel

those who haven't join telegram channel yet, must join now, with With the help of these 2 courses you can learn excel in Hindi & English both

now talk about other courses after excel the other skill was SQL, now for learning SQL you can do this course of khan academy

this course is completely free or can also do this course of cognitive classes "SQL and Relational Database 101"

in this, you will also get a free certificate, with the help of this two-course you will learn SQL in English

now those who want to learn in Hindi, for those there are many free courses on youtube in Hindi you can do whichever you like

like if you search SQL in Hindi, at first you will see this course of great learning, this is three hours full course in Hindi

from here you can learn in hindi, now the problem with this Hindi course is you will not get a certificate of SQL

for this you have two options, first, go on great learning academy, these all courses are free so you will see this course "SQL for Data Science"

complete this course in 2.5 hours and you will get a certificate, the second option is after learning in Hindi do this free course of cognitive classes you will get a certificate

okay so after Excel & SQL next course is programming, for this first course is "Data Analysis with Python" of cognitive classes

this course is very useful in this you will also get a free certificate and powered by IBM developer is written on the certificate

this course is in English, now for learning R programming you can do this course of the cognitive class itself "Data Analysis with R"

these all course's links will be given in description & in telegram channel, friends some data analyst job also come

in which SAS programming language's knowledge is required, SAS like python is not a free open source programming language

this is commercial and a very costly language, some bug companies use it, so after python and R if you want to learn SAS

for this, you can do this free course of great learning academy "Analytics on SAS", you will get free certificate in every free course of great learning

now those who want to learn python or R in Hindi language, for them the best platform is again youtube

friends now I'm going to tell you a very useful course google, google has launched a complete free data analysis job oriented course of 6 months

to get this course search " Data Analyst Certificate & Training Grow with Google" in your browser, you have to click on this link

you can see this is that course "Google Data Analytics Certificate", no relevant experience required, 100% remote online learning

you can complete this course by giving 10 hours every week, and see its clearly written here 'Get a job in data analytics, with the help from Google'

after completing this course, they will help you get a job with the help of google employer consortium

this course is made with google and coursera partnership, you will land on coursera.com by clicking on get started

friends this course is paid, its price is 300$, but if you want to do it freely so for that, there is a button over here named 'financial aid available'

those who can't afford free can use coursera's financial aid and do this course free of cost with a certificate

remember whenever you give an application for financial aid briefly explain your financial problem

and the main motive behind doing this course, 90% people's application get's accepted

to by this way you can do google's 6 months job oriented course free of cost, so finally we have seen hindi free courses of Excel, SQL, Data Analysis with Python/R

and also learned how to do google's complete data analytics training freely this video is getting very large

now pending some skills like storytelling, tableau for data visualization, pandas python, for data cleaning

link to free courses for these three skills is in the description, you can get from there

all these information I have collected from the data analyst's interviews, articles, and google, if you think any information is missed

then please tell in the comments, I will update through the description

so friends how was this video, hoping that you have learned something new in this video

will meet soon with a similar useful and informative the video that's all for now, Thanks For Watching!