Pika gaming

Analyst

Handles the questions an analyst is asked day to day.

Practicing since October 20261-day streak

Points

1,485

Questions solved

68

Projects finished

0

Longest streak

4 days

Badges

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

Skills

Skill map

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

• Query foundations

  Working on it · 41 of 69

  Reading a table and asking it a straight question.

  • Dates10/16
  • Conditional logic10/12
  • Strings0/11
  • Calculations5/10
  • NULL handling6/9
  • Filtering6/7
  • Logical operators4/4

• Combining data

  Learning · 15 of 36

  Putting tables together without losing or duplicating rows.

  • Joins10/15
  • Reshaping0/15
  • Subqueries5/5
  • Deduplication0/1

• Aggregation and windows

  Learning · 12 of 71

  Summarizing, ranking and comparing rows against their group.

  • Window functions4/32
  • Ranking0/15
  • Aggregations8/14
  • Running totals0/10

• Python foundations

  Not started · 0 of 21

  The data structures every Python interview leans on.

  • Arrays0/6
  • Lists0/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 22, 2026

  Open certificate

• Junior Analyst

  Earned Oct 11, 2026

  Open certificate

Projects

No Data Labs projects posted yet.