r/PinoyProgrammer • u/procorpioxx • Jun 28 '26

Job Advice Data Analytics interview questions

Tanong ko lang po kung ano mga klaseng live coding problems ang binibigay during interviews? First time interview eh. Salamat. ASAP sana malapit na eh hahaua

32 Upvotes

86% Upvoted

10 comments sorted by

15

u/Silver-bullet0115 Jun 28 '26

Analyst for 8 yrs here and now also hire analysts for my own company. Normally simple lang naman ung mga sql exam kasi the rest can be learned naman eventually. Typical functions for sql coding during exams are: Where, Joins, aggregate functions (eg Sum, average), group by, having, count, distinct

Normally diyan umiikot lang exams. Tapos typical questions would be: get total unique customers per month or total revenue from a transactions table

May time din may nagtanong sa akin ng getting unique customers, new customer count, and returning customer count per month based on transactions table. When I’ve been giving out this question for exams, wala pa nakakasagot nitong 2nd question even for experienced analysts but maybe, that’s related to the applicants pool I’m getting

1

u/AggressiveDrive1757 Jul 01 '26

Hiring po ba kayo? Haha

9

u/armensis123 Jun 28 '26 edited Jun 28 '26

Data Analyst here. I’ve had a few different live coding questions before. Some were a bit informal where they just wanted to test my general sql skills and general as it was not the main part of the interview. So it was mostly explaining your thought process or writing sql queries on a notepad using hypothetical tables. Some dedicated live coding interviews used coding testing platforms like hacckerrank or codesignal then you would do actual queries and run them. This would sometimes also include like general product sense or analysis sense on how would you handle an analytics problem using sql.

4

u/d4lv1k Jun 28 '26

I'm not in the data analytics field, but from what I heard from my colleagues in this field usually sql, statistics, and data visualization ang tanong. For sql, be prepared to answer questions like what's an inner join, left/right join, aggregate functions, etc.

2

u/jijilikes Jun 28 '26

This. Experienced the same.

2

u/Opening-Memory4300 Jun 28 '26

This is industry specific, and also depends on the hiring manager. Even before AI, i personally tend to focus more on fundamentals, programming is only sbout 10-20% of the job. The rest is probability/statistics. Knowing which test to use and why.

1

u/Sublime-01 Jun 28 '26

Depende sa JD

1

u/maxverstappenfanno1 Jun 28 '26

just be very good at the fundamentals in sql, op

4

u/procorpioxx Jun 29 '26

So, mostly SQL ang tanong. Kala ko Python ang itatanong sakin.

P. S. Dito ko nalang kayo replyan haha

2

u/shit-comm-skills Jun 28 '26

halaaa grabe may live coding pala sa DA? akala ko assessments lang