What I like about your videos is that not all of them are abiut excel or other tools, rather discuss career potential, options, and tools needed to get to them. Today's one was also different talking about job openings access the world how thier requirements are different decpite being for same position. Great work, please keep it up!
@chandoo_2 жыл бұрын
Thanks TP... Technology is only one part of the puzzle when it comes to being awesome.
@100DaysExile2 жыл бұрын
This channel is a gem for someone aspiring to become a DA.
@Seftehandle2 жыл бұрын
great video!
@chandoo_2 жыл бұрын
Glad you enjoyed it
@lallmanish90 Жыл бұрын
Third Job ad 1. The third job ad for Xero in Wellington is for a business analyst who will work closely with the product team, providing analytical insights that support the development of the company's software products. 2. The business analyst will have a deep understanding of the customer base and use data to help improve the customer experience and drive growth. 3. The business analyst will use SQL, Tableau, and Excel to extract, manipulate, and analyze data, and then communicate insights to stakeholders.
@lallmanish90 Жыл бұрын
Second Job ad 1. The second job ad for Victoria's Secret in Columbus is for a senior analytics analyst who must be an analytics expert of the company's and co-enterprise analytics department. 2. The senior analytics analyst must be able to work independently and rely on their knowledge of the company's business and data to create analyses that give insight and direction to the business. 3. The senior analytics analyst will use SAS, SQL, Excel, or Python and digital analytics tools daily. 4. For many business questions, it will be required to extract the information from the enterprise data mart using SQL, transform and summarize that information with SQL, SAS, export, and finalize the analysis within Excel and then share and communicate results via PowerPoint, Excel, email summarization, or in person.
@zeerakkhan2742 жыл бұрын
Such an underrated channel. The reason why I found this great channel very late.
@sheelajagat5240 Жыл бұрын
I wonder how intelligent you are sir. Highly appreciable.
@ayushvishwakarma55792 жыл бұрын
Please tell me that do we have to learn everything like power bi ,tableau, sql ,sas,r, python, excel etc .. is it important to master all this ? Or we have to just go through some of these ?
@ninadbhoir28782 жыл бұрын
Quicksight is an AWS service which helps in ETL and Dashboard creation
@chandoo_2 жыл бұрын
That is good to know :)
@shahoh.panahi17942 жыл бұрын
@Chandoo Thanks for sharing very useful I have 2 questions 1. Why some companies ask for both Python and R? While one is enough? 2. Should be very good at a software then start another one, or just basic and intermediate knowledge is enough then try to learn another one?
@AndrewProjectos2 жыл бұрын
This guy looks like a good friend
@chandoo_2 жыл бұрын
😎
@vickiedyson25732 жыл бұрын
Chandoo you are definitely my go to for information. a strong mentor, I appreciate your content please keep up the good work!
@chandoo_2 жыл бұрын
Thank you so much Vickie... 😀
@sagarsapkal98282 жыл бұрын
Hi ... Amazing videos 👍 ... Loving it ... Could you please make a video on Healthcare analyst roadmap for healthcare professionals like MBBS , Dentist etc. ... Not getting enough content on this topic ... Thanks in advance ...
@asif_7862 жыл бұрын
Most informative video I have ever seen on the KZfaq.....thanks sir
@swapnilwankhede34402 жыл бұрын
Great job Chandoo. Thanks for uploading useful information
@chandoo_2 жыл бұрын
It's my pleasure
@InsightfulJourney1232 жыл бұрын
Best presenter ever, True subject matter expert!!
@vijayasimharaoravoori52822 жыл бұрын
Knowledge in different tools Business domain skills Communication skills
@noname-zd6wu2 жыл бұрын
Thank you so much for such an amazing explanation... you made it easy to understand and the way you explain things reveal your knowledge depth and experience... 😊😊
@sarbeshkrishnamoorthy7412 жыл бұрын
What are the chance for the freshers with required knowledge?
@wayneedmondson10652 жыл бұрын
Great insights! Thanks for sharing. Thumbs up!!
@paulcasella6832 жыл бұрын
my first professional job was 2 lines in the newspaper. much less intimidating to apply to
@chandoo_2 жыл бұрын
Wow...
@siddhiquamohammed37062 жыл бұрын
Thanks so much Chandoo for this informative video
@gladsonjeremias45982 жыл бұрын
Great job. Loved your presentation.
@ashishsharma369 Жыл бұрын
‼️ Share the all necessary skills set for an Senior Business Analyst ‼️
@parth_pm162 жыл бұрын
Thanks for making clear that which skills are required in Data Analyst. If you don’t mind can you tell your user a of LinkedIn?
@moizaurangabadwala63272 жыл бұрын
Hi. Chandoo Great work and presentation! I am currently pursuing MBA from the UK and have my retail business experience back in India..now I'm really looking to work in data industry..such as business analyst..now I am applying for jobs but they require experience in analyst.. not much freshers jobs available..Any advise how can I break-through?
@kingbonetti5978 Жыл бұрын
Thank u guru
@Sekoleyte2 жыл бұрын
When i say that i am good at excel and i want to be a data analysist as learning sql as well. They say data analysists don't need excel. They say it as if it is a waste. But i believe that when i have some approaches to manipulate data, i can learn any other programme faster. And i notice that i am learning faster because i have some experiences about tables, and data manipulating. Who is wrong or right? What do you offer to me?
@lachhamanrajbanshi2862 Жыл бұрын
for data analyst what should i do.... SQL or EXCEL?????????
@aq22372 жыл бұрын
awsome discussion 👍
@ganeshiyappan97152 жыл бұрын
really useful for us I expecting same for business analyst role
@chandoo_2 жыл бұрын
Thanks Ganesh... I will be adding a similar one on BA roles in upcoming weeks.
@lachhamanrajbanshi2862 Жыл бұрын
HELP!!! after completing Google Data Analyst Course (3 months) .. is this enough to get a entry leevl job?? or should i look to go for internships OR should i need to go in bootcamps but thiese bootcamp courses charges around 1 lakh for this course. AND moreover i am just starting learn data analytics what should i do please?????
@manueltalks2 жыл бұрын
@ Chando, its an awesome and extremely informative vlog as always. I am looking to switch my career into data analyst from retail. However, whenever i go through the job advertisements for data analyst I most of the time find a sentence quoting « Several years of job experience needed» therefore it becomes impossible to figure out the exact time frame of the same. Can you please elaborate Ta
@chandoo_2 жыл бұрын
Hmm.. that is a road block indeed. I suggest finding internships or jr. positions which often look for freshers. Alternatively, if you have a degree in some other field (accounting / law / business / mechanics etc. ) work in the industry for a few years and then transition to data. This gives you a positive edge in interviews too. All the best.
@danishnaeem36062 жыл бұрын
Thank U!
@abhisheksuman65922 жыл бұрын
I recently crashed into your channel, I must say there is a potential if learning alot from you. I want an advice from you, as I dropped my doctoral course and switch my career towards data analytics with no experience in it at all. Have learnt Sql, MySql, Excel, Python, Git but then also getting no good opportunity to start with. what am I doing wrong ?
@chandoo_2 жыл бұрын
Thanks Abhishek... I can't offer any advice other than the old saying, "keep trying". All the best.
@sauravsinha6939 Жыл бұрын
is sql server analysis service(SSAS) , SSiS is required if i have only sql server knowledge with power BI?
@Mooniscool-w8g2 жыл бұрын
Very helpful
@joedi2 жыл бұрын
I use a combo of SAS data step and proc sql to extract data.
@chandoo_2 жыл бұрын
😀😀😀
@RahulSahani-ji9qs2 жыл бұрын
Please sir make videos on anaplan
@DeeptiDubey13802 жыл бұрын
Hi, I am MBA, working in Delhi for the last 10 years in HR. I am going for a Master's in Berlin for data analysis as I wanted to excel in Power BI. I don't know any programming skills and need your suggestion, which one should I go for, which is easy to understand and go long way? And what knowledge or skills a person should have to become the best in this profile?
@chandoo_2 жыл бұрын
Hi Deepti... Congratulations & all the best for your masters. Data space is wide and there are many platforms. Often companies want you to know & use many different applications (as explained in this video). So don't pick one. Instead learn a few and then based on the job situation get in-depth in a platform first. 😀
@michaelrobinson8382 Жыл бұрын
Is SAS still a relevant tool to learn?
@atifakbar8992 жыл бұрын
Hi Chandoo, Certificate is important to get a job for Data Analyst? Plz advise
@naveenmishra78582 жыл бұрын
Do something for the fly flying around
@chandoo_2 жыл бұрын
Its a fly.. it will fly.
@sohailali51032 жыл бұрын
Sir one video for freshers jobs in india for data analyst
@twenties31542 жыл бұрын
Great
@venkateshembadi63212 жыл бұрын
Currently I'm learning sql, power bi and excel what should I learn to become a data analyst or business analyst Thanks in advance
@AmanKumar-uu1pk2 жыл бұрын
Data analyst roadmap on youtube... All video are same content follow any
@unknown-kn4uf2 жыл бұрын
Got the job?
@gagansingh34812 жыл бұрын
Hi Chandoo I just got stuck on one problem hope you will help me out . Refer to the IF statement excel workbook. Given people’s name on one line, their street address on then next line, and their city, state and zip code on the following line. How could you put each person’s information in on one line? The main problem there are several alternative rows are blank rows to ...will you please let me know once I drag one joining line downwards it will ignore the blank rows & give the desired result for other text too .......
@chandoo_2 жыл бұрын
Hi Gagan... this sort of data needs proper clean up first. You may refer to this data cleaning video. I show few techniques there. kzfaq.info/get/bejne/ibSGndGVzL2mnKs.html
@richaagrawal3762 жыл бұрын
A great and informative video.Thanks a lot!! Can u plz help me where do i get latest version of Excel for free? I have Excel 2010 and it does not have adequate functions.
@chandoo_2 жыл бұрын
Thanks Richa... You can purchase Excel from office.com. It is not a free software. You can use Excel online which has limited functionality (not sure if this is free, but could be).
@richaagrawal3762 жыл бұрын
@@chandoo_ thanks for prompt reply!! I was looking for free version😆. I have one more question. I was using google sheets while learning your videos., but functions are different there..like slicer or power pivot etc.. Do you think we should learn through google sheets ??
@sohailali51032 жыл бұрын
Sir best laptop for analyst under 40000
@priyankkumar892 жыл бұрын
Chandoo Sir, I am from India, I wish to do remote jobs from India itself, could you please give me some direction or resources about the same. Here in India, I only know about couple of job websites and they only have India job options. I also wish to know your suggestion or recommendation on doing a remote job, especially in this domain. How big a barrier can be if I am not present in office as an analyst, does an analyst has to be in lot of meetings physically?
@chandoo_2 жыл бұрын
Hi Priyank... I suggest gaining some hands-on experience in an industry or two before going for "remote only" jobs. Data Analysis is a people focused field. So without strong domain skills, network & intuition you can't analyze data.
@errydwi94262 жыл бұрын
i'm an undergraduate student that want to learn data analytics, from where should i begin?
@chandoo_2 жыл бұрын
You can start the analytics journey with learning Excel and a bit a of SQL + programming. You can learn other tools based on the job you get.
@nishushroff96562 жыл бұрын
What qualifications should i get for a data analyst
@chandoo_2 жыл бұрын
Most companies ask for undergrad degree (field doesn't matter).
@nishushroff96562 жыл бұрын
@@chandoo_ thank you for your reply 🎉
@adagio54502 жыл бұрын
@Chandoo can you do a similar one for business analysts and if possible pick msft or google. Thanks for all the quality content.
@chandoo_2 жыл бұрын
Good suggestion. I will do a follow-up in a few weeks :)
@Sekoleyte2 жыл бұрын
We tried to make us AWESOME in excel so far. It is sad to see that they don't want us to be AWESOME in excel. Instead, they want us to be GREAT in excel. Well, what will do we do guys now? I don't forgive @Chandoo because he misguided us 😔
@chandoo_2 жыл бұрын
🤣🤣🤣 Don't accept any jobs that want you to be GREAT. Nothing short of AWESOME will do.
@arunrai29092 жыл бұрын
I really like the way you teach and present things! Cool and impressive.
@chandoo_2 жыл бұрын
Glad you like them!
@nandakishorepallikonda7242 жыл бұрын
Love you Chandoo....you are an ocean of knowledge. I have been following your channel for the past many months. Of course your videos are very informative md really helpful. Thank you dear.
@chandoo_2 жыл бұрын
Aww.. thank you 😍😍😍
@vallimadhav2 жыл бұрын
Thank you for the video Chandoo garu . It was so helpful and timely,, as I am planning on a career shift to Data analytics.
@chandoo_2 жыл бұрын
All the best Valli...
@crentistDaDentist2 жыл бұрын
In India they require a fresher to have a work ex of 3yrs 😂
@chandoo_2 жыл бұрын
and 4 of those 3 years on Power BI 🤣
@gurumoorthy52822 жыл бұрын
Hi i m from India one query from my End please provide video for power automate i can see many youtube channel but no one explain like you please provide us support
@chandoo_2 жыл бұрын
Thanks Guru for the suggestion. I am still researching Power Automate video and it will be live on the channel in few more months.
@mansijswarnkar43892 жыл бұрын
Good to know that you also once lived in Hyderabad, as I am currently working in Hyderabad :-)
@chandoo_2 жыл бұрын
Wonderful
@sundertalreja72082 жыл бұрын
This is Great ! one request, A video for what we should include in linkedin profile as Data Analytics professional? thanks in advance !
@chandoo_2 жыл бұрын
Good suggestion Sunder. I will share my thoughts in an upcoming video if possible.
@sunnygawande52832 жыл бұрын
Can you have vdo on VBA??
@chandoo_2 жыл бұрын
I do. Please check my VBA playlist here - kzfaq.info/get/bejne/pMuifMZ9u53FYqc.html
@datascientist62332 жыл бұрын
Excellent Chandu Sir for Give us this valuable insights..
@chandoo_2 жыл бұрын
You are welcome DS...
@jlakshmiprasadreddy64562 жыл бұрын
how importent is academic background when you have the required skillset?
@chandoo_2 жыл бұрын
Most companies ask for some sort of a degree. Having a degree is a "hygiene factor" in recruiting. It is not necessary for the job, but if you don't have one, it can adversely impact your chances.
@jlakshmiprasadreddy64562 жыл бұрын
@@chandoo_ Thank you
@kalyanreddy62602 жыл бұрын
ONLY CALCULATE() ad was awesome 😂😂
@chandoo_2 жыл бұрын
😀
@chaiyya3452 жыл бұрын
Being a HR personel, its almost impossible to fit 100% JD against candidates
@chandoo_2 жыл бұрын
I agree. But you don't want to under specify in the ad an end up with candidates who can't do the tasks.
@Soulenergy312 жыл бұрын
Thank u Chandoo, for such a great walk thru on DA PDs!
@chandoo_2 жыл бұрын
You are welcome Saul... 😀
@poongodipuneet2 жыл бұрын
Extremely good analysis for the Data Analysts job. Really helpful. I have gone through some of the job descriptions of this job, I also had the same thoughts. Keep up your work.👍
@chandoo_2 жыл бұрын
Wow.. thanks Loganathan...
@arun.kumar.s2 жыл бұрын
@Chandoo how important is statistics in data analyst?
@chandoo_2 жыл бұрын
Most DAs use basic statistics on regular basis. Some DAs & almost all Data Scientists need solid understanding of statistical techniques. Better learn them and apply the ideas fast.
@abhijeetghosh272 жыл бұрын
Good analysis of JD's ... Thanks for making and sharing this video @Chandoo 👍👍
@chandoo_2 жыл бұрын
You are welcome Abhijeet...
@nenavathnagaraj55802 жыл бұрын
Sir, can you create a video about creating Power BI portfolio? It would be helpful 🙂
@chandoo_2 жыл бұрын
Good idea Nenavath... I will research this and share some things in a future video.
@nenavathnagaraj55802 жыл бұрын
@@chandoo_ Thank you 😊
@nenavathnagaraj55802 жыл бұрын
Awesome 👌
@Maaz1972 жыл бұрын
how a mechanical engineer start there career data analytics
@chandoo_2 жыл бұрын
If you are already working as an engineer, see if you can transition to data field in your industry. If you are fresher, just apply for data jobs and prove to the recruiter that you are passionate about this field.
@priteshbagal91762 жыл бұрын
thank you bhai
@chandoo_2 жыл бұрын
You are welcome brother...
@DataNarrator2 жыл бұрын
As a fresher how should one focus on domain knowledge areas.
@chandoo_2 жыл бұрын
Focus on the tech and math side first. Domain knowledge only comes with experience. While you can read books or talk to people in the industry, nothing beats working. Internship is another option.
@mohdmehboobkhan99172 жыл бұрын
Sir could you tell me that what certificate will be good for business analytics
@chandoo_2 жыл бұрын
I can't really comment on this. But know that recruiters will value "demonstrated skill" way above certifications. So show them what you can do.
@DilpreetSingh-cs7yz2 жыл бұрын
This vidoe you have made for senior level positions , like this please make one for entry level also.
@chandoo_2 жыл бұрын
Thanks Dilpreet... I will add some points for entry level positions in a future video if possible.
@DilpreetSingh-cs7yz2 жыл бұрын
@@chandoo_ Okay thanks!!
@kurrwa2 жыл бұрын
Yes im interested to see video about entry level too. How to get first experience. I assume to do personal project
@gamer121632 жыл бұрын
Sir can u give me job
@vigneshbabun34192 жыл бұрын
I was looking for this kind of information, thank you for the video sir
@chandoo_2 жыл бұрын
You are welcome Vignesh...
@amanchamadhu1722 жыл бұрын
Sir How to start Carrer in data analyst for a fresher
@redmashbeats54792 жыл бұрын
Why dont you make videos on sql🤔🤔. Data science enthusiasts are hungry to consume sql knowledge.
@chandoo_2 жыл бұрын
I am making one. Creating videos takes a long time. SQL video will be coming in next 6 weeks.
@sauravsuman77932 жыл бұрын
How a mechanical engineer start there career as data analyst ?
@akshaykalwar47302 жыл бұрын
I'm sharing some of the KZfaq channels here- a) Krish Naik, b) Alex the Analyst, c) Corey Schafer, d) Python Programmer, e) Statquest by Josh Starmer f) 3Blue1Brown g) sentdex
@srinivas79402 жыл бұрын
@@akshaykalwar4730 code basics also ...
@guillaumeste-marie69182 жыл бұрын
You could take the Google data analytics certificate
@AzulonKaiba2 жыл бұрын
I am a mechanical engineer. I started with Excel and all related with Excel. Formulas, Power Query, Power Pivot and last VBA. If it feel to much too just learn the fórmulas and Power Query and data visualization principles and Dashboard design. If you don’t feel it’s too much you can learn SQL with Ms Access. I know Python. I have listened that Python is a must for a data analyst here in KZfaq. Let me tell you they are wrong. Python is good for AI. But with Excel and Power Query you can do 90% of non Big data cleaning. I have almost never use Python to work with Excel, it’s better for data engineering stuff.
@akshaykalwar47302 жыл бұрын
@@AzulonKaiba I'm not saying python is mandatory but if you see most of the data analyst job profile, they will ask you to be good in Excel, one of SQL & any BI Tool.
@opentrainingcamp2 жыл бұрын
This is a great video I am a data analyst enthusiastic and I live your videos
@chandoo_2 жыл бұрын
Thanks Birungi...
@riyat7772 жыл бұрын
Bestt one
@chandoo_2 жыл бұрын
Wow.. thank you :)
@jeekakrishna2 жыл бұрын
i was thinking about this and it show up from 1 of my favorite creator..