Data Analyst INTERVIEW QUESTIONS & ANSWERS (#1) - SQL Solution
I give an example of data analyst interview questions and answers and give you data analyst interview tips to respond to these using SQL.
Hey guys,
In this video I have created an example interview question and provides an answer to that. I focus on splitting up by first focusing on it from a business point of view, before moving into SQL and showing some queries that are solving the specific questions in the request.
Click here to subscribe! https://bit.ly/3xL8Dm6
Video Content:
0:00 Welcome
0:32 Breaking Down Problem
4:35 Question 1 Response
7:58 Question 2 Response
9:55 Question 3 Response
11:40 Wrap Up
If you want to try the problem yourself, it is as following:
"Hi X,
I hope you are doing well. We are having our quarterly planning and need some information
about our current product portfolio.
First of all I need a list of all our products, but it is important that we filter out
products that aren't valid anymore and I only want the ones that are from this year and last year.
How many did we actually start this year vs. last year? Could you help me out with that? We just need the product names, the model and description, preferably in English.
The second thing which would really help us out if we can get some data that gives us an idea of what our inventory looks like. What we are focusing on is Color and Sizes as we need to look at having enough options across our inventory! If you see any alarmingly low numbers, then that would be great to have that pointed out.
A last thing is that it would be great to know is which products that has the highest
opportunity of profit, given that we actually sell it of course!
Thanks for the help as always :)!
Hope you enjoy the video!
// Ali
________________________
Let’s stay in touch:
📸 Instagram – @iamaliahmadd
🔗 LinkedIn – / aliahmad1987
#DataAnalyst #DataAnalytics #DataAnalysis #Data #Analysis #AliAhmad #PowerBI