Data Science has always been around. We have been crunching numbers to get more and more insight out of the data. If you want to experience this challenging job, then you need tp be prepared for these 10 questions:-
1. Introduce yourself – Cliche but very important question, you need to know how to pitch yourself and where to leave a loose end tp trap the interviewer in asking those questions which you want him to ask. If I were at your place, I would have introduce something like below:-
“Hey, this is John Doe, I studied from XYZ and have been a part of ABC company for the last 1 year. I love to play clash of clans and counter strike. I have been part of 2 important analytical project, If you want we can discuss these projects for more context (This is like an open end question and the interviewer will definitely ask you about your project, you just have to pick it from here)
2. What tools and technologies do you use in your current organization?
Ans. – Again you have to put your positive points upfront. Basically you should have the following bucket:-
Any query language – SQL (This is the most important query language) You can learn SQL here 112 questions to crack Business analyst interview using SQL
For analysis – R/SAS/Python – 100 questions to learn R in 6 hours
For reporting – MS Excel/Tableau/Adobe Analytics Top interview questions and all about Adobe Analytics
3. Tell me something about any of your project
Ans.) This should be a winning stroke for you. You got to tell them the best analytical project you have done. In case you don’t have any experience in analysis, I strongly suggest going through Complete analytical project before data science interview. This contains a proper Linear regression project from head to toe.
4. Any case study –
Example – You work at a restaurant and have data of customers i.e. age, name, address, pincode, item ordered, etc. How will you recommend something to the customer from your database
Ans – You can go for co-occurrences , take the age of the customer and look for all those customers with tha same age. Then filter on those customers who ordered the same item and then look for the top 5 co-occurrence item. Now look at the historic data of the customer and look if anything matches. If something matches, then recommend that else recommend the top product from co-occurrence.
For more case studies –
5. The interviewer will definitely ask some logical problem to check your thinking, example – How would you know whether the light of a refrigerator glows or not when you shut its door
Ans.) Put a video camera or phone and shut the door. Replay the video to see the result.
b. Put a radium inside the fridge and then take it out after 10 mins in a dark room. If it’s sparking/glowing then there was light inside
For more logical puzzles – 100 puzzles and case studies to crack data science interview
6. Why do you want to leave your company?
Ans. It’s mostly likely a trap to see if you are trust worthy. Answers to these questions should be there in your mind. You can blame the slow learning experience or lack of exposure, but never blame the company or your boss.
In order to get the answers to all the HR questions try 100 puzzles and case studies to crack data science interview
7. Any question on SQL – These are the most asked questions :-
a. Dense rank
b. rank over partition by
c. where vs having
d. group by, order by
Ans. These are the hot topics. Go through them at least once. If you want to learn more important question then do try
112 questions to crack Business analyst interview using SQL
Do comment if you need article on a particular topic
Thanks for hearing us out,
The Data Monk