Open in app

Sign In

Write

Sign In

Nathan Rosidi
Nathan Rosidi

1.4K Followers

Home

About

Jan 21

Spotify Advanced SQL Interview Question on PARTITION BY Clause

A detailed solution walkthrough to a hard Spotify SQL interview question involving Joins, Aggregations, Case Statements, and Partition By Clause. In this article, we’ll walk you through one of the Advanced SQL interview questions. This question is a Hard level problem and will test your advanced SQL skills such as…

Data Science

9 min read

Spotify Advanced SQL Interview Question on PARTITION BY Clause
Spotify Advanced SQL Interview Question on PARTITION BY Clause
Data Science

9 min read


Dec 7, 2022

Facebook Python Interview Questions

This Facebook python interview question will test your ability to use joins, perform transformations and calculations, and address edge-case scenarios. We’re back with another Python interview question from Facebook / Meta. We will solve this question using our 3-step framework that can be used to solve any python interview questions. Facebook Python Interview Question

Data Science

11 min read

Facebook Python Interview Questions
Facebook Python Interview Questions
Data Science

11 min read


Published in Towards Data Science

·Oct 25, 2022

Facebook SQL Interview Question Walkthrough — Popular Posts

Our series of interview question walk-throughs marches on! Today we’ll be dealing with the advanced Meta/Facebook SQL interview question. — Meta/Facebook is all about data, and this data is created by you. What you like, comment and post as a user is collected and analyzed on a regular basis. This analysis is represented in the interview question we’ll show you today. To make the explanations even easier, we made a…

Data Science

8 min read

Facebook SQL Interview Question Walkthrough — Popular Posts
Facebook SQL Interview Question Walkthrough — Popular Posts
Data Science

8 min read


Published in Towards Data Science

·Oct 13, 2022

Questions to Help You Practice for Your Data Science Interview

An overview of the types of questions in a Data Science interview along with the hands on practice using our platform — In 2012, Harvard Business Review called Data Scientist the sexiest job of the 21st century and the growing trend in the number of job openings for Data Scientist seems to be confirming that statement. With the increase in data, most of the companies today are leveraging Data Science heavily to…

Data Science

26 min read

Questions to Help You Practice for Your Data Science Interview
Questions to Help You Practice for Your Data Science Interview
Data Science

26 min read


Published in Towards Data Science

·Sep 29, 2022

DoorDash SQL Interview Questions

A detailed walkthrough of one of the interesting DoorDash SQL interview questions and solution — The DoorDash SQL interview question we selected for you today is interesting because it requires you to know a variety of SQL concepts. It tests your ability to deal with different types of data by using the functions such as TO_CHAR() and EXTRACT(). …

Data Science

9 min read

DoorDash SQL Interview Questions
DoorDash SQL Interview Questions
Data Science

9 min read


Published in Towards Data Science

·Sep 29, 2022

Amazon Business Analyst Interview Questions

Sharpen your skills of writing SQL queries to maximize your chances of getting a Business Analyst job at Amazon — Amazon moves more than a million packages every day. Even small improvements in the efficiency of logistical and business operations can save millions of dollars down the line. Business Analysts can analyze hard data, gain insights and communicate their findings to decision makers at the company.

Data Science

15 min read

Amazon Business Analyst Interview Questions
Amazon Business Analyst Interview Questions
Data Science

15 min read


Published in Towards Data Science

·Sep 9, 2022

SQL Window Functions Interview Questions

Here’s an article to help you answer the SQL interview questions that require knowledge of the SQL window functions — If you want to work in data science — and you wouldn’t be reading this if you didn’t — you have to be proficient in at least two areas: SQL and job interviews. Yes, both are skills that require practice. When we say SQL, this is an area so broad…

Data Science

16 min read

SQL Window Functions Interview Questions
SQL Window Functions Interview Questions
Data Science

16 min read


Published in Towards Data Science

·Sep 7, 2022

SQL Aggregate Functions Interview Questions

Let’s take a deeper dive into the must-know SQL aggregate concepts for your next Data Science Interview. — Today, we have millions and billions of rows of data being generated each second. However, we usually need a single metric to flag changes and make business decisions. For example — the total sales in the last quarter, the average churn rate, the number of ad impressions served, etc. Aggregation…

Data Science

16 min read

SQL Aggregate Functions Interview Questions
SQL Aggregate Functions Interview Questions
Data Science

16 min read


Published in Towards Data Science

·Aug 16, 2022

Python Data Engineer Interview Questions

A comprehensive guide on Python concepts and questions from top companies for all the budding Data Engineers to help them in preparing for their next interview. — Today we are going to cover interview questions in Python for a Data Engineering interview. This article will cover concepts and skills needed in Python to crack a Data Engineering interview. As a Data Engineer, you need to be really good in SQL as well as Python. …

Data Engineering

14 min read

Python Data Engineer Interview Questions
Python Data Engineer Interview Questions
Data Engineering

14 min read


Jul 4, 2022

Find the Retention Rates — Salesforce SQL Interview Question

Retention rates are one of the key business metrics. We’ll show you how to calculate them by explaining in detail how to solve the Salesforce data science interview question. The retention rate is one of the important business metrics, especially in marketing, investing, and product management. It refers to the…

Data Science

7 min read

Find the Retention Rates — Salesforce SQL Interview Question
Find the Retention Rates — Salesforce SQL Interview Question
Data Science

7 min read

Nathan Rosidi

Nathan Rosidi

1.4K Followers

i like creating content and building tools for data scientists. www.stratascratch.com

Following
  • Zulie Rane

    Zulie Rane

  • brett fox

    brett fox

  • Ayodeji Awosika

    Ayodeji Awosika

  • Marvin Liao

    Marvin Liao

  • Barry Davret

    Barry Davret

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech