Good idea Likhith... Such technical interviews are normally done with a case study (at least here in NZ) and don't happen live. Candidates are give a case and asked to prepare their answers and submit. So may be that is something I can do. If people like this idea, feel free to upvote this comment so I can prioritize it.
Both SQL and PowerBI is very easy to learn but the problem is translating a business problem into the right efficient code is the trick. Very nice selection of questions, highly practical and I like the way you both take turns which makes it more engaging.
Thanks Siva. Yes, learning tech is just one part of the puzzle. The real win is when you can think from customer perspective and figure out intuitive and simple solutions to the problems with the tech.
Absolutely right sir, but i think translating a business problem into the right efficient code this skill have only experienced employee But how can freshers get this skill.. normally they have to work on that.
I was watching Excel Skills for Accountants and came across Power Query, Power Pivots and Power BI. Do you believe Power BI will replace Excel Dashboards in next 5 years time? I have noticed lots of External Data consultants who hate Excel VBA and prefer Power Query. It seems to me there's big shift towards Power BI.
Good Q Bhavik. Power BI is not really a replacement for Excel. It is just another tool. It has its own shortcomings. I did an excellent comparison between these two a while ago here - th-cam.com/video/nOWzpJ4gUKo/w-d-xo.html (you should really watch it). On the other hand, I *HIGHLY* recommend using Power Query for all data clean-up automation. I don't use VBA for this anymore.
Pls give subtitles also. And use mike.and your English is accented. Speak English like Indian. Slowly. Understandable 😊👍🇮🇳. You work with foreigner that's why your English pro. We are beginner 🇮🇳👍😊. Thank for making video. Also watching first time mam also. 😊👍👍
TH-cam makes subtitles automatically. It is a lot of work to manually type them myself. Feel free to volunteer if you want to give back something. You can also adjust video speed on YT. I won't change my accent or talking style for people on internet.
Great Q. Here is how I would answer that. 1) Have one true source of data, ideally database with integrity constraints. 2) If not using a DB, then set up validation rules (in excel, forms etc) to ensure clean data 3) If data is sourced from "typed in" values, identify and fix common typos, synonyms and omissions (for ex: ABC co = ABC Corp) 4) If the data spans a long period of time, figure out ways to handle changes. (for ex: Finance Department renamed to FP&A in 2022) 5) Use Power Query (or other such tools) Column Profile tools to see what is in each column and take necessary steps if needed.
So as a student, I see the courses say that I should be asking SME or my team about the missing data before i take my own decision or discard it. can someone help me understand this?
Hey there! When dealing with missing data, it's crucial to consult with your SME or team, especially if the data ownership isn't solely yours. 🤌🏻 This ensures that any decisions made, like deleting or imputing data, are in line with the team's objectives and won’t lead to unintentional loss of important information. In general, if you're allowed to handle the data independently, you should consider using statistical methods or machine learning models to replace the missing values. Straightforward deletion of missing data can often result in the loss of valuable information, which might affect the accuracy of your analysis. Hope this helps ✨
In a recent interview for Data Analyst role in a furniture company I got a question "Tell me a scenario/situation you faced where you focused on attention to details". I tried to convince them with my answer but it would be great if you could explain the best approach to handle this question. Thank you for the video.
when Jo asked you about your favorite feature in excel, i knew that you will answer PVT and CF. haha. Chandoo, i like all the vids you shared. Jo, as a pro, is definitely a nice addition to your vids. You guys both rock. Thank you!
... the substance of the interview aside, shouldn't this "mock interview" have been in an official environment, someplace where there are data processing tools etc ... IMHO
How do u call an alien with Excel? If an alien arrives will u save ur boss first or urself? Why haven't you worked for 7 years in the last 5 years? Which language do u speak? Python C++ or any other? Why do u need a salary?
i got question, like explain real time there is data everywhere, how you managed to solve a problem ,? question 2, suddenly sale 1.2 M how can you find solution topoint out?, can somebody give good answer, i could not cconvince them, question3, how you share report to other users, if you want to descibe them how you do it.4, what do you do to improve the sale of the prodct when other competitior beats you
Thank you for detailed explanation will you able to make video on more critical situations in reports and management need it urgent how do you deal with that for insurance domain and product
Great video. Using chatgpt with the youtube transcript works wonder. Just add the prompt, please remove timestamp and add punctuation followed by the script. You will have wonderful Q&A notes for better study and absorption.
Is a tech or stem degree mandatory to land a job as data analyst ? I am trying to make a career change. Pls help. Made a project also but not getting callback from recruiters. I am wondering if it's due to lack of engineering degree or CS degree.
sir mai java developer hu muje company data analyst ki profile de rhi aur bol rhi hai on project thoda training denge, to kya mai data analyst ke roles pe work ker paunga bagair proper training ke ?
Great couple! Makes sense, why Chandoo is so energetic, enthusiastic and so versatile! Not very relevant to this mock interview though, lately I have been utilizing SQL in Excel (ADODB.Connection & ADODB.Recordset) a lot. I find that it eliminates the necessity of coming across many complicated steps and utilizing complex functions (often nested) for making aggregated results. So far, I found SQL is faster too, at times I even used inner/nested queries. Do you have any plan for making video lessons on SQL for Excel? Surely your presentation skills and enthusiasm are unparallel. Agree with both of you, conditional formatting is one of the most attractive features of Excel, and for repetitive tasks I often utilize VBA code to apply conditional formatting.
Thank you so much.... This video is very informative for people like me who are learning and simultaneously preparing for interviews... ,,love from india . 🇮🇳🙋❤️
Good, I love that. One question that I want to ask is.What is your biggest error solving time like how much time it takes to solve one particular error (maybe day,week or month)
Thanks Manish. That is a good question too. For questions like that, I recommend using the STAR approach when answering. This score highpoints in the interview. I talk about the STAR approach in this video - th-cam.com/video/f7lBYh1_9BQ/w-d-xo.html
I loved it . Was very useful video !! How long it take to you to become an expert and what do you do when get stuck in a complex task and do it see easy solution how you rest the mind , thanks again looking forward the next
Great Interview! I had my final technical found today and found this to be really handy. I had 1. What's the most challenging situation you have faced 2. How did u overcome it 3. Top tools & programming languages for data analysis
It was really informative and entertaining at the same time. Looking forward for more videos of both of you together.
Sir Please do a Complete technical interview for a data analyst with SQl and Stastical Questions and Reporting Mock Interview
Good idea Likhith... Such technical interviews are normally done with a case study (at least here in NZ) and don't happen live. Candidates are give a case and asked to prepare their answers and submit. So may be that is something I can do. If people like this idea, feel free to upvote this comment so I can prioritize it.
@@chandoo_ Wow. Thank you Sir.. It would be a great help with the Case Study and we'll get a better picture about how it happens.,
@@chandoo_ sir, do this for experienced data analysts,as i have 2 yrs of experience in data analysis and looking for job change... thank you
Both SQL and PowerBI is very easy to learn but the problem is translating a business problem into the right efficient code is the trick. Very nice selection of questions, highly practical and I like the way you both take turns which makes it more engaging.
Thanks Siva. Yes, learning tech is just one part of the puzzle. The real win is when you can think from customer perspective and figure out intuitive and simple solutions to the problems with the tech.
Thank you so much for good answer
Absolutely right sir, but i think translating a business problem into the right efficient code this skill have only experienced employee
But how can freshers get this skill.. normally they have to work on that.
I was watching Excel Skills for Accountants and came across Power Query, Power Pivots and Power BI. Do you believe Power BI will replace Excel Dashboards in next 5 years time? I have noticed lots of External Data consultants who hate Excel VBA and prefer Power Query. It seems to me there's big shift towards Power BI.
Good Q Bhavik.
Power BI is not really a replacement for Excel. It is just another tool. It has its own shortcomings. I did an excellent comparison between these two a while ago here - th-cam.com/video/nOWzpJ4gUKo/w-d-xo.html (you should really watch it).
On the other hand, I *HIGHLY* recommend using Power Query for all data clean-up automation. I don't use VBA for this anymore.
Hi Shashank & Jo, this videos is really informative and you both nailed it as usual. Can you please make a video on testing part of data analysis.
Shashank 😂
I might add a video on the "testing" part in coming months.
She's so confused 😅😂😂🤣
Pls give subtitles also. And use mike.and your English is accented. Speak English like Indian. Slowly. Understandable 😊👍🇮🇳. You work with foreigner that's why your English pro. We are beginner 🇮🇳👍😊. Thank for making video. Also watching first time mam also. 😊👍👍
TH-cam makes subtitles automatically. It is a lot of work to manually type them myself. Feel free to volunteer if you want to give back something. You can also adjust video speed on YT. I won't change my accent or talking style for people on internet.
A Question which I faced: What measures do you adopt to ensure quality data?
Great Q. Here is how I would answer that.
1) Have one true source of data, ideally database with integrity constraints.
2) If not using a DB, then set up validation rules (in excel, forms etc) to ensure clean data
3) If data is sourced from "typed in" values, identify and fix common typos, synonyms and omissions (for ex: ABC co = ABC Corp)
4) If the data spans a long period of time, figure out ways to handle changes. (for ex: Finance Department renamed to FP&A in 2022)
5) Use Power Query (or other such tools) Column Profile tools to see what is in each column and take necessary steps if needed.
So as a student, I see the courses say that I should be asking SME or my team about the missing data before i take my own decision or discard it. can someone help me understand this?
Hey there! When dealing with missing data, it's crucial to consult with your SME or team, especially if the data ownership isn't solely yours. 🤌🏻 This ensures that any decisions made, like deleting or imputing data, are in line with the team's objectives and won’t lead to unintentional loss of important information.
In general, if you're allowed to handle the data independently, you should consider using statistical methods or machine learning models to replace the missing values. Straightforward deletion of missing data can often result in the loss of valuable information, which might affect the accuracy of your analysis.
Hope this helps ✨
This is a gold mock interview!! Great contribution Chandoo!!👏 11:37 a tool that has cells, row and columns,......bed sheet? , hahahahaha
Thanks Saul. It was fun making the video and we had to slip a joke or two as the conversation went on :)
Which one would you recommend from this: MIS(BA) or MSBA?
Good show Chandoo garu....madam pj on Excel was a delight
Thanks Janith... 😀
Hi Chandoo. I find your videos very useful. Are there any way to contact you? I would like to seek some advice from you.
Came back again to say thanks ! This helped me prepare for my interview.
my 2 most favorite people for learning in youtube.
Excel me important kya chiz h sikhna analysis ke liye?
Please sir bata do mujhse excel sikhne nhi ho rha hai 😢😢😢😢😢😢
In a recent interview for Data Analyst role in a furniture company I got a question "Tell me a scenario/situation you faced where you focused on attention to details". I tried to convince them with my answer but it would be great if you could explain the best approach to handle this question. Thank you for the video.
when Jo asked you about your favorite feature in excel, i knew that you will answer PVT and CF. haha.
Chandoo, i like all the vids you shared. Jo, as a pro, is definitely a nice addition to your vids. You guys both rock. Thank you!
Well, someone reads my mind... 😀
This was so good.. Thank you...You guys are awesome 😍💐
Our pleasure Shashank. You are awesome too 😍
She really said Bedsheet instead of Excel. 🤣 I laughed outloud. Even seasoned DA's are normal human beings who forget things sometimes. lol
... the substance of the interview aside, shouldn't this "mock interview" have been in an official environment, someplace where there are data processing tools etc ... IMHO
freshers into IT also can expect such questions ?
How do u call an alien with Excel?
If an alien arrives will u save ur boss first or urself?
Why haven't you worked for 7 years in the last 5 years?
Which language do u speak? Python C++ or any other?
Why do u need a salary?
i got question, like explain real time there is data everywhere, how you managed to solve a problem ,? question 2, suddenly sale 1.2 M how can you find solution topoint out?, can somebody give good answer, i could not cconvince them, question3, how you share report to other users, if you want to descibe them how you do it.4, what do you do to improve the sale of the prodct when other competitior beats you
OMG I definitly enjoyed this. PS the energy you two give off is amzing. Thank you for sharing!
Can you please create a video for the excel formulas commonly used in Excel. Thanks
Thank you for detailed explanation will you able to make video on more critical situations in reports and management need it urgent how do you deal with that for insurance domain and product
Informative and Fun-filled Guys 🎉
Great video. Using chatgpt with the youtube transcript works wonder.
Just add the prompt, please remove timestamp and add punctuation followed by the script.
You will have wonderful Q&A notes for better study and absorption.
Is a tech or stem degree mandatory to land a job as data analyst ? I am trying to make a career change. Pls help. Made a project also but not getting callback from recruiters. I am wondering if it's due to lack of engineering degree or CS degree.
sir mai java developer hu muje company data analyst ki profile de rhi aur bol rhi hai on project thoda training denge, to kya mai data analyst ke roles pe work ker paunga bagair proper training ke ?
Hi how are u chandu....When u come vizag ....
I am great brother. We are planning to come in December.
what a chemistry between them 😍 and his second wife is Excel 😉
most beautful couple in Sirilanka , love u guys amazing
Thanks for sharing valuable information, pls share videos like this type interview questions.
Great insight! I have a similar profile like you and planning to move to NZ, any job openings?
Amazing interview ❤❤❤
Really informative video chandoo. looking forward to more videos like this in the future too.
I wonder how much they enjoy talking to each other since they have same profession😎
Loved this, kindly make more such mock interviews
Questions are really useful and asked so many time.
One more question I want to add here
:want part of your data analyst role you enjoyed doing most?
That is a good one... 😀
Hai Cahndoo.. can u make a 2 or 3 min video on the sql query that u spoke in the video so that we will get an clear idea about that situation...
Very nice interview between spouse... thanks a lot..👍👍
Thank you... Its very useful content for us... Keep update more videos
Creativity and innovation 💡 is trending in today's world & Chandoo has well known how to use 😀 great 👍 work brother.
Thanks Saleh... We (clearly) had loads of fun making the video.
Hi Sir, could you please guide in how to connect jira with power bi using rest api and without any usage of plug-ins... that would be of great help..
Is data analyst is work from home job?
your wife is very supportive and the way she smiles at you :-)
Q) Why do you want to become a data analyst? .
what is the best cloud computing course and specification a data analyst should learn
?
Yes. I was asked to differienciate between a unique key and a primary key
The bloops for me
Nice. First time Im seeing analytics interview mock.
Thanks for this valuable mock interview 👍 🙏 🙌
It was really nice and interactive... Request you to do more
Great couple! Makes sense, why Chandoo is so energetic, enthusiastic and so versatile! Not very relevant to this mock interview though, lately I have been utilizing SQL in Excel (ADODB.Connection & ADODB.Recordset) a lot. I find that it eliminates the necessity of coming across many complicated steps and utilizing complex functions (often nested) for making aggregated results. So far, I found SQL is faster too, at times I even used inner/nested queries. Do you have any plan for making video lessons on SQL for Excel? Surely your presentation skills and enthusiasm are unparallel. Agree with both of you, conditional formatting is one of the most attractive features of Excel, and for repetitive tasks I often utilize VBA code to apply conditional formatting.
do more mock interviews with dofferent people
Useful, Honest and Superb 😀👍
Glad it was helpful Aparna.
Good couple& great job
Haha you guys are fun, Thanks
Bloopers at the end made it even better!
Thank you for sharing 🙏🏻
looking for more such videos
Thank you so much.... This video is very informative for people like me who are learning and simultaneously preparing for interviews... ,,love from india . 🇮🇳🙋❤️
I love watching you too do these sort of things. Excellent nuggets.
Great video, pivot tables are my favourite also
watching this way is really fun!
Hi bro I'm from vizag. Love you
Mr. and Mrs. chandoo, you have really make my day. may the lord richly bless you through all aspects of thy tutorials. thanks
You are welcome Wumbei. Thanks for your love and appreciation of our work 😍
This is how Data Analysts Interacts on their first Date.... :P :D .. Btw it was a really good video. God Bless!!!
😂
What is data analyst's ideal date?
dd-mm-yyyy of course.
@@chandoo_ Unless he/she is from US then mm-dd-yyyy :)
please make more videos like this
Good, I love that. One question that I want to ask is.What is your biggest error solving time like how much time it takes to solve one particular error (maybe day,week or month)
Thanks Manish. That is a good question too.
For questions like that, I recommend using the STAR approach when answering. This score highpoints in the interview. I talk about the STAR approach in this video - th-cam.com/video/f7lBYh1_9BQ/w-d-xo.html
Husband and Wife both nailed it!!
😊
Hey Chandoo, upto what % of missing value can be ignored.
There is no rule like that. You will need to make decisions based on data quality and domain.
Nicely done. Great team! Thanks so much.
I am in India and need an expert like yourself. How do we find such experts?
Hmm, look for people thru linkedin or naukri?
Best video for the week, beneficial info.
These questions asked for fresher or experience candidates??
These are usually asked to experienced people (although some questions can be asked to Freshers too).
Thanks for the information
Thanks to both of you
You are welcome Ramesh.
We need more of these please
Cool Interview...
You are welcome Ramnath.
U r the best
Bedsheet 😂😂😂
11:26-11:38 got me rolling on the floor. Thanks for this video.
Glad you enjoyed it!
really loved it
Very informative.
I loved it . Was very useful video !! How long it take to you to become an expert and what do you do when get stuck in a complex task and do it see easy solution how you rest the mind , thanks again looking forward the next
Thanks Jorge... Good questions there.
Nice
Great
Sooper Sir😁
exclent brother and sister
😂
👍
very informative
Glad you think so!
I love this, u nailed it
Thanks Sabiti...
Wowww
Thanks Gaurav...
Nice video 😉
Thanks Asad.
Marvellous!!!
Thanks Blue...
Amazing video Chandoo!
Thanks Prudhvi...
Great Interview!
I had my final technical found today and found this to be really handy.
I had
1. What's the most challenging situation you have faced
2. How did u overcome it
3. Top tools & programming languages for data analysis
hi moonknight
hey... 😎
@@chandoo_ how are you moonknight
Chandoo..I have a question. Why do you start of new series on career opportunities in NZ...It definitely helpful for us.