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.
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 🙏
@@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.
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.
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
@@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 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.
Loved your analogies. మీ తెలుగు రూట్స్ గురించి చెప్తూ బారిస్టర్ పార్వతీశం స్నిప్పెట్ చూపించడం బాగుంది. ప్రాథమిక విద్య అంతా తెలుగులో అయ్యాక English లోకి మారి ఇంత బాగా teach చేయగలగడం చాలా అభినందనీయం 👏👍
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, 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.
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.
@@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.
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
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.
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
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.
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.
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
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. 😅
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.
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.
@@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...
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.
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?
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.
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
😂 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!!!
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..
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.
@@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
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.
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.
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
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.
All the very best…
Congratulations on your internship Pleb. I wish you all the best in your direction 😀
@@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.
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 🙏
@@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.
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.
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
@@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
@@ektasingh225 thank you 🙏🏻
@@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.
@@Bhavik_Khatri thank you 🙏🏻... As beginner what salary I can ask/expect as beginner in Gujarat region?
Great video packed with many valuable tips - *thank you!*
Glad you enjoyed it!
@@chandoo_ please upload how to job search effectively like job site in IT.
Loved your analogies. మీ తెలుగు రూట్స్ గురించి చెప్తూ బారిస్టర్ పార్వతీశం స్నిప్పెట్ చూపించడం బాగుంది. ప్రాథమిక విద్య అంతా తెలుగులో అయ్యాక English లోకి మారి ఇంత బాగా teach చేయగలగడం చాలా అభినందనీయం 👏👍
చాలా thanks అండి! 😊
I am always happy to view your video
Thank you Osofo...
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🤪😁
I agree. VBA is one of the easiest languages to pick up.
Дякую! Як завжди все пояснено чітко та зрозуміло)
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.
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.
@@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.
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
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.
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
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.
Thank you for your advices !👍
My pleasure!
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.
Great advice on "start solving problems".
VBA adds charm if you have vision to reduce manual work. Analysis on the other hand needs a bit of domain
Plus it is also FUN
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
Be consistent while learning :)
Simplicity is your greatness! Thank you for the tips.
You are so welcome!
Teaching is an Art. Great 👍👌👍 Chandoo you taught superbly.
Great chandoo bahi regards
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. 😅
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.
Thank you annaiyaa..
Really love this video and inspired me a lot, thank Chandugaru great helpfull
Chandooo anna, malli nice video chesavu... Thank you
great advice, loved your honesty and clarity here.
Hi chandoo , what should i learn SQL or EXCEL??
thanks for the tips
You are welcome Jhon.
Thank you Sir 🙏
You are welcome TD :)
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.
thanks thalaiva
Hi chandoo...
Thank u for clarity
You are welcome Raj...
You're the best💜
You are the best too 😀
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?
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.
THANKS A MILLION :)
You are welcome George.
Should i learn power query,vba or python.
Thank you for this video...
You are welcome BN.
@@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...
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.
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?
I don't have a large collection, but here is my HR Analytics playlist - ua-cam.com/play/PLmejDGrsgFyBEJ6TyCuh3WQ-KgLabvBdD.html
@@chandoo_ Thank you a whole lot, you are far too kind
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.
Thank you so much for such a lovely comment Paramveer.
Sir ..thank you for such moral boosting videos
It's my pleasure
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
😀
Dear chandoo sir i done my complete education in english medium still i am bad in english😂
😂 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!!!
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..
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.
@@chandoo_ thank you for your suggestion..
Sir, I want to do internship for data analyst. Can you help me?
Do you have any ideal career path for DA beginners
Do i need to be an expert in power query M? I am trying for data analyst job.
That depends on the job. In general, learning Power Query should be high on your list.
Good video
Hi Chando,
Is there any way to append multiple pivot table as like we do with normal table in power query
What are you trying to do?
@@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
చాలా బాగా చెప్పారు.
😍
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.
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.
what about qualification what about age limit to get data analyst job
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
i am also from visakhapatnam struggling to get a job
Best way to learn Code by praticals
AGREE...
Chandoo, do you have a mail or any contact details?
Thank you for this insight 🙏
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/
@@chandoo_ Thank you Chandoo, it'll be a good content of learning ,for us,your students ,I assure you.🔥
manavaadu
😎
Manchu videos
First view and first comment
Thanks Mihir...
You're adorable
First like
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!
@chandoo