How to be a Data Analyst | Complete skillset required for Data Analyst
Вставка
- Опубліковано 5 жов 2020
- 🙋♂️ Send me your queries here: topmate.io/thecorporatediaries
🎥 My YT Channel for HR Career: / @thehrdestination
💼 HR Course: tinyurl.com/TCD-HR-Course
************
Tech Gear I suggest:
📷 Camera Samsung S23: amzn.to/3OUG1SL
🎙️Boya Mic: amzn.to/48yjGBe
💡Light 1: amzn.to/3P32jSf
💡Light 2: amzn.to/3P00cyJ
💡Light 3: amzn.to/3uOgjIC
🗼Tripod 1: amzn.to/3TaOkw6
🗼Tripod 2: amzn.to/3TcTEiv
🖱️Mouse: amzn.to/49TCU5H
💻 Laptop: amzn.to/3OTtjU3
🎧Sony Headphones: amzn.to/3uPYsRI
Laptop Cover: amzn.to/4bM3qzD
Hard Drive 1: amzn.to/3UTsgHC
Hard Drive 2: amzn.to/3Tf2b4P
Hard Disk Case: amzn.to/48zXhn4
📕My daily Planner: amzn.to/3SXoDxM
*********
Follow me at LinkedIn
/ varshakadyan
at Instagram
/ corporatediaries_official
Don't send me your resume please...
Disclaimer:- All the examples used in this used are purely done for reference..
Thanks
Varsha KR
Disclaimer: All the inputs/suggestion given are purely based on my personal experience, there is no guarantee assured of the success rate it will bring to the user, its advised that you use your own judgement to arrive at the decision, the Corporate diaries is in no way responsible for any sort of outcome or situation that viewer has landed in to.
#careeradvice
🙋♂️ Send me your queries here: topmate.io/thecorporatediaries
🎥 My YT Channel for HR Career: www.youtube.com/@thehrdestination
💼 HR Course: tinyurl.com/TCD-HR-Course
1. MS Excel
2. SQL
3. Communication and presentation skills
4. Domain knowledge
5. Visual tools and python ( Advantageous, not must )
6. Problem solving skill
Thank you for such informative insights into the data analysis world!
Such a simplified content, your hold on the subject is really good, thanks for sharing 👍
Glad it was helpful!
Thanks for guiding fresher like me to a good career path.☺️Please continue to make more career videos in future.
I will try my best
You dropping bomb of knowledge! ❤️
Thank you maam for sharing valuable knowledge really helpful
Step by step content 👌
Thank you much appreciated
Really really excellently explained
One word Excellent...👌👌👌
U r great 👍really..u helped me a lot..through this ✊
Thanks for sharing useful information.. Thanks a lot..😌
thanks, ma'am the content is good and clear
Excellently explained yar
Thank you for sharing such extensive knowledge..but what can be done if does not have particular domain Knowledge?
Good job dear.
Loved the content ma'am. Very helpful👏👍
Hey guys, here are links of old Videos mentioned in this Video:
Video on Data Science Field : ua-cam.com/video/V4PcJolwgvw/v-deo.html
On Presentation Skills: ua-cam.com/video/oM8xpJkvADQ/v-deo.html
On “How to create a great LinkedIn profile”: ua-cam.com/video/QmqrGcu0h9U/v-deo.html
Mam can u guide me which stream should i choose to become data analyst
Plz i request you
Thanks.......🌞
Txs a lot make more videos about career
Sure I will
Thank you for detailed information 😊
How to get a job as a data analyst From a data warehouse project background when all they ask is experience in data science or analysis, everywhere? It's a huge problem that we face even after thorough learning and projects.
Thanku😇 mam..Will a masters in financial engineering help getting a job in business analyst/ data analyst job? I am thinking of applying for mtech..plz help me mam🙏
Hi mam, i am a B.E mechanical graduate. can you please tell me what would be my DOMAIN KNOWLEDGE.
skills 👌
Hi...thanks for info. Could you plz tell me about salary range for DA
Mam UI/UX Designers ke liye ek video bna dijiye ... Please
I would say, In North America Excel is required but not at an expert level
It's slowly becoming one of the language that you can do with intermediate level of expertise.
PYthon and visualization tools like Tableau, Google analytics etc. Etc. Are on a rise
Such a nice info, Thank u so much. hope i also get a job in this field with learning these skills like ms exel, sql, python and tablue. 🙏🏻
Congratulations 💐👏👍👍
In which company
Can you explain me what's the difference between data analyst and finance analyst??
Your information become a me a deta analystic
Plzzz make video on arts graduate student how get jobs in corporate world
Hello miss, do you recruit for the same position?
Mam how much maths and stats needed for a data analsyt
if a core branch engineering guy want to be a data analyst in finance domain, so how to work on for changing domain? @Corporate Diaries
Dear Avi, you need to have expertise on below:
1. Learn core Data Analyst skills(SQL+MS Excel)
2. After learning DA skills, apply them on "Finance" topics, and showcase those analysis on your resume/ LinkedIn to let people know that you have technical skills +domain skills.
for eg: Banking industry in India has changed so much over the last decade in India, Bad loans, change in GDPs, Most Banks are not working in profits, pick any of these case studies and apply data analysis on it and showcase that on your portfolios that how the trends has been..
Hope this helps!!
Please make video on business analyst
Mam now I am doing 2year bcom how to take future steps in data analyst
Thanks a lot for the knowledge ma'am
Request you to please help me as i am in a dilemma from long time I am working in IT from 2 years as a product analyst please guide me what is better for my future go for data analyst role or learnin some programming language and go for software development field please help🙏🙏🙏🙏🙏
Dear Utkarsh, while the best option will be based on your personal interest area, here are few things I can mention:
1. Product analyst profile is a kind of Data analysis but specific to the product while DA has a wider scope and the benefit that you can swap to a Data Science role if you invest time into learning Python and other skills.
2. Learning new programming skills is always good, but do that in alignment of the job you are seeking, I recommend learning "Python", as its the language of next gen and easy to learn and will open many doors for you.
Mam cn i get a job in data anayst after 5 yr gap as i was in govt job prep...but now i m attaining skills and making portfolio side by side..and apply for internshp. how to land in job after attaing skills..cn i do internshp directly so that i get real time project experience.plz plz make a video in that..
I m aeronautical engineering fresher ,can I directly target for data analyst being a fresher ??
Ma'am can we have a video of a deeper take in the Business Analysts position
Sure, will consider that
@@theCorporateDiaries is stats important? If someone is from bcom or bba background can go ahead with data or business analyst?
@@niketdubey1743 yes they can
Madam what is system engineer, or system analyst plz make a video on this too
What is the average salary of a Data Analyst and Data Scientist in India ?
I am sorry but the skills mentioned here were not exactly wt r needed.
1) Excel and Sql can be learnt in a week
2) Communication Skills and domain knowledge is secondary
3) Imp are knowing cleaning amd minning data.
4) Knowing different ML algorthims
5) One visualization tool not compulsory
6) R or python is essential
Why ML is required?? We're talking about data analyst not data science.
Ma'am im getting integrated bsc + msc in life science at NIT rourkela, can i get into a big mnc by studying this branch?
Dear Swapnil, if your questions is getting into IT Mnc then answer is NO, usually they don't hire in that field, but:
1. There can be pharma companies that might provide good jobs in this segment, it would be mostly into research
2. I am not sure how the Placement facility of the college, if it is good, then you can depend on that.
This field is still emerging, it will be too early to say anything related to its scope, as of now I see only being in institute as a faculty or joining a firm/company dealing with upcoming new emerging fields of biotechnology and genetics.
I m an introvert ,I don't speak more often ,I speak only little
Will there be a problem in my career?
Same here
Hii hr ...
Bcom grad 2019 here ..gap due govt job preparation learning data analyst through youtube is it possible to get a job ?
Mam is data analytics can be made more demanded profession in future and make a video on top mncs hiring data analysts mam please
Ma'am please make a video on resume writing for Freshers.
Dear Adarsh, I have already shared the key points that matters in a profile in this video, you can choose to watch it: ua-cam.com/video/Mot-qKQlx5Q/v-deo.html
Mam, i am persuading last semester of my graduation in bca and m very much confused about what should i opt after bca and i am also weak in coding ehat should i do nd learn for job?
Thank you
project management
Mam, I'm a Btech, Mtech in Comouter science.. but I'm week in Coding.. so I not confident to work in a software field..
Can I work as a data analyst ?
Yes, definitely
do project management
Mam, we know some Excel formula which is more important our analysis so we are not having an idea how much we have to learn on excel, please make one video about this mam.
Dear, there is already a video on this topic name: 3 Timeless Skills :ua-cam.com/video/C6ZzhjnIlfQ/v-deo.html
chk Code Basics channel
🌟🌟🌟🌟🌟
Can I become a data scientist after bsc maths
Can a Chartered Accountant learn skills like Python, SQL, Tableau and become a Data Analyst ? Are there any chances of getting a job as Data Analyst/Financial Analyst in any IT company ?
Why you are wasting your time ?? You can earn double in CA.
I'm BSC agriculture+ mba 5 year integrated course student can I eligible for data analyst
The potential of MS Excel is under valued.
I m in 3 rd year of bca which job I have to choose( which does not have coding) after Bca?
Dear Ganesh, follow the steps to find a suitable career of your choice: ua-cam.com/video/ZkIGHhCCwdA/v-deo.html
Does data analyst require coding?
Mam I completed my b.tech 2020 in CSE but I'm not good at coding and confused what to do next MS, M.Tech ,Job or shell I do any internship based on my course
Dear Krish, You should do MS/Mtech only if there is a subject, which you loved in your btech and want to explore it more in depth, else its a waste.
Doing internship is always a good idea as it will give you real picture of what you may be interested in doing, I advise you to watch my discussion on this topic at below link, i have explained everything in detail: ua-cam.com/video/zYwM9xHBdFM/v-deo.html
Recently I have completed my BE in Aug20 from IT branch. Now I m looking for full time data analysis or Business Intelligence cource. What r the options I have now? I tray to find cources in Pune but won't get it. Please suggest something men.....
Dear Parthesh, why are you trying to find courses, you are already a tech graduate, MS Excel and SQL expertise is good enough to start as Data analyst.
And if you want to get an edge over others, just learn any visual tool(Power BI or Tableau), there are many free resources available over internet.
@@theCorporateDiaries Thank you mem for the reply.... I already have knowledge on these things...can I able to get a job directly as a data analyst without any cirty? I ask about some cource or clg bsc of direct placement.... But yaaa...after your suggestion I think I don't need any cource. Thank you 😊
Iam currently working as a windows server admin on coming December 3years full as l1 but I'm really not interested going to l2 as a windows administrator , please suggest me what can I prefer or do next for my career path ..I'm confused..
Dear Professional, typically there are below career paths/options for a windows admin:
1. Senior system administration
2. System architecture
3. Cybersecurity
4. IT consulting
I am sharing a link, here they have explained it very well, and the certifications required are also mentioned, so read through and discover as per your interest.
www.newhorizons.com/article/4-career-paths-for-system-administrators-and-the-certifications-you-need-to-succeed
@@theCorporateDiaries thank you so much❤
companies to target for fresher other than servicebased ? can u name some good companies for freshers?
Dear Sai, there are hundreds of companies out there for freshers, other than services, no matter how many names I give, it will be an incomplete list, however I have named few:
Intuit, Cisco, Intel, Myntra, Uber, Paytm, Amazon, Flipkart, Adobe, BMC, McAfee, Paypal, SAP Labs, Vmware, Oracle, HP, IBM, Amdocs, Salesforce, Citrix, LinkedIn, Walmart, Texas Instrument, NetApp, VISA, Qualcom, Razorpay, Nutanix, Ola, Samsung RnD, Inmobi, Cadence, Nvidia, Informatica, Broadcom, Juniper, NASDAQ, National Instruments
These are just a few.. very few 😊
Which ug course is better for data analysis
bsc (maths, statistics)
Mam I'm doing CSE now, and I am not interested in coding part, and I'm also thinking to do MS Or M. Tech in abroad so can you please suggest some branches in ms or m. Tech which doesn't need coding skills
do in canada / germany… chk bharat in germany, yudij,ymgrad …. u can go for project management/ Data science / devops-cloud computing
Hello ma'am I'm in BCA 1st year. I want to become a data analyst.. What should I do... Please Reply..
Just study what is required(SQL+MS Excel), python, if you can.. and then apply for relevant jobs,
@@theCorporateDiaries Thank You ma'am for Your valuable Information... 🙏🙏👍👍
Ma'am at first I thought of becoming a data analyst then after losing hope of getting admission in bhu for bsc stats hons i am thinking for getting a just a bsc degree and pursue mba is it right?
no …if u do bsc maths ( statistics, math, probability) …then learn sql + python + power bi /tableau (easy) = Data Scientist (easily u get job ) wwhile doing degree also u can earn….. practical example of my friend
Mam for data scientist we need lot of understanding for linear algebra, statistics,etc
But for data analyst how much maths we need??
I mean we should have deep understanding in maths?
Please reply
No, you don't need deep maths for data analyst
Mam I'm now transferring in 11th. Should I take PCM or commerce?
After 12th which degree should I take? And after that what should I do please reply
anything u like most
anything is good…
@@Prinx0506 thank you sm
I got placed in a service based company during my college placement. I am very weak in coding.Also I hate coding. I have the knowledge of SQL . I like mathematics . Should I go for data analyst? ...how should I approach then?
There is bit coding needed for this role.
But i think if u learm coding in the right way it is just like combination of maths and any new language at it's core. Sql is handy if u know. But since u like maths, thr are new form of maths u need to learn, u might find it easy. If u want to know more reply back with all your questions. I am happy to reply.
@@sharan9993is data analyst have scope in future...
Can I became data analyst as a fresher..
I am MCA graduate is this job is suitable for me
Ma'am I'm a mechanical engineer with zero coding knowledge which among data science and data analytics is better for me for good career
Dear Rahul, Data Analyst role would be easy for you to start with, Data science is very vast field and only people who have obsession and passion for problem solving get success in that.
@@theCorporateDiaries thank you ma'am can we get into data science with little coding knowledge ?
@@RAHULPATIL-nw4op Data science has various job roles in it, it depends on which is right for you, I have explained in very detail which role requires what expertise, watch it in this link, ( ua-cam.com/video/V4PcJolwgvw/v-deo.html )Little coding skill is fine but what others skills you have that's important... Just little coding skills is not enough..
@@theCorporateDiaries thank you for such amazing informative content 🙌
I'm also data analyst
Dear mam,
I have a diploma in mechanical engineering and working at aerospace manufacturing industry in NDT department..can I do course of data analyst. Can I become a data analyst
What should I do for that.
Dear Manoj, just aim for the "Data analyst job in aerospace field"; learn data science skills and then follow the steps: ua-cam.com/video/ZkIGHhCCwdA/v-deo.html
@@theCorporateDiaries okay.. thanks
Is Data Annotation is Same As data analyst.?
Dear Parag, no they are not same, very different jobs
Mam I have completed B. TECH(hons) in 2020 with CSE spacialization , I have good acedemices skills, but I am not too much good in coding I know the basic of languages, I am not got any job, what I should to do next step.?? Please suggest me..
Hi Omkar, first you will have to decide on the "job profile" that you wish to aim for and then align your skills as per that and to help you do all that, here is a step by step session: ua-cam.com/video/ZkIGHhCCwdA/v-deo.html
@@theCorporateDiaries thank you mam
devops + cloud computing = no coding, good career
Will they hire bcom student ?
I am a bcom student but I want to switch my career to IT sector.
Will it be worth it if I do that ?
commerce + sql = many job opportunities.. or u can SAP erp tool
@@Prinx0506 i am also doing masters from IGNOU.. is it worth it ??
@@zeenatkhatun3616 masters means what … details?
Mam do a video on data science please
Dear Dhanush, there already a detailed video on Data science on the channel: ua-cam.com/video/V4PcJolwgvw/v-deo.html
@@theCorporateDiaries thank you mam❤️
After 10th what can I do Diploma or 11th 12th
You should go for 11th/12th if there is not any specific reason why you want to do diploma.
Standard educations are more widely accepted.
HoW to become Business analyst as fresher
Hi Tushar, I am assuming you are a btech fresher(final year student), here is my suggestion:
A Business Analyst as a job profile would need you to understand the finer aspects of business and the holistic picture of how a company functions and comes into picture and in engineering we are taught none of that not even 1%.
So taking up a PGDM/MBA will be good for you, if you are serious about that career option.
If you don't have the option of post graduation, try working on skills required for a BA, there are many people(BA) on Linkedin who even run free video sessions to educate students how to be a BA. connect with them.
Last month I posted such a link for my UA-cam viewers, where the person on LinkedIn was hosting a free BA session.
Here are some posts for your reference, try to network and be active on LinkedIn, algorithm will automatically start showing BA related stuff to you.
1. Hiring Fresher for BA:
www.linkedin.com/posts/manoj-rane-a1505a39_business-analyst-apac-analytics-reporting-activity-6715407217677488128-mhH4
2. How to create a BA resume:
www.linkedin.com/posts/zarantech-corporate-training_businessanalysis-ba-businessanalyst-activity-6716987621794545664-IkAo
Basic office tools such as Word, Excel, and PowerPoint should be sufficient to get you into the profession.
The common visual modeling tool is Microsoft Visio, see if you can learn things on youtube, apart from that you need to have amazing comm skills as well.
Once you are done with polishing skills, apply for BA internships, follow related tags on LinkedIn, you will soon get the hang of the network.
Hope this helps, All the very BEST!!
Mam i am 4yr ece student , i am a bit confused to choose a career. Would data analyst be good? I just want to choose something and prepare for it, as i am left with one more year. But i dont know the career options. Please help me. @CorporateDiaries
Here is your answer, follow the steps: ua-cam.com/video/ZkIGHhCCwdA/v-deo.html
Mam I completed my BE from computer Science in 2020 can I be a data analyst I have knowledge of python and sql
Dear Himanshu, def. you can be, start your preparation for the DA interviews and then apply.. this video will help you understand how to prepare and start on that job search: ua-cam.com/video/VkrGe_hd9O0/v-deo.html
@@theCorporateDiaries if I go for data Science do they ask programming questions or DS algorithm in written as well as interview.
Most easy jobs webdevelopment and data scientist dono ma hi bahut bheed ha or jobs bahut kam har doosra banda webdeveloper or data scientist ban kar k ghoom rha ha market ma
Hii mem I did my graduation in 2017 till now I didn't do any job ....but now I want to do this job my question is can go as fresher or experience d one ? Thanks in advance
Fresher, as you never worked so far..
👉👉🙋My only Q is, I want to get into data analyst profile. But my education is not related to that. I have B.A degree. Just mention few points while responding. How can I get into this profile.
1, if I take any course from any institute, would I be capable for that??
Absolutely Dear, if you take up a Data analysis course and showcase your skills right, then educational background will become secondary..
@@theCorporateDiaries Thank You for Responding.
Who is fresher
Who doesn't happen any job experience.
When you came from poor family background IT job is always dream for u.
but mam u said that data analyst is without coding
Dear Rushi, yes to be a data analyst, coding is not required, its just SQL and excel you can start with... later in your career you can choose to learn Python..
@@theCorporateDiaries my skills are SQL and excel am not comfortable with coding so if see any data analyst post they are asking coding knowledge in there qualifications .
And it's been 1/half year for me
@@gulugulu6009 Dear just apply to those positions and show them your portfolio or any analysis that you can explain them.. companies wants to hire capable data analysts, they mention every possible skill they feel could be relevant in finding one, if you could match to their expectations in interview for being an analyst, coding skills become secondary... and don't be so rigid about telling that "you are not comfortable with coding", eventually with time when you are 5-6 yrs of exp, you yourself will be willing to do it, because it will help you in doing your tasks faster... but for now just apply and appear for interview with open mind, even if they ask for coding, just say, "I am not a hard coder, but whatever is required for the job, I am on it".. thats all...
Can ba graduate student become successful data science
Dear Brajesh, if your question is that, with just B.Arts degree you can be Data Scientist, then answer is NO.
I have explained the concept in details and the skillset required also in this video: ua-cam.com/video/V4PcJolwgvw/v-deo.html
@@theCorporateDiaries if i do training in data science any problems to get jobs if i completed in ba arts graduate degree
@@brajeshroy2608 start with skills required in BA, then u can go for DS
@@Prinx0506 Ds means ??
Sir, I am Pursuing Bachelors in bsc biotechnology from a nearby college but recently I came to know about Data Science and its scope. If I am doing a decent online course of data science and practising some good projects from scratch. Will my bachelor's degree create an impediment for me to get a job in MNCs
I really need help here
I am bsc ( maths, stats, computer) graduate
Currently working in one MNC in technical support role( 1.8 lpa/y)
which I am not at det any motivation to work and interested in data analytics and programing really want to transition into data analytics desperately
Plz provide your inputs is it possible in my case if I learn required skills.
Due to very bad financial reasons and survival I am continuing my current job
Plz anyone guide me it's is an life matter to me your small input helps me a alot
I just want better life 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Is your job
L1 desk job
@@Traumatised311 yes
@@cn9699 I am mechanical engineer
Capgemini offered me 2 lacs
But it was far from my home
And rotational shifts evryr week
I hate that so I rejected
@@Traumatised311 okay in future you will get better opportunity all the best
I don't have that option to quite
@@cn9699 why did you sign a bond
Why can't you apply time stamps for different topics
Video seems like a vlog not information video
Terrible editing
Also most engineers in india have bad communication skills
Hard skills matter
Soft skills matter in other industries not stem
Hello ma'am, I am learning skills for data analyst role but I am not good at in English communication that makes me nervous everytime when I think of interview ....
Is communication skills are primary skills to have in data analyst role or not?
Hi Shruthi, Yes comm skills are very important for a data analyst, English can be polished by practice, shouldn't keep you away from being a Data Analyst... Communication skills include- Clarity in your explanation and you are able to communicate what you exactly feel about a certain data... in that way its important, not that you should be able to speak English language like an American...
Thank you so much for your reply ma'am...
Could you please suggest me, how can I improve data story telling skill?
Mam cn i get a job in data anayst after 5 yr gap as i was in govt job prep...but now i m attaining skills and making portfolio side by side..and apply for internshp. how to land in job after attaing skills..cn i do internshp directly so that i get real time project experience.plz plz make a video in that..