Sobes.tech

Product Analyst

What quality metrics were used in the medical startup? Why those specific thresholds?

402

What are window functions in SQL and how do they differ from GROUP BY?

390

Why did you leave the sales manager position at [company]?

368

Tell me about your work experience and projects

364

Task 4 List all companies that have no transactions in the last 30 days. Use JOIN (without subquery in WHERE).

348

What is distribution and why is it needed for an analyst?

341

How did you address issues related to certification and processing of medical data (152-FZ) in a medical startup?

333

Where will the median and mean be located in a right-skewed distribution?

319

Why can't the average be used to calculate discounts in skewed LTV distribution?

245

What window functions have you used most often? How does RANK differ from DENSE_RANK?

217

What are anomalies and how to detect them statistically?

183

How did you evaluate a 15% improvement (from the resume about the monitoring dashboard)?

165

How does the t-test differ from the z-test?

142