Skills Needed For Data Scientist and Data Analyst




[ad_1]

If this video is helpful to you, you can support this channel to grow much more by supporting on patreon : https://www.patreon.com/artofengineer

Data Analyst does a lot of descriptive analytics. On the other hand, Data Scientist also does descriptive analytics. But also data scientists do something called
predictive analytics.

So let’s try to understand what Descriptive and Predictive analytics mean.

Descriptive Analytics is all about analyzing the historical data to answer this particular question which is “WHAT HAS HAPPENED TILL NOW??”.

Predictive Analytics also involves analysis of historical data but, predictive analytics is mainly all about answering the question
which is.. “WHAT WILL HAPPEN IN THE FUTURE??”

Let’s understand this with a simple example.
I have sales data of XYZ company in a table format.

As part of descriptive analytics, we can simply create a scatter chart so that we can quickly understand how the company has been performing
in terms of sales in the previous years.

Now let’s look at predictive analytics. So now that we know how the company has been performing in the previous years, can we predict what’s gonna
happen to the sales in the coming years?.. Will the sales increase, or decrease or does it remain the same??..
If we are able to answer these questions, then it is called as predictive analytics.

So coming back to the comparison of Data Analyst and Data Scientist roles,
Now that we have some idea about the differences between the two roles, lets now look at skills needed for each of these two roles.

Data Analysts should be good with Math and Statistics.
They should be good with handling the data.
— This includes knowledge of ETL (or Extract Transform and Load) operations on data and experience working with popular
ETL tools such as Informatica – PowerCenter,IBM – Infosphere Information Server, alteryx,
Microsoft – SQL Server Integrated Services (SSIS), Talend Open Studio, SAS – Data Integration Studio
,SAP – BusinessObjects Data Integrator, QlikView Expressor or any other popular ETL tool.
— They should be comfortable in handling data from different sources and
in different formats such as text, csv, tsv, excel, json, rdbms and others popular formats.
— They should have excellent knowledge of SQL (or Structured Query Language).

Its a Bonus to have
— The knowledge of Big data tools and technologies to handle large data sets.
— NoSQL databases such as HBase, Cassandra and MongoDB.
They should be expert in Analysing and Visualizing the data.
— They Should have experience working with popular data analysis and visualization packages in python and R
such as numpy, scipy, pandas, matplotlib, ggplot and others.
— Experience with popular data analysis and visualization BI tools such as Tableau, Microsoft Power BI, SAP BI, SAS BI, Oracle BI, QlikView or any other
popular BI tool
They should have good communication and storytelling skills.

Lets now look at the skills needed for data scientist role.

Data scientist also does descriptive analytics just like data analysts. Apart from that, they also do predictive analytics.

So as part of Descriptive analytics:
Data Scientists should be excellent with Math and Statistics.
Data scientists should be good with handling data
— So yes, they should have experience working with popular ETL frameworks.
— They should have excellent knowledge of SQL.
— Many companies expect data scientists to have mandatory knowledge of big data tools and technologies to
work with large datasets and also to work with structured, semi-structured and unstructured data.
— Its good to have the knowledge of NoSQL databases such as HBase, Cassandra and MongoDB.
They should be expert in Analysing and Visualizing the data.
— Experience working with popular data analysis and visualization packages in python and R.
— Experience with popular data analysis and visualization BI tools such as Tableau, Microsoft Power BI, SAP BI, SAS BI, Oracle BI, QlikView or any other
popular BI tool.
They should also have excellent communication and storytelling skills.

And as part of predictive analytics,
They should be good in using the techniques in artificial intelligence, data mining, machine learning, and statistical modeling to make
future predictions using the historical data.
Exposure to popular predictive analytics tools such as SAP Predictive analytics, Minitab, SAS Predictive Analytics, Alteryx Analytics, IBM
predictive analytics or any other popular predictive analytics tool.
They should have very good exposure to popular machine learning and deep learning packages available for Python and R such as
scikit learn, tensorflow, theano,rpart, caret, randomForest, nnet, and other popular libraries.

Source


[ad_2]

