Mehul Gupta

Junior Analyst

Has solved a first real set of interview questions.

Practicing since October 202620-day streak

Points

1,195

Questions solved

52

Projects finished

0

Longest streak

20 days

Badges

• First question
• 10 questions
• 25 questions
• 50 questions
• 3-day streak
• 7-day streak

Skills

Skill map

Every topic in the question bank, and how much of each one Mehul has worked through.

• Query foundations

  Learning · 19 of 69

  Reading a table and asking it a straight question.

  • Dates5/16
  • Conditional logic1/12
  • Strings2/11
  • Calculations1/10
  • NULL handling5/9
  • Filtering5/7
  • Logical operators0/4

• Combining data

  Learning · 9 of 36

  Putting tables together without losing or duplicating rows.

  • Joins4/15
  • Reshaping1/15
  • Subqueries3/5
  • Deduplication1/1

• Aggregation and windows

  Learning · 11 of 71

  Summarizing, ranking and comparing rows against their group.

  • Window functions2/32
  • Ranking2/15
  • Aggregations6/14
  • Running totals1/10

• Python foundations

  Learning · 8 of 21

  The data structures every Python interview leans on.

  • Arrays3/6
  • Lists1/5
  • Tuples1/3
  • Dictionaries1/3
  • Math2/3
  • Sorting0/1

• Algorithms

  Learning · 5 of 17

  The patterns behind the timed screening rounds.

  • Hashing2/8
  • Two pointers0/4
  • Binary search2/4
  • Sliding window1/1

Certificates

• Junior Analyst

  Earned Oct 10, 2026

  Open certificate

Projects

No Data Labs projects posted yet.