What quality metrics were used in the medical startup? Why those specific thresholds?
Product Analyst
What are window functions in SQL and how do they differ from GROUP BY?
Why did you leave the sales manager position at [company]?
Tell me about your work experience and projects
Task 4 List all companies that have no transactions in the last 30 days. Use JOIN (without subquery in WHERE).
What is distribution and why is it needed for an analyst?
How did you address issues related to certification and processing of medical data (152-FZ) in a medical startup?
Where will the median and mean be located in a right-skewed distribution?
Why can't the average be used to calculate discounts in skewed LTV distribution?
What window functions have you used most often? How does RANK differ from DENSE_RANK?
What are anomalies and how to detect them statistically?
How did you evaluate a 15% improvement (from the resume about the monitoring dashboard)?
How does the t-test differ from the z-test?