Pratham Makhecha

Analyst

Aspiring Data Scientist | Python | Machine Learning | SQL

Handles the questions an analyst is asked day to day.

Bengaluru, IndiaPracticing since October 202618-day streak

LinkedInGitHub

Points

1,870

Questions solved

64

Projects finished

0

Longest streak

18 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 Pratham has worked through.

• Query foundations

  Learning · 19 of 69

  Reading a table and asking it a straight question.

  • Dates6/16
  • Conditional logic4/12
  • Strings1/11
  • Calculations0/10
  • NULL handling5/9
  • Filtering2/7
  • Logical operators1/4

• Combining data

  Learning · 17 of 36

  Putting tables together without losing or duplicating rows.

  • Joins7/15
  • Reshaping5/15
  • Subqueries4/5
  • Deduplication1/1

• Aggregation and windows

  Learning · 27 of 71

  Summarizing, ranking and comparing rows against their group.

  • Window functions8/32
  • Ranking9/15
  • Aggregations8/14
  • Running totals2/10

• Python foundations

  Learning · 1 of 21

  The data structures every Python interview leans on.

  • Arrays0/6
  • Lists1/5
  • Tuples0/3
  • Dictionaries0/3
  • Math0/3
  • Sorting0/1

• Algorithms

  Not started · 0 of 17

  The patterns behind the timed screening rounds.

  • Hashing0/8
  • Two pointers0/4
  • Binary search0/4
  • Sliding window0/1

Certificates

• Analyst

  Earned Oct 23, 2026

  Open certificate

• Junior Analyst

  Earned Oct 19, 2026

  Open certificate

Projects

No Data Labs projects posted yet.