Top 10 Data Analyst Interview Questions (with answers)

[@monika_0369]

It was really informative and entertaining at the same time. Looking forward for more videos of both of you together.

[@likhithkumar5458]

Sir Please do a Complete technical interview for a data analyst with SQl and Stastical Questions and Reporting Mock Interview

[@chandoo_]

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.

[@likhithkumar5458]

@@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.,

[@nishushroff9656]

@@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

[@jamescaiquep3794]

my 2 most favorite people for learning in youtube.

[@sivamagesh]

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.

[@chandoo_]

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.

[@theBetterCommunicator]

Thank you so much for good answer

[@sunildandge68]

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.

[@rohini_mohan]

Came back again to say thanks ! This helped me prepare for my interview.

[@Studentof2025]

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.

[@AllenBako]

I love watching you too do these sort of things. Excellent nuggets.

[@ahlycya]

OMG I definitly enjoyed this. PS the energy you two give off is amzing. Thank you for sharing!

[@tanteckleng3665]

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.

[@krupakhandor7103]

your wife is very supportive and the way she smiles at you :-)

[@VRchitecture]

Bloopers at the end made it even better! Thank you for sharing 🙏🏻

[@muhammadzafar420]

most beautful couple in Sirilanka , love u guys amazing

[@Bhavik_Khatri]

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.

[@chandoo_]

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 - kzbin.info/www/bejne/pIC6q6OAacyIgdE (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.

[@toluolowookere6113]

Yes. I was asked to differienciate between a unique key and a primary key

[@arjundev4908]

Husband and Wife both nailed it!!

[@chandoo_]

😊

[@nazarkamal8831]

Amazing interview ❤❤❤

[@letsshare1729_ideas]

Thanks for sharing valuable information, pls share videos like this type interview questions.

[@mantashashaikh9864]

I wonder how much they enjoy talking to each other since they have same profession😎

[@rohiitq]

watching this way is really fun!

[@Potharajup]

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.

[@chandoo_]

Shashank 😂 I might add a video on the "testing" part in coming months.

[@shashankks2454]

She's so confused 😅😂😂🤣

[@JeevarajFredrick]

Informative and Fun-filled Guys 🎉

[@U-Tuber.]

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!

[@chandoo_]

Well, someone reads my mind... 😀

[@Soulenergy31]

This is a gold mock interview!! Great contribution Chandoo!!👏 11:37 a tool that has cells, row and columns,......bed sheet? , hahahahaha

[@chandoo_]

Thanks Saul. It was fun making the video and we had to slip a joke or two as the conversation went on :)

[@ihgamingfun6295]

Very nice interview between spouse... thanks a lot..👍👍

[@janithb1309]

Good show Chandoo garu....madam pj on Excel was a delight

[@chandoo_]

Thanks Janith... 😀

[@wumbeiemmanuel184]

Mr. and Mrs. chandoo, you have really make my day. may the lord richly bless you through all aspects of thy tutorials. thanks

[@chandoo_]

You are welcome Wumbei. Thanks for your love and appreciation of our work 😍

[@rajkumarpalle8217]

Thank you... Its very useful content for us... Keep update more videos

[@mask1582]

what a chemistry between them 😍 and his second wife is Excel 😉

[@ignaoriginals4554]

We need more of these please

[@ashokbbm]

Nice. First time Im seeing analytics interview mock.

[@pappukumarsharma1383]

Best video for the week, beneficial info.

[@meenayegan6634]

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

[@salehmuhammad6811]

Creativity and innovation 💡 is trending in today's world & Chandoo has well known how to use 😀 great 👍 work brother.

[@chandoo_]

Thanks Saleh... We (clearly) had loads of fun making the video.

[@kurticotton]

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. 😊👍👍

[@chandoo_]

KZbin 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.

[@manishdaga]

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)

[@chandoo_]

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 - kzbin.info/www/bejne/nGjPc4yeZsRseLM

[@aparnapandravada5073]

Useful, Honest and Superb 😀👍

[@chandoo_]

Glad it was helpful Aparna.

[@agkalyan]

Thanks for this valuable mock interview 👍 🙏 🙌

[@p_anjali_codes]

Loved this, kindly make more such mock interviews

[@saikiranreddykalluri6090]

Sooper Sir😁

[@shashankks2454]

This was so good.. Thank you...You guys are awesome 😍💐

[@chandoo_]

Our pleasure Shashank. You are awesome too 😍

[@hemanthkumar4870]

It was really nice and interactive... Request you to do more

[@prakashaggarwal3551]

Thanks for the information

[@exploreeatenjoy9600]

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

[@aceallen2505]

Which one would you recommend from this: MIS(BA) or MSBA?

[@sabitichristopher]

The bloops for me

[@rameshkandi]

Thanks to both of you

[@chandoo_]

You are welcome Ramesh.

[@vishwaspai8192]

Really informative video chandoo. looking forward to more videos like this in the future too.

[@YugaliSwethaThopu]

Can you please create a video for the excel formulas commonly used in Excel. Thanks

[@timmytesla9655]

11:26-11:38 got me rolling on the floor. Thanks for this video.

[@chandoo_]

Glad you enjoyed it!

[@ThankGod143]

looking for more such videos

[@ChrisSmithFW]

Nicely done. Great team! Thanks so much.

[@raghuram1495]

really loved it

[@NiyasAdventurers]

Great video, pivot tables are my favourite also

[@meaganmedeiros861]

She really said Bedsheet instead of Excel. 🤣 I laughed outloud. Even seasoned DA's are normal human beings who forget things sometimes. lol

