Open in app

Sign In

Write

Sign In

Nathan Rosidi
Nathan Rosidi

1.4K Followers

Home

About

4 days ago

Hiring in FAANG Companies and Knowing When You’re Ready

Here, we’ll talk about the hiring process of FAANG companies. We’ll also throw in some guidelines on how to tell you’re ready for a FAANG interview. You’re a data professional, or you want to become one. That’s clear because you wouldn’t be here otherwise. You probably came across this acronym…

Faang

19 min read

Hiring in FAANG Companies and Knowing When You’re Ready
Hiring in FAANG Companies and Knowing When You’re Ready
Faang

19 min read


5 days ago

Amazon SQL Interview Question Walkthrough: Caller History

A detailed introduction to using FIRST_VALUE(), explained in a step-by-step solution to Amazon’s medium-level SQL interview question. As you prepare for data science interviews, you’ll notice that window functions come in handy when SQL interview questions require complicated calculations and manipulations. If you’re completely new to window functions, check out…

Data Science

8 min read

Amazon SQL Interview Question Walkthrough: Caller History
Amazon SQL Interview Question Walkthrough: Caller History
Data Science

8 min read


Mar 17

4 Data Collection Libraries in Python That You Should Know

When collecting data, there are four most important Python libraries you should know. We’ll show you their workings on real-life scraping data examples. Data collection is an essential step of a data science project, including taking data from different sources like websites, APIs, and databases. To collect data from these…

Python

14 min read

4 Data Collection Libraries in Python That You Should Know
4 Data Collection Libraries in Python That You Should Know
Python

14 min read


Mar 16

Whole Foods Market Data Science Interview Question Walkthrough

Welcome to another tutorial on solving data science interview questions. This time our interview question is from Whole Foods Market. Whole Foods Market is a chain of supermarkets that sells natural and organic foods, founded in 1980 in Austin, Texas. This is one of the hard level data science interview…

Python

10 min read

Whole Foods Market Data Science Interview Question Walkthrough
Whole Foods Market Data Science Interview Question Walkthrough
Python

10 min read


Mar 14

Airbnb Python Interview Questions: Data Aggregation and Labeling

We’ll walk you through one of the Airbnb Python interview questions and show you how to do data aggregation and labeling in Python. Airbnb is an abbreviation for Air Bed and Breakfast. You probably know that, and the chance is you also used it at least once. It’s a platform…

Python

8 min read

Airbnb Python Interview Questions: Data Aggregation and Labeling
Airbnb Python Interview Questions: Data Aggregation and Labeling
Python

8 min read


Mar 14

Wine Magazine SQL Interview Question on RANK function

An exhaustive walkthrough to a hard-level SQL question involving windows functions, PARTITION BY clauses, CASE statements, and Common Table Expressions. Are you a wine enthusiast? If you are, then you’ve probably heard of Wine Magazine. Let us solve one of the advanced SQL interview questions on RANK function. The question…

Data Science

8 min read

Wine Magazine SQL Interview Question on RANK function
Wine Magazine SQL Interview Question on RANK function
Data Science

8 min read


Mar 9

How ChatGPT Can Help You Become a Better Data Scientist

We wanted to know how valuable ChatGPT is in data science and how it works. Here’s what we found and how you can use it as a data scientist. In this article, I will explain how data scientists can benefit from ChatGPT. I’ll go through different examples of you can…

Chatgpt

18 min read

How ChatGPT Can Help You Become a Better Data Scientist
How ChatGPT Can Help You Become a Better Data Scientist
Chatgpt

18 min read


Mar 2

How to Use String Manipulation in SQL

A detailed walkthrough of the solution for a Google interview question to practice SQL String Manipulation — With the wealth of data being captured by companies, not all of them will be structured and numerical. So today, our focus is to hone your skill in manipulating strings in SQL by introducing several advanced functions. Practicing String Manipulation in SQL Let’s dive into an example question from an interview at Google to practice…

Sql

7 min read

How to Use String Manipulation in SQL
How to Use String Manipulation in SQL
Sql

7 min read


Feb 1

Forbes Python Interview Question Walkthrough

Forbes Python interview question, Most Profitable Companies, analyzed and solved in detail. Forbes is a business magazine best known for ranking billionaires. The list was first published in 1987, and the magazine was first published in 1917. In this article, we have one of the medium-level python interview questions. We…

Python

7 min read

Forbes Python Interview Question Walkthrough
Forbes Python Interview Question Walkthrough
Python

7 min read


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

Nathan Rosidi

Nathan Rosidi

1.4K Followers

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

Following
  • Ayodeji Awosika

    Ayodeji Awosika

  • Marvin Liao

    Marvin Liao

  • brett fox

    brett fox

  • Zulie Rane

    Zulie Rane

  • Navid Mashinchi

    Navid Mashinchi

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech