It’s useful for all interviews with a tweak here and there. I am a mechanical engineer and a recruiter sent me some interview tips. Some of these Chandoo has mentioned including STAR, were on there
This was a great video & reminder, Chandoo! Especially the reminder to not be too hard on ourselves. Loved the family guest stars! Thanks for the virtual mentorship!
Just keep going. My first job I found after about a year of searching. Currently I am also jobless since May 2020 and looking for a mechanical engineer position near Pittsburgh I will not give up and neither should you. It will happen, especially with these tips
brilliant stuff Chandoo and your family contributions ... I had a year secondment offer and my option given was Chennai :D - Yes I used STAR - really focusing on the outcome the benefits that were realised. After every interview the first thing i would do is write down all the questions i was asked to learn from experience. My CV is written in an achievement style similar to STAR answers but condensed .
Flexibility is a sticky point. I think being upfront is important. Honestly depends on your circumstances. Especially harder when you are a woman with a young family. Fortunately one good thing from COVID is flexible working hours and location so now it does make it a bit easier.
You teach so smoothly and beautifully.....🎉🎉🎉🎉🎉 You and your wife both are just amazing people 🎉🎉🎉 thank you sir..... Alot of respect and love from India
Super Awesome video, the point that we work alot to say in the interviews but it's much better when we could show the work and talk more on that. Makes a lot of sense to me.
Articulate, Informative, Inspiring, revealing, thought provoking, realistic, impressive, insightful, and appealing. Thank you very much,. You have explained in an excellent manner.
STAR concept is very useful. I have been using it unknowingly during meetings with prospective customers. However, I never knew about this terminology. I know about SMART goals though.
Thanks for sharing your experience. great videos.. please keep it up. I get more clarity while watching your videos and like the way you explain things in a very relaxed manner...Looking forward for many videos like this.
Iam giving interviews since last two months..got two jobs but not thinking about money only ends up in low paying jobs. I think we should negotiate salary also when it comes to interviews and when they ask you how much are expecting
good advice. i def feel it's a chance for me to suss them out as well. after all, they will be paying me for my work. my current job had a great process. at the time, i wasn't sure i needed to look yet. so i only applied to jobs that didn't waste my time filling information into their HR interface. i was leaning hard on old school resume. and my boss got 110 applications for this role from which he chose the ~10 best to phone interview and of those he'd pick the top ~3 to give data and see what they did with it. i'm not super cocky, but i know i'm good enough and different enough that i'd get the job if i got to the final 3. i was already in top 10% at that point. just hearing how he was testing potential hires made me want this job more. and the funniest part is i had changed my generic career identity on top of resume from data/sales analyst to brain conservationist. which is how i ended up on the top 10. hahaha. for a quirky person to find a quirky company, that worked. wouldn't do that if i was for sure hard focused seeking.
Thanks for the tips. One thing I have come across at an interview is that often the interviewer itself is not knowledgeable enough about the subject matter we discuss. For example, when speaking about Power Query/Power Pivot/Power BI very often it goes right over their heads! I cannot explain a value addition I have made via these tools where the systems are not that great. You run into blank faces when you try to explain them and how useful they are! The tools in Office 365 Excel like LET functions are no go areas!
May I recommend the viewers to play "Happy Classical Music: Mozart, Vivaldi, Beethoven" on low volume as this video plays? its enhances the video and mood for those of us who feel a nervous about being interviewed like me😫 thank you for your great videos
You have amazing videos! I’m new to excel & can’t figure out how to extract my staff only from a large dataset. The file has 175K rows & staff in 3 columns. Can I extract just those rows with my team in the 3 columns?
Great Delivery Sir I have made some mistakes you mentioned in the video, Now I can see clearly. Sir how can we show our works if its from our previous companies.? Should we have some dashboards build already even if we are going for an associate role?
For my interviews, I try to have a couple of examples & I excerpt the information. Meaning I replace any specific information for the company (e.g., employee names). It is easier to walk interviewers through a visual example sometimes.
Hi, Am coming from Manufacturing Background with 14 Years' experience. I Am fascinated with Data Analytics. Had created Dashboards & Programming in Advance Excel for our Production Operation Streamlining, Inventory Management & Production Planning. I would like to move my Career to Data Analytics. Can you please guide me on what will be the best path to Proceed?
Try looking for any data jobs in your industry / current workplace. This is the best way to transition. Also reach out to your colleagues (both current and ex) and see if any of them can refer you for a job in data / tech. If nothing works, apply for data jobs outside with a strong cover letter or find a consultant / agent to represent you. All the best.
Hi Chandoo, thank you for the valuable insights, I can surely relate to couple of the highly mistakes, especially being hard on myself. I have an interview scheduled where in the core area will be about my experience with a BI tool. I haven't done any heavy handed work with it like scripting or such, so how can I face such interviews where they require you to be an SME, but you had been a user throughout?
Thanks Sreekanth. Why not be honest and tell them what you did in the previous role, how you can contribute in the new role. As a previous user of the reports, your perspective and ideas can be very valuable when you "switch" sides.
And please enlighten how we should apply the STAR technique if we are a fresher and learned Power BI through tutorials or while preparing for the Certification.
Dear sir i am working in the garment manufacturing unit and i received orders for stitching and want to track all garments orders separately on excel in which included 1.order making of received clothes 2.Customer details in order 2. give a specific number to the order automaticaly 3.recived time & completed time
Hello sir, I have never faced any interview in my life. I am graduated in 2022, Since after passing out , I learned technical skills on EXCEL SQL SAS POWERBI TABLEAU. I fell very nervous to atttend any interview, how to prepare for my interview and how should i remove nervousness for interview.
For most of us we're breaching company confidentiality if we use examples from our work place and show it to a recruiter/future employer. And if I were an employer, I'd think seriously about hiring someone who didn't think twice about showing me confidential info. That might work for a contractor but not an employee. Not particularly good advice, very unprofessional.
I am going to have a junior workforce analyst interview. I have some experience working with SQL and MS Excel from my bachelor. Could you give me some tips or even anyone know how this interview gonna be like? There will be 2 parts the first is the interview and the second a 30-minute test in Excel, SQL and Math Logic, using multiple choice questions.
Tip: you don't pass a serious interview with interview techniques. You only pass by showing knowledge of your field. If you don't have those skills and you pass anyway, then your new employer doesn't care about skills... welcome to hell in which you will be greeted by many clueless co-workers. ;-)
That depends on the policy. If I am interviewing, I would request you to make it without chatgpt help. But I also want to see what your process is and how you think.
@@chandoo_ my reference point is that there is a sizeable difference with fewer women than men working in the same profession due to lifestyle and gender preferences. if women were paid 77 percent of what men made then why do you not see companies reduce operating costs by hiring exclusively women?
Are you for real? That is not how it works. As this is not the right platform discussing such a thing, may I suggest talking to a few women in your family / friends / local industry to see their perspective. Gender & lifestyle issues are not the main reason for the gap. I did extensive studies in this and worked with many local government organizations. There is bias everywhere.
Quote: "money is by product"
I like this quote. Tks Chandoo
This tutorial is not only for Data Analyst even it is useful for any IT related job interview. Thank you 😊
It’s useful for all interviews with a tweak here and there. I am a mechanical engineer and a recruiter sent me some interview tips. Some of these Chandoo has mentioned including STAR, were on there
Yes... as I never attended other interviews, played safe with my research and narrative there. :)
This was a great video & reminder, Chandoo! Especially the reminder to not be too hard on ourselves. Loved the family guest stars! Thanks for the virtual mentorship!
Very useful tips Chandoo.
I’m Jobless for the past 3.5 months and still counting… Trying my level best and hoping to have some positive outcome ASAP.
Just keep going. My first job I found after about a year of searching. Currently I am also jobless since May 2020 and looking for a mechanical engineer position near Pittsburgh
I will not give up and neither should you. It will happen, especially with these tips
@@patrickschardt7724 Thanks for your caring and kind words. ❤️ Wishing you too good luck with your job hunt.👍🏻
You are welcome Vinod. I wish you all the best in your job search.
best wishes for your job search. you will get it.
brilliant stuff Chandoo and your family contributions ... I had a year secondment offer and my option given was Chennai :D - Yes I used STAR - really focusing on the outcome the benefits that were realised. After every interview the first thing i would do is write down all the questions i was asked to learn from experience. My CV is written in an achievement style similar to STAR answers but condensed .
I always take notes during the interview. Great idea to write down the questions asked!
Flexibility is a sticky point. I think being upfront is important. Honestly depends on your circumstances. Especially harder when you are a woman with a young family. Fortunately one good thing from COVID is flexible working hours and location so now it does make it a bit easier.
I found this video just at the right time of my career. Thanks Chandoo, this really helps.
Glad it helped!
Your channel is a gold finding. Every video I get more impressed!!
Thanks for the awesome stuff there.
You're really making difference in people's life.
Happy to hear that!
You teach so smoothly and beautifully.....🎉🎉🎉🎉🎉 You and your wife both are just amazing people 🎉🎉🎉 thank you sir..... Alot of respect and love from India
Our pleasure!
Super Awesome video, the point that we work alot to say in the interviews but it's much better when we could show the work and talk more on that. Makes a lot of sense to me.
I’ve always used STAR, but now something more to use. Thanks for the Triangle idea. New one for me.
Top Notch Content, thanks for sharing these insights! All your videos are just perfectly edited and to the point. :)
Great stuff, all points covered. Thanks😊
Glad you enjoyed it!
Kudos to you. You're such a humble person. Learning a lot. Keep sharing my Guru!
Articulate, Informative, Inspiring, revealing, thought provoking, realistic, impressive, insightful, and appealing. Thank you very much,. You have explained in an excellent manner.
STAR concept is very useful. I have been using it unknowingly during meetings with prospective customers. However, I never knew about this terminology. I know about SMART goals though.
Thanks for sharing your experience. great videos.. please keep it up. I get more clarity while watching your videos and like the way you explain things in a very relaxed manner...Looking forward for many videos like this.
Very helpful video sir, thank you so much 🙂
You are welcome Shikhar...
Very Helpful stuff, nerve calming
The videos are really great 👍made by you. Keep it up. ⬆ Will be waiting for even more ✌🏻👌🏻
Thank you Chandoo. It's very useful and more practical 👍
Love the insights.
Great advice! Thanks for the tips. Thumbs up!!
Glad it was helpful Wayne...
Really thank you so much for your wonderful experience to share with us.
Thank you Chand for the tips for facing an interview it will help many freshers to crack a job by using the "STAR" method really I loved it...
STAR METHOD! oh boy this is pure GOLD since second 1, thanks a lot Mr. Chandoo
You are welcome Antonio...
Great tips.. especially the last one... thank you
Very helpful.I am going to attend the interviews in upcoming months.I will surely apply your techniques for same.
I am definitely going to use the STAR approach and the last tip for the coming internship. Thankyou sir.
All the best Girija...
@@chandoo_ Thankyou sir
Thank you so much ..for sharing the informative video...
Iam giving interviews since last two months..got two jobs but not thinking about money only ends up in low paying jobs. I think we should negotiate salary also when it comes to interviews and when they ask you how much are expecting
Thank You, Sir!!
🙏😊😇
Thanks for sharing such deep points.
My pleasure!
Thank you
one of the best channel in the youtube.
Thanks for insights
I can say just one word - "Wonderful"
Very understandable examples
good advice. i def feel it's a chance for me to suss them out as well. after all, they will be paying me for my work. my current job had a great process. at the time, i wasn't sure i needed to look yet. so i only applied to jobs that didn't waste my time filling information into their HR interface. i was leaning hard on old school resume. and my boss got 110 applications for this role from which he chose the ~10 best to phone interview and of those he'd pick the top ~3 to give data and see what they did with it. i'm not super cocky, but i know i'm good enough and different enough that i'd get the job if i got to the final 3. i was already in top 10% at that point. just hearing how he was testing potential hires made me want this job more. and the funniest part is i had changed my generic career identity on top of resume from data/sales analyst to brain conservationist. which is how i ended up on the top 10. hahaha. for a quirky person to find a quirky company, that worked. wouldn't do that if i was for sure hard focused seeking.
Amazing .. Quite informative
Just great 👍🏻
This is very helpful
Thankq brother!
I’m interviewing with Amazon next week. Hope this video helps!
Thanks for the tips. One thing I have come across at an interview is that often the interviewer itself is not knowledgeable enough about the subject matter we discuss. For example, when speaking about Power Query/Power Pivot/Power BI very often it goes right over their heads! I cannot explain a value addition I have made via these tools where the systems are not that great. You run into blank faces when you try to explain them and how useful they are! The tools in Office 365 Excel like LET functions are no go areas!
May I recommend the viewers to play "Happy Classical Music: Mozart, Vivaldi, Beethoven" on low volume as this video plays? its enhances the video and mood for those of us who feel a nervous about being interviewed like me😫 thank you for your great videos
really insightful tips..
You have amazing videos! I’m new to excel & can’t figure out how to extract my staff only from a large dataset. The file has 175K rows & staff in 3 columns. Can I extract just those rows with my team in the 3 columns?
awesome tips...learned a lot...
Glad to hear it!
Helpful n prcatical...thanks
You are welcome
Thank You Sir ❤
Awsome chando....Valuable info.....👌
thanks chandoo bhai, its realy a awsome video
Most welcome
Dear Chandoo Garu, Thanking to you allowing us to get Excellent suggestions through your video
It's my pleasure
Nice
Thank you...helpful
Glad it was helpful!
Thanks so the guidance 🙂🙂
You are welcome Arun...
Very inspired...
Excellent chandoo
I should have watched this video weeks ago when I was doing interviews Lol... Great tips
You are awesome @chandoo👏👏
Really awesome Sir..
Thanks a lot
Hello Chadoo, i have my final round of interview with HSBC next week, Can you please share few tips and advices
🙏 Thanks SIR
Great Delivery Sir I have made some mistakes you mentioned in the video, Now I can see clearly.
Sir how can we show our works if its from our previous companies.? Should we have some dashboards build already even if we are going for an associate role?
For my interviews, I try to have a couple of examples & I excerpt the information. Meaning I replace any specific information for the company (e.g., employee names). It is easier to walk interviewers through a visual example sometimes.
Thanks Sudharshana... You can take screenshots, blur portions and use them. You can replicate them with made up data and use them as well.
Great tips chandoo
You are welcome Rodney.
Fantastic
Thank you so much 😀
Thanks Chandoo.
You are welcome Swapnil... 😀
Hi, Am coming from Manufacturing Background with 14 Years' experience. I Am fascinated with Data Analytics. Had created Dashboards & Programming in Advance Excel for our Production Operation Streamlining, Inventory Management & Production Planning. I would like to move my Career to Data Analytics. Can you please guide me on what will be the best path to Proceed?
Try looking for any data jobs in your industry / current workplace. This is the best way to transition. Also reach out to your colleagues (both current and ex) and see if any of them can refer you for a job in data / tech. If nothing works, apply for data jobs outside with a strong cover letter or find a consultant / agent to represent you. All the best.
Superb👍
Thanks 🤗
@chandoo I want to be just like you.
Can you guide, which are the tools using as data analyst. It would help me alot
Very thankful chandoooooo. I
You are welcome Pavan... 😀
Hi Chandoo, thank you for the valuable insights, I can surely relate to couple of the highly mistakes, especially being hard on myself. I have an interview scheduled where in the core area will be about my experience with a BI tool. I haven't done any heavy handed work with it like scripting or such, so how can I face such interviews where they require you to be an SME, but you had been a user throughout?
Thanks Sreekanth.
Why not be honest and tell them what you did in the previous role, how you can contribute in the new role. As a previous user of the reports, your perspective and ideas can be very valuable when you "switch" sides.
@@chandoo_ Thank you very much for your valuable advice, i will keep that in mind. Much appreciated.
Chando, I wish to meet you man, very nice attitude. Respect from pakistan 🇵🇰 bro
Thank you Rehan :)
And please enlighten how we should apply the STAR technique if we are a fresher and learned Power BI through tutorials or while preparing for the Certification.
You can use the experiences gained during internships, voluntary projects or any freelance work.
Dear sir
i am working in the garment manufacturing unit and i received orders for stitching and want to track all garments orders separately on excel
in which included
1.order making of received clothes
2.Customer details in order
2. give a specific number to the order automaticaly
3.recived time & completed time
I am waiting for your reply
Thank you very much
Thanks for the suggestion. Please use my Excel tracker video to understand how to make this. czcams.com/video/e0s9xdx5FF8/video.html
Sir I m ready to work for u.Could u please give this work for me then i will do it for u.
Hello sir, I have never faced any interview in my life. I am graduated in 2022, Since after passing out , I learned technical skills on EXCEL SQL SAS POWERBI TABLEAU. I fell very nervous to atttend any interview, how to prepare for my interview and how should i remove nervousness for interview.
For most of us we're breaching company confidentiality if we use examples from our work place and show it to a recruiter/future employer. And if I were an employer, I'd think seriously about hiring someone who didn't think twice about showing me confidential info. That might work for a contractor but not an employee. Not particularly good advice, very unprofessional.
I make all 7 mistakes in one interview
Its very hard to find the people where u join ask or get the info why the people are exit, will the people are happy and satify there work..
I am going to have a junior workforce analyst interview. I have some experience working with SQL and MS Excel from my bachelor. Could you give me some tips or even anyone know how this interview gonna be like? There will be 2 parts the first is the interview and the second a 30-minute test in Excel, SQL and Math Logic, using multiple choice questions.
Goood
how to communicate the career gap to interviewer?/ sir
Hii sir iam fresher
I just completed my Data analysis Course
Now I'm preparing For Interviews
Give Some Interview Tips. ☺
Tip: you don't pass a serious interview with interview techniques. You only pass by showing knowledge of your field. If you don't have those skills and you pass anyway, then your new employer doesn't care about skills... welcome to hell in which you will be greeted by many clueless co-workers. ;-)
sir my all friends and know one got the job except me a
ia, fill very low
Sir plz guide freshers for the Interview
I can't get the managers to respond to feedback email requests. 😔
Hii sir I stat learning tools of data analyst can you tell me something how i describe my path?
How to negotiate
if I use mobile to show my work interviewer can accept ?
That depends. Sure try it. But carry a few print outs or even your laptop so you can actually demonstrate rather than show some screenshots.
Sir, if they asked to create excel dashboard in interview, then is it allow to create it with chatgpt
That depends on the policy. If I am interviewing, I would request you to make it without chatgpt help. But I also want to see what your process is and how you think.
@@chandoo_ ok, thank you sir♥️
I dont understand how to make a project i belong to a completely different background😪. All i hv are certificates
Please bhagwan muje july mein muje job lag jaaye❤
bro are from telugu states
Hello sir. I have registered for tata imagination Chllenge. Can you please suggest me some tips to win this challenge?
I can't. I don't know what that is.
but there's no gender pay gap. was this meant to sarcastic
hmm.. Gender pay gap is present in pretty much all countries. Not sure what your reference point is.
@@chandoo_ my reference point is that there is a sizeable difference with fewer women than men working in the same profession due to lifestyle and gender preferences. if women were paid 77 percent of what men made then why do you not see companies reduce operating costs by hiring exclusively women?
Are you for real? That is not how it works.
As this is not the right platform discussing such a thing, may I suggest talking to a few women in your family / friends / local industry to see their perspective. Gender & lifestyle issues are not the main reason for the gap. I did extensive studies in this and worked with many local government organizations. There is bias everywhere.