[@pk9836]

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?

[@PrepareWithPriya]

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 ✨

[@dakshpancholi3185]

Haha you guys are fun, Thanks

[@nagarapusudheeksha5750]

Thank you so much.... This video is very informative for people like me who are learning and simultaneously preparing for interviews... ,,love from india . 🇮🇳🙋❤️

[@abdulwaki8590]

Great

[@user-ll1ox7xq6x]

Cool Interview...

[@chandoo_]

You are welcome Ramnath.

[@praneshsamala]

what is the best cloud computing course and specification a data analyst should learn ?

[@vickyk6607]

Very informative.

[@likhithlicky2947]

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...

[@Nikhil-qi4oz]

please make more videos like this

[@AllaboutExperienceReshh]

Good couple& great job

[@manhaabdellah3474]

very informative

[@chandoo_]

Glad you think so!

[@gvinodnair]

A Question which I faced: What measures do you adopt to ensure quality data?

[@chandoo_]

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.

[@rajishn]

freshers into IT also can expect such questions ?

[@sabitichristopher]

I love this, u nailed it

[@chandoo_]

Thanks Sabiti...

[@mahmodi5timetolearn]

U r the best

[@afreenparween6799]

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?

[@chandoo_]

That is a good one... 😀

[@mrashid229]

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.

[@flarejam1]

This is how Data Analysts Interacts on their first Date.... :P :D .. Btw it was a really good video. God Bless!!!

[@chandoo_]

😂 What is data analyst's ideal date? dd-mm-yyyy of course.

[@asiolekb]

@@chandoo_ Unless he/she is from US then mm-dd-yyyy :)

[@himajadeevi1466]

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..

[@vinayakbadiger2063]

Nice

[@bluesage1528]

Marvellous!!!

[@chandoo_]

Thanks Blue...

[@kunalpatil8747]

Great insight! I have a similar profile like you and planning to move to NZ, any job openings?

[@jorgelara3116]

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

[@chandoo_]

Thanks Jorge... Good questions there.

[@nsprudhvi]

Amazing video Chandoo!

[@chandoo_]

Thanks Prudhvi...

[@theblogger3664]

Hi bro I'm from vizag. Love you

[@jeekakrishna]

do more mock interviews with dofferent people

[@Rmk1010]

Hi sir you are doing very well work in the world to the people. You done great job and pushed all people to next level in job or business via youtube channel. I am Mohamed Rabeek K from India, Tamil Nadu. I am a Degree holder and job seeker now in Data analyst or accountant . I know Excel basics only very long back and my friend suggested me learn Excel in tutorials point youtube channel. So I am learning Excel functions, charts, pivot table, data validation etc. I learned 103 videos in that channel about Excel which is very good. And I usually searching Excel in youtube that time your channel appeared and I watched. Your channel is really amazing and easy to learn. I downloaded your CHANDOO channel data analysis course video. I am learning now to get job. My thanks to you So continue your great work like Excel, power bi , data analysis which helps to people to upgrading the skill and survive. So I don't know where you are in this world you live long with your family, healthy,wealthy and enjoyed all time sir Keep Rocking sir Thanks and Regards Mohamed Rabeek K

[@chandoo_]

Thank you Mohamed for your love and support. I really appreciate your dedication to learn. I wish you all the best with your job search.

[@Rmk1010]

@@chandoo_ Thank u Chandoo sir. Continue the great work for the people. Make a video in simplest way and for job approaching. Make a video of Excel, power bi for working professional. I kindly request you Chandoo sir Where to search vacancy of data analyst job in good company in india, main city Chennai. I am searching in naukri, shine, up to now I will try in LinkedIn also I completed more videos Chandoo sir Tell the way please sir Bye sir

[@gauravsingh8274]

Wowww

[@chandoo_]

Thanks Gaurav...

[@asad3856]

Nice video 😉

[@chandoo_]

Thanks Asad.

[@creativeminichitra9802]

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

[@Himanshusingh-yd3qx]

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 ?

[@bhaskarbala999]

exclent brother and sister

[@chandoo_]

😂

[@kamarthiudaysai7026]

These questions asked for fresher or experience candidates??

[@chandoo_]

These are usually asked to experienced people (although some questions can be asked to Freshers too).

[@theblogger3664]

Hi how are u chandu....When u come vizag ....

[@chandoo_]

I am great brother. We are planning to come in December.

[@vivekjoshi3769]

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.

[@oblicsorders25]

I am in India and need an expert like yourself. How do we find such experts?

[@chandoo_]

Hmm, look for people thru linkedin or naukri?

[@suhasini1159]

Is data analyst is work from home job?

[@rtk_here]

Excel me important kya chiz h sikhna analysis ke liye? Please sir bata do mujhse excel sikhne nhi ho rha hai 😢😢😢😢😢😢

[@mueezadeen7838]

Q) Why do you want to become a data analyst? .

[@utube_int2075]

Hi Chandoo. I find your videos very useful. Are there any way to contact you? I would like to seek some advice from you.

[@crentistDaDentist]

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?

[@baptistdsouza8424]

Hey Chandoo, upto what % of missing value can be ignored.

[@chandoo_]

There is no rule like that. You will need to make decisions based on data quality and domain.

[@badullashaik3319]

👍

[@hemanthkumar4870]

Chandoo..I have a question. Why do you start of new series on career opportunities in NZ...It definitely helpful for us.

[@jishnujagannath6331]

Bedsheet 😂😂😂

[@0002-u8i]

hi moonknight

[@chandoo_]

hey... 😎

[@0002-u8i]

@@chandoo_ how are you moonknight