Let's break them down: 1. Intuition
The query aims to retrieve information about managers in the Employees table, including their IDs, names, the number of employees reporting to them, and the average age of their reports.
Jun 8, 2023 • 12 tweets • 4 min read
A few days back, 2 Data Analyst newbies showed me mistakes they encountered during their analysis process. It dawned on me that lots of times, we don't diligently follow through the data analysis process, especially the cleaning phase.
In this short🧵, I break down this process.
PHASE 1: ASK QUESTIONS
The first step in the analysis process is to formulate a problem to solve or a question to answer, such as: are customers aged 21 to 30 more likely to churn than customers aged 41 to 50? As analysts, we must be very curious, we must ASK QUESTIONS!
Jun 8, 2023 • 9 tweets • 4 min read
#Day4 for Reporting "Crack SQL interview in 50Qs" is hear. Let's rumble
Let's break down each question 1. Logic: Show the classes, where the number of student is more than 5. The word "At least" tells us something, we have to include 5 as part of our filtering condition, hence >=5 2. This looks pretty straight forward. For each user, we want to....
Jun 6, 2023 • 10 tweets • 5 min read
#Day3 for Reporting "Crack SQL interview in 50Qs" is hear. Let's rumble
Let's break down each code 1. The ending part to the question is where the major conditional logic lies. We were told to return the needed columns, and price for the first year of every product sold. Since we do not have distinct column showing min years for each product,
