Do you need "CODING SKILLS" for Data Jobs?

Поділитися
Вставка

КОМЕНТАРІ • 118

  • @pleb8834
    @pleb8834 2 роки тому +68

    Hi Chandoo, I'm a 25 year-old person who was so tired of my past occupation and wanted to get into Data Analyst.
    I first realized that I want to be a Data Analyst after having watched and practiced some of your videos (The Chocolate company assigntment).
    And now, thanks to your guidance, I've passed my first Excel test and received my first offer as a DA Intern.
    It means starting all over again but this time I know I'm heading the right direction.
    I just want to say thank you, I could not have made it without you and your channel.

    • @nipeshranjannath3608
      @nipeshranjannath3608 2 роки тому +1

      All the very best…

    • @chandoo_
      @chandoo_  2 роки тому +7

      Congratulations on your internship Pleb. I wish you all the best in your direction 😀

    • @smith234073
      @smith234073 2 роки тому +1

      @@chandoo_ Hey Chandoo, I am very thankful to you for your efforts, just wanted to ask on how to connect to you personally for some guidance.

    • @aniketsingh3364
      @aniketsingh3364 2 роки тому

      Can you please let me know as intern what skills you have when you applied for it and what's necessary for entry level in data analyst as you have face the interview process and know the environment so that's why asking. Please let me know 🙏

    • @pleb8834
      @pleb8834 2 роки тому +1

      @@aniketsingh3364 Yeah, I'm from Vietnam so the skill ceilings and demands maybe vastly different from where you are. But here are the skills that was required of me to pass the DA Intern position back then:
      1. Basic formatting skills like using colors to display sale volumes
      2. Formulas like: Vlookup, Xlookup, Sumifs, Countifs, Iferror, Index-Match (this one is crucial).
      3. Data visualizing - knowing which table to use when trying to explain what all the numbers mean
      4. My employer also put traps in the test too, to see if I can identify mathematical errors - be mindful of it, sometimes you're not wrong, the question is.
      Identify it and point it out.
      5. I was asked to write down my thought processes - why use this formula, why use this graph, what stories can I tell based on the results.
      The interviewer specifically said that I passed not because I did a great job (I didn't do a good job in the test haha) - It's because he can see the passions in the way I wrote down the answers and my train of thought.
      Ultimately he said, the atitude and the mindset (math/logic skills, never give up, find another way, think outside the box, knowing how to google to find answer...) are way more important than the technical abilities when you start as an Intern.
      I wish you all the best in your journey man.
      I don't think you can make it, I KNOW you can make it.
      From Vietnam with love.

  • @Bhavik_Khatri
    @Bhavik_Khatri 2 роки тому +36

    I agree with Chandoo views. I did Excel VBA course but it took me good 7 years before I get comfortable. Currently, learning Power Query in Excel so I can manipulate data in PowerBI.

    • @dexxxxxxxx
      @dexxxxxxxx 2 роки тому +2

      I'm learning Excel from last Month and also learning power query. Should I learn sql and power bi before applying for job? Or I should apply based on excel and lern other things after

    • @ektasingh225
      @ektasingh225 2 роки тому +3

      @@dexxxxxxxx at least learn SQL.. it's the most important skill.. Not advance SQL.. But at least you should know how to retrieve data from database.. And power bi / tableau is a plus

    • @dexxxxxxxx
      @dexxxxxxxx 2 роки тому

      @@ektasingh225 thank you 🙏🏻

    • @Bhavik_Khatri
      @Bhavik_Khatri 2 роки тому +7

      @@dexxxxxxxx Concentrate on Excel and Power Query. Excel VBA is awesome too. I used Excel VBA with ADO connection to run SQL scripts in multiple different SQL environments and get data back to spreadsheet as desired. Later on used Windows Task schedule to run SQL queries without any clicks.
      Everything happens overtime. Keep on learning and progressing. Apply for job you desire.

    • @dexxxxxxxx
      @dexxxxxxxx 2 роки тому

      @@Bhavik_Khatri thank you 🙏🏻... As beginner what salary I can ask/expect as beginner in Gujarat region?

  • @tubeofmeks
    @tubeofmeks 2 роки тому +4

    Loved your analogies. మీ తెలుగు రూట్స్ గురించి చెప్తూ బారిస్టర్ పార్వతీశం స్నిప్పెట్ చూపించడం బాగుంది. ప్రాథమిక విద్య అంతా తెలుగులో అయ్యాక English లోకి మారి ఇంత బాగా teach చేయగలగడం చాలా అభినందనీయం 👏👍

    • @chandoo_
      @chandoo_  2 роки тому +1

      చాలా thanks అండి! 😊

  • @CodingIsFun
    @CodingIsFun 2 роки тому +4

    Great video packed with many valuable tips - *thank you!*

    • @chandoo_
      @chandoo_  2 роки тому

      Glad you enjoyed it!

    • @horseman6923
      @horseman6923 2 роки тому

      @@chandoo_ please upload how to job search effectively like job site in IT.

  • @volodymyrdudkin6171
    @volodymyrdudkin6171 2 роки тому +1

    Дякую! Як завжди все пояснено чітко та зрозуміло)

  • @lallmanish90
    @lallmanish90 Рік тому

    The answer to whether data analysts need to learn coding is not straightforward, as it depends on various factors.
    While coding is a technical skill that is highly valued in data analysis, it is not necessary to be a highly successful data analyst.
    Even if someone does not write any code, they might still be using programming skills, such as building Excel spreadsheets or using Power Query.
    Anyone can learn how to code, but it takes time and deliberate practice.
    The speaker recommends dedicating a significant amount of time to learning coding skills and not rushing the process.
    Fluency in a programming language is like fluency in any language - it takes time and deliberate practice to develop.

  • @robwin0072
    @robwin0072 2 роки тому

    Chandoo, another way of saying it is: Excel is the semantics of a program, and what we do is add parameters and arguments to the Excel behind the spreadsheet's coding.
    I recall when programming in Fortran, C, and ADA; code was written heavily as specific functions of libraries, needing the user to provide different parameters and argument values for the other answers desired.
    Excel, JASP, and SPSS are the graphical interface that accepts the data you enter and produce results of preprogramme formulae.
    You get the point.

    • @chandoo_
      @chandoo_  2 роки тому +1

      Hmm.. correct and wrong too. Excel offers ability to code too. If you have to build a decision logic, you can use IF() function. If you need to do an action across a range, you can apply the functions. You can also combine functions or make your own (with LAMBDA). All of these are essentially programming and require so much more creativity and skill than what is needed to use graphical interfaces alone.

    • @robwin0072
      @robwin0072 2 роки тому +1

      @@chandoo_ Thank you for your reply. I have MS Office 2019 Professional, but I am not sure LAMBDA is available in my version.
      Regardless, my intent wasn't to diminish your presentation. However, stringing functions together is not as much coding as expressing logic through procedures.
      I think coding begins with a blank screen. You see, I can do what Excel does with R, C++, Fortran, Pascal, et al., that's coding. I love that Excel has rescued me from actual coding since Excel 4 (1993). 😄😄😄
      I think you are great, and we really appreciate what you are doing with these Excel UA-cam videos (for FREE)
      Stay Great.

  • @osofoeric7039
    @osofoeric7039 2 роки тому +6

    I am always happy to view your video

    • @chandoo_
      @chandoo_  2 роки тому

      Thank you Osofo...

  • @snipelite94
    @snipelite94 2 роки тому +2

    VBA is east to learn
    I stated by simply recording my spreadsheet actions to a macro
    Then examined the code that had been generated
    VBA is _almost_ english...!!
    So you can kind of follow what's happening
    I automated simple repetitive actions for frequent reports this way for a long time
    It took about a year before I started writing vba code from scratch
    Several years, _I'm still learning!!_
    There's so much help and advice on the internet when you're trying to put together an algorithm
    The best way is to MANUALLY complete your actions and note what it is you're actually trying to do
    It's definitely worth having a large bag of tools, so the scope of your solutions to excel problems are more possible to implement🤪😁

    • @chandoo_
      @chandoo_  2 роки тому +2

      I agree. VBA is one of the easiest languages to pick up.

  • @joedi
    @joedi 2 роки тому +1

    I’ve been learning to code in SAS Data Step in the last 6m. Other than the basic structure most of my learning has been using other peoples code and doing data requests.

  • @markgreen2170
    @markgreen2170 2 роки тому

    if you are going to learn python, you should have this in your library:
    An Introduction to Python
    by Guido van Rossum (Author), Jr. Fred L. Drake (Editor)
    Guido van Rossum created the Python Language ...I would not recommend a scripting language as a first language, I think it is better to learn something that has "stronger types"...if you choose something from the 8 bit era to get started, not only are there an abundance of free resources and a vibrant community still coding, yes! But, you will learn so much more about: the console, key mapping, memory partition, (flat memory model), working within constraints ...what else? yes, video ram, the terminal, linking, loading ...it is a really big list. It will give you an understanding of concepts that were once physical devices that are now "virtualized" you would be hard pressed today to find a "modern programmer" that could tell you the difference between: the console, the shell and the terminal

  • @A_Proud_Indian
    @A_Proud_Indian 2 роки тому +1

    VBA adds charm if you have vision to reduce manual work. Analysis on the other hand needs a bit of domain

    • @chandoo_
      @chandoo_  2 роки тому

      Plus it is also FUN

  • @KHAMOSH_CHONGA
    @KHAMOSH_CHONGA 2 роки тому +2

    I have recently found my way to learn programming in python
    I work as MIS Executive in a dairy company
    What I do is first I find a problem that I am facing as a fresher here and try to solve it with excel when I find a way to solve it I try to solve it with python I don't know why but it's kinda working

  • @justintherattil6654
    @justintherattil6654 2 роки тому +4

    Simplicity is your greatness! Thank you for the tips.

    • @chandoo_
      @chandoo_  2 роки тому

      You are so welcome!

  • @claude_1c74
    @claude_1c74 2 роки тому +1

    Thank you for your advices !👍

  • @abhishek7271
    @abhishek7271 2 роки тому +2

    I am an interior designer but due to my passion of computers and analytical love to anything, I am taking U turn to my career to Data Analyst after 8 years into Design field
    Current age 32 , married with a kid
    Just don't know how much time it will take for this

    • @antishkr98
      @antishkr98 2 роки тому

      Be consistent while learning :)

  • @sujithortan5773
    @sujithortan5773 2 роки тому +4

    as a data analyst you will have to extract data from multiple sources which includes web, if the webpage has structured data sets it will be easy , what if its not?, then coding comes into picture. this is just one example where coding can be used. if you're learning coding a small tip would be don't always look into videos, start solving problems - real business scenario that will be effective.

    • @chandoo_
      @chandoo_  2 роки тому +1

      Great advice on "start solving problems".

  • @ysantosh
    @ysantosh 2 роки тому

    Chandooo anna, malli nice video chesavu... Thank you

  • @rajeswarynadarajan8347
    @rajeswarynadarajan8347 2 роки тому

    Thank you annaiyaa..

  • @kbg001
    @kbg001 2 роки тому

    Really love this video and inspired me a lot, thank Chandugaru great helpfull

  • @abdulwaki8590
    @abdulwaki8590 2 роки тому

    Great chandoo bahi regards

  • @paramveerssachdeva
    @paramveerssachdeva 2 роки тому +4

    always helpful, always providing in-depth insights, always motivating all your followers. I consider it my privilege and good fortune to have become your subscriber. Love and watch each and every one of your videos. Thanks for sharing them.

    • @chandoo_
      @chandoo_  2 роки тому

      Thank you so much for such a lovely comment Paramveer.

  • @pixelmasque
    @pixelmasque 2 роки тому +1

    great advice, loved your honesty and clarity here.

  • @salehmuhammad6811
    @salehmuhammad6811 2 роки тому

    Teaching is an Art. Great 👍👌👍 Chandoo you taught superbly.

  • @kaioumichiru3041
    @kaioumichiru3041 2 роки тому

    dont need to mastery coding, but at least should learn the basic knowledge, i think, such as algorithm and data structure. Cuz company might ask you technical problem about programming. Therefore, doing practice on leetcode i think is also necessary.
    just from my perspective.

  • @wajahatsaeed9602
    @wajahatsaeed9602 Рік тому

    Should i learn power query,vba or python.

  • @lachhamanrajbanshi2862
    @lachhamanrajbanshi2862 2 роки тому

    Hi chandoo , what should i learn SQL or EXCEL??

  • @taizoondean689
    @taizoondean689 2 роки тому +1

    Thank you Sir 🙏

    • @chandoo_
      @chandoo_  2 роки тому

      You are welcome TD :)

  • @JoshAutomates
    @JoshAutomates 2 роки тому +5

    Interestingly, its really difficult to find the perfect balance between being able to code and communicate the insights behind data. I've heard people who excel at coding but having hard time to communicate it. What I did is to talk to myself about how the code works and think of ways on how can I relate the code to the data Im trying to manipulate.
    But I think it is important. If you really want to manipulate large amounts of data, there is no simple way of doing it. And dont focus too much on the Tool! Focus on the skillset you want to develop, logical and critical thinking.
    We are not data analyst, engineer or scientist defined by the tools we are using. 😅

    • @chandoo_
      @chandoo_  2 роки тому +1

      Good points Josh. I view all of these as different muscles. There is no point having strong arms, if you have weak legs. So to be a good analyst, one must grow all these things and do tasks (projects) that involve working with multiple muscles.

  • @gokulraj9735
    @gokulraj9735 2 роки тому

    Hi chandoo...
    Thank u for clarity

    • @chandoo_
      @chandoo_  2 роки тому +1

      You are welcome Raj...

  • @positively8461
    @positively8461 2 роки тому

    thanks thalaiva

  • @rossd6416
    @rossd6416 2 роки тому

    Chandoo your content is so great👍 it gives me hope that I can do it too it may take me more time but I should not give up.

  • @riya-7771
    @riya-7771 2 роки тому

    You're the best💜

    • @chandoo_
      @chandoo_  2 роки тому

      You are the best too 😀

  • @manojnair9197
    @manojnair9197 2 роки тому +4

    Sir ..thank you for such moral boosting videos

  • @gotechakash
    @gotechakash 2 роки тому +1

    I really love the way you explain about these concepts, in detail about everything we want to know, thank you for listening to us and thank you for your time for making such amazing helpful videos. I'm a data analytics aspirant! Planning to do my masters in USA. I'm only worried about the future in this industry and about salary also.

  • @basicinfoforall7306
    @basicinfoforall7306 2 роки тому

    Thank you for this video...

    • @chandoo_
      @chandoo_  2 роки тому

      You are welcome BN.

    • @basicinfoforall7306
      @basicinfoforall7306 2 роки тому

      @@chandoo_ Sir,I like your lesson very much.But I love to think very deeply about data science. I need it that way if you permit me to take that way...

  • @benjaminomeiza9801
    @benjaminomeiza9801 2 роки тому +1

    Hello Chandoo, I have a 4 years experience in Human Resources Management, I want to step into Human Analytics and People Analytics please do you have resources on that?

    • @chandoo_
      @chandoo_  2 роки тому +1

      I don't have a large collection, but here is my HR Analytics playlist - ua-cam.com/play/PLmejDGrsgFyBEJ6TyCuh3WQ-KgLabvBdD.html

    • @benjaminomeiza9801
      @benjaminomeiza9801 2 роки тому

      @@chandoo_ Thank you a whole lot, you are far too kind

  • @jhonreymalagday9767
    @jhonreymalagday9767 2 роки тому

    thanks for the tips

    • @chandoo_
      @chandoo_  2 роки тому

      You are welcome Jhon.

  • @ajayv304
    @ajayv304 2 роки тому

    చాలా బాగా చెప్పారు.

  • @georgeaboh
    @georgeaboh 2 роки тому

    THANKS A MILLION :)

    • @chandoo_
      @chandoo_  2 роки тому

      You are welcome George.

  • @faismeen
    @faismeen 2 роки тому

    Do you have any ideal career path for DA beginners

  • @eswark6786
    @eswark6786 2 роки тому

    what about qualification what about age limit to get data analyst job

  • @sachinjain6044
    @sachinjain6044 2 роки тому

    Hi Chando,
    Is there any way to append multiple pivot table as like we do with normal table in power query

    • @chandoo_
      @chandoo_  2 роки тому +1

      What are you trying to do?

    • @sachinjain6044
      @sachinjain6044 2 роки тому

      @@chandoo_ Actually I have 3 pivots from 3 different sheet. Now I want to append all 3 pivots in single sheet one by one and want to load somewhere. ( this can be done in PQ if data is in table format) how I can done same things for pivots
      Happy to connect with you if you can provide your email

  • @vikkyghale912
    @vikkyghale912 2 роки тому

    Do i need to be an expert in power query M? I am trying for data analyst job.

    • @chandoo_
      @chandoo_  2 роки тому

      That depends on the job. In general, learning Power Query should be high on your list.

  • @nyancole
    @nyancole 2 роки тому

    I like your knowledge Chandoo and the opportunities you continue to give through UA-cam videos. How do I contact and learn from you more?

  • @JEMS-DILAN
    @JEMS-DILAN 2 роки тому

    Sir, I want to do internship for data analyst. Can you help me?

  • @silvana11221122
    @silvana11221122 2 роки тому

    hope your well ... good question @chandoo and video - for me it depends on the output and how powerful it is to enable the end user to make the decisions... given im your oldest lotus 123 user lol i never had coding skills other than the basic macros

  • @ranaganguli2892
    @ranaganguli2892 2 роки тому

    Hi Chandu, I have 10 years of bps experience, want to switch my self from bps to data analytics... should I.. as I am from commerce background..
    Seeking your suggestion..

    • @chandoo_
      @chandoo_  2 роки тому +1

      Hi Rana.. this is tricky for anyone to answer. May I suggest talking to some of your work / college friends, personal mentors (who know you well)? Career transition is often risky and there is always the grass is green syndrome. FYI, your background shouldn't really matter after a few years of work.

    • @ranaganguli2892
      @ranaganguli2892 2 роки тому

      @@chandoo_ thank you for your suggestion..

  • @PlayHitsLive
    @PlayHitsLive 2 роки тому

    If hard work becomes a habit, So success becomes a matter. Whoever is watching my comment at this time, we are all unknown to each other, yet I pray to God that if there is any tension going on in your life, then it should go away. And may you always be happy

  • @janardhanchilmula8143
    @janardhanchilmula8143 2 роки тому

    I am engineering degree dropout I completed Diploma in Electronics and telecommunications and right now my age is 30 yrs. I want to change my career path into data analyst. If I completed Google analytics certification from Coursera can I get Job on the basis of Diploma ( Polytechnic). Please help me with this query.

    • @chandoo_
      @chandoo_  2 роки тому +3

      It may be tricky to land your first job without a degree. While you can try, why not complete the degree in parallel. Degree's are not just stamps. They indicate to your prospective employers that you can commit and complete hard & time-consuming tasks.

  • @ankitlakshya450
    @ankitlakshya450 2 роки тому

    i am also from visakhapatnam struggling to get a job

  • @MohianSheikh
    @MohianSheikh 2 роки тому

    Good video

  • @tomyvishal8185
    @tomyvishal8185 2 роки тому

    Best way to learn Code by praticals

  • @prajnanks
    @prajnanks 2 роки тому +1

    Dear chandoo sir i done my complete education in english medium still i am bad in english😂

    • @chandoo_
      @chandoo_  2 роки тому

      😂 TBH, English language rules and grammar are sometimes downright crazy. When I look at Telugu varnamala (alphabet) and vyakaranam (grammar) I can't help but admire the elegance, simplicity and timelessness of the language. On the other hand, English is nuts - Want a different sound for the same letter, totally go for it. How about not even pronouncing something, Sure!!!

  • @darthrevan1856
    @darthrevan1856 2 роки тому

    Chandoo, do you have a mail or any contact details?
    Thank you for this insight 🙏

    • @chandoo_
      @chandoo_  2 роки тому

      I don't answer any one-on-one questions by email. But if you want to say hello, see my details here - chandoo.org/wp/contact/

    • @darthrevan1856
      @darthrevan1856 2 роки тому

      @@chandoo_ Thank you Chandoo, it'll be a good content of learning ,for us,your students ,I assure you.🔥

  • @RGopiKrishna
    @RGopiKrishna 2 роки тому

    manavaadu

  • @mihirpatel9808
    @mihirpatel9808 2 роки тому +4

    First view and first comment

  • @mihirpatel9808
    @mihirpatel9808 2 роки тому +3

    First like

  • @HeadofSails
    @HeadofSails Рік тому

    You're adorable

  • @Korezwify
    @Korezwify 2 роки тому

    Anyone who watches data analysis videos should subscribe to Chandoo's channel. We need to get this channel to one million subscribers in 6 months!

  • @eidahalmansoori2339
    @eidahalmansoori2339 2 роки тому

    @chandoo