Реальное собеседование на Аналитика Данных. Разбор и правильные ответы.

You'll now see a recording of a real interview for a Junior Data Analytics position. The questions will be challenging, and the same questions could easily be asked for a mid-level or higher position. Remember, all questions are the same in all interviews, so watch this video very carefully. Pause the video and try to answer the questions the candidates ask yourself, then watch the correct answer. 🔑 Submit a request for a TURNKEY OFFER and a free screening: https://offer.gernar.ru/?utm_source=g... 🐳 GUIDE to finding a job in IT with a salary of 150k in 3-4 months: https://t.me/gernar228/788 🔥 Review of subscribers' resumes and analysis of other interviews in this post: https://t.me/gernar228/649 📕 Interview Question Database: https://gernar.ru/questions TIMESTAMPS: 00:00 - What will happen in the video? 00:30 - Tell us a little about your experience 02:45 - What SQL stack have you worked with? 03:02 - How is Clickhouse different from other SQL syntactic systems? 04:03 - What joins do you know? What's the main feature and difference between an inner join and a full join? 04:41 - What happens when you inner join these two tables? What's the result? 05:17 - What types of junk can be in a dataset? Can you list them? 06:00 - Explain the boxplot. 06:39 - Is there a "w" in this column or not? 07:45 - How can I successfully pass this interview? 08:52 - What is linear regression? 09:56 - We need to calculate the cumulative purchase amount for all users per month. 10:58 - How can I find the maximum, largest value in a column in SQL? 11:25 - It turns out the max function is broken. How else can I find the maximum value of a column? 11:51 - How do I sort in descending order? 12:27 - Can you describe how the path, break, and continue operators work? 13:36 - When does it arise, and what mitigation methods are there? 14:08 - A peeping problem is very common in both tests. What is it related to and when does it occur? Can you tell me? 15:09 - How is the user group segmented on ABT? 16:10 - Did you implement ABT entirely on your own? 16:33 - Can you suggest an LTV metric, if you know what they are? 17:05 - There are DAO and MAO metrics. Do you know what they are? 17:17 - Are you familiar with the concept of North Star metrics? 18:24 - Where can I find more useful materials and interviews?