Comment List

  • Art of Engineer
    November 27, 2020

    Data science is vast topic,it include lots of software for instance deeplearming&neural network itself have infinite topics&algoritms to master & so on
    In my opinion if someone want to start career in data science it,s better to focus in one part &became master on that sub-field or software
    Along the way learn other topics

  • Art of Engineer
    November 27, 2020

    Very nicely explained bro

  • Art of Engineer
    November 27, 2020

    very interesting thank you

  • Art of Engineer
    November 27, 2020

    good aspect

  • Art of Engineer
    November 27, 2020

    what program did u use ?? for video

  • Art of Engineer
    November 27, 2020

    Amazing video

  • Art of Engineer
    November 27, 2020

    Amazing video

  • Art of Engineer
    November 27, 2020

    Sama dia artificial intelligence,machine learning dan predictive learning dgn S2.bg,q pakai R saja gk usah pakai python.

  • Art of Engineer
    November 27, 2020
  • Art of Engineer
    November 27, 2020

    I THINK YOU GOT IT WRONG

  • Art of Engineer
    November 27, 2020

    Sir your explanation is very clear

  • Art of Engineer
    November 27, 2020

    Totally Wrong If you Know the Python there is NOOOOO NEEEEEED to learn corrosponding tools

  • Art of Engineer
    November 27, 2020

    Data Science Bootcamp for K-12 Students

    https://youtu.be/ji6XDLHdvFA

  • Art of Engineer
    November 27, 2020

    If you don’t have math background, is it impossible to be a data analyst?

  • Art of Engineer
    November 27, 2020

    Yes! 🏳️‍🌈

  • Art of Engineer
    November 27, 2020

    Thank you so much!

  • Art of Engineer
    November 27, 2020

    Hi, thanks for showcasing and explaining very clearly the difference btw DA vs DS. FYI, i am just moving into DA/DS from traditional Biz Dev position pass 25 yrs. thanks hope you'll continue to produce such great videos.

  • Art of Engineer
    November 27, 2020

    Very nice helpful and informative video and It's a very clear and understandable presentation .Thank You!

  • Art of Engineer
    November 27, 2020

    Data will get from different sources and different format Excel,CSV,TSV, Json,DBMS format

  • Art of Engineer
    November 27, 2020

    According to what I've learned about Data Analytics, is that it's not as important to master Python and/or R (with all it's packages and libraries), since that's more important for the job role of the Data Scientist.

  • Art of Engineer
    November 27, 2020

    are bhai itna sara padhna padega😁

  • Art of Engineer
    November 27, 2020

    When aap jarort se jyada research krlete ho toh 😂😂

  • Art of Engineer
    November 27, 2020

    I want to be data scientist I learn SQL
    Then what is the next tool

  • Art of Engineer
    November 27, 2020

    I want to become a data scientist. I don't have a high mathematical background except for 'o'- level math in high school. What courses do I need to start with? Where do you recommend me taking these courses? Thanks

  • Art of Engineer
    November 27, 2020

    I believe that the difference between DA and DS is all about AI and ML no/yes. In my experience being a data analyst means also doing predictions with statistical techniques (via complex GLMs for example), not just describing patterns. It seems to me that AI is just fashionable nowadays and the services provided by a good statistician are often not considered in job ads.

  • Art of Engineer
    November 27, 2020

    Tq😊❤

  • Art of Engineer
    November 27, 2020

    wonderful

  • Art of Engineer
    November 27, 2020

    Sign up and get free register yourself to learn DataSciecne
    https://youtu.be/jbVF4G_Bilg

  • Art of Engineer
    November 27, 2020

    How about the salary, is it better than software engineer?

  • Art of Engineer
    November 27, 2020

    what is difference between big data and data analysis

  • Art of Engineer
    November 27, 2020

    Sir i am 2017 btech cs passout i have worked as automation tester for 14 months now i want to do ms in data analytics plz suggest.

  • Art of Engineer
    November 27, 2020

    I hope someone will answer. Which IT job is kinda dull and boring, where you do the same thing everyday, where you don't have to be creative? I am like that haha. I want to get into IT, since it's something you can do from home and it's decent money.

  • Art of Engineer
    November 27, 2020

    For data science course it is mandatory hv technical experience or if fresher applied there is any difficulty in understanding of concepts??

  • Art of Engineer
    November 27, 2020

    한국인앖나여

  • Art of Engineer
    November 27, 2020

    Thanks, very clear video. I have masters in Mathematics, and have good knowledge of SQL , but never had realtime experience as Data Analyst . I am teaching math right but really wants to change my career . Have no idea how i can do this. Do you have any suggestion like any particular courses, or …??
    Thanks

  • Art of Engineer
    November 27, 2020

    Very good

  • Art of Engineer
    November 27, 2020

    Thanks

  • Art of Engineer
    November 27, 2020

    The best video I've seen so far comparing these two paths

  • Art of Engineer
    November 27, 2020

    Thank u very much …it removed all confusion..

  • Art of Engineer
    November 27, 2020

    Informative

  • Art of Engineer
    November 27, 2020

    Excellent Vedio!!!
    Looking forward more vedios on skills needed for Testing, Embedded, SharePoint, Adobe and many more.

Write a comment