4 days agoHiring in FAANG Companies and Knowing When You’re ReadyHere, 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…Faang19 min readFaang19 min read
5 days agoAmazon SQL Interview Question Walkthrough: Caller HistoryA 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 Science8 min readData Science8 min read
Mar 174 Data Collection Libraries in Python That You Should KnowWhen 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…Python14 min readPython14 min read
Mar 16Whole Foods Market Data Science Interview Question WalkthroughWelcome 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…Python10 min readPython10 min read
Mar 14Airbnb Python Interview Questions: Data Aggregation and LabelingWe’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…Python8 min readPython8 min read
Mar 14Wine Magazine SQL Interview Question on RANK functionAn 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 Science8 min readData Science8 min read
Mar 9How ChatGPT Can Help You Become a Better Data ScientistWe 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…Chatgpt18 min readChatgpt18 min read
Mar 2How to Use String Manipulation in SQLA 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…Sql7 min readSql7 min read
Feb 1Forbes Python Interview Question WalkthroughForbes 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…Python7 min readPython7 min read
Jan 21Spotify Advanced SQL Interview Question on PARTITION BY ClauseA 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 Science9 min readData Science9 min read
