🔥

If you want to practice before interview, visit datalemur.com/

Looking forward to the next lesson in this series.

This was super helpful! I always get MOLAP and ROLAP confused, but your explanation with the historical context and real-world examples made it finally click. Thanks Dmitry!

for the third task with multiple years and empty months - WITH t1 AS( SELECT YEAR(order_date) AS year ,MONTH(order_date) AS month ,customer_id ,COUNT(order_id) orders ,CASE WHEN MONTH(order_date) = 12 THEN 1 ELSE MONTH(order_date)+1 END as next_month ,CASE WHEN MONTH(order_date) = 12 THEN YEAR(order_date) + 1 ELSE YEAR(order_date) END as next_year FROM #orders GROUP BY YEAR(order_date), MONTH(order_date), customer_id), t2 AS( SELECT t1.year ,t1.month ,t1.customer_id ,t1.orders ,t1.next_month ,t1.next_year ,t2.month as t2next_mont ,t2.year as t2next_year ,t2.orders as next_orders FROM t1 as t1 LEFT JOIN t1 as t2 ON t2.year = t1.next_year AND t2.month = t1.next_month AND t2.customer_id = t1.customer_id) SELECT CONCAT(year, '-', month, '-', '01') ,COUNT(customer_id) ,COUNT(next_orders) FROM t2 GROUP BY CONCAT(year, '-', month, '-', '01')

If you get lost, use our playlists to navigate! www.youtube.com/@SurfalyticsTV/playlists

This gave me a lot of practical tips!

Repetition is the way to knowledge! Watch every episode!

Insightful 👍

Use the timecode to navigate the video: 00:00 - Intro 00:25 - Mistakes were made 04:22 - Conflicts with stakeholders 11:35 - Role play game 16:14 - Disagreement in a team 17:19 - Finalisation

Great start of 2025 with another useful module video!

Very helpful!

Great overview of the BI landscape!

Continue with Module 3 in the new year!

The first part of the project -> kzbin.info/www/bejne/jIaQmaaufbygpc0

Curious to hear more about iceberg!

Do not to look into description. There are all link we visited during the project.

This is gold! 🤩

Do not forget that you can join our community! surfalytics.com/ Or order our merch to spread the idea! shop.surfalytics.com/

Dmitry, don't get discouraged by the third task - those types of questions are designed to be challenging.

Dmitry, keep practicing and working with different functions, and you'll gain even more confidence.

Thanks a lot! Really valuable! Quick question - will be the same questions for junior/middle position in accordance with difficulty?

Didn´t understand the Functions vs Classes question. Aren't those 2 different things?

Thanks for sharing your knowledge!

Great overview of the BI market, Dmitry!

Thanks for the video! A lot of useful information regarding Databricks!

This was a super helpful interview!

Great tips to success in my next interview!

I especially appreciated the detailed explanation of the different data modeling techniques.

Liked discussion about query optimization and complex data types.

This workshop is a great practical guide to BigQuery!

Do you want to participate online? Join our Discord channel through surfalytics.com/

I stumbled upon this channel and as a professional, I find this to be the premier Data Engineering KZbin Channel

Wow, nice explanation of everything. So, for that intersection of the two lists problem, I would prefer to use list comprehension. def intersect(lst1, lst2): lst3 = [i for i in lst1 if i in lst2] return lst3

Thanks for sharing this valuable content!

I'm so impressed with Dimitri's depth of knowledge and experience in data engineering.

thanks

Get your 7-day free-trial with Surfalytics! surfalytics.com/

BI is a top of iceberg for analytics

This was really informative!

We starting module 3! Subscribe to not miss a lesson!

Thanks for sharing this helpful information about BI tools and Tableau Server administration.

great video, thank you for sharing! I learned so much from your example!

🔥🔥🔥

Great interview answers!

Thanks for watching! Join our community! surfalytics.com/

Thanks for sharing, this is super helpful!

😍

We are here to help you find your first or new job! surfalytics.com/