What are other ways to solve the problem of finding employees older than the manager? (alternative approaches)
Data Analyst
SQL: write a query to count the number of subscribers for each blogger (table with bloggers and subscribers).
SQL: list employees who are older than their manager (table employees with fields employee_id, department_id, is_chief, birthday).
Behavioral question: a manager recommended a model, but it shows poor results. What will you do?
Why did customer refunds jump by 50%? What operational risks are possible here?
---SEPARATOR---
Tell about the difficulties and mistakes in the project.
How did you handle seasonality and external influences in time series?
The monitoring model started flagging normal transactions as suspicious (false positives). What will you do?
Tell me about yourself: who are you, what do you do, and what are your hobbies?
Business case: a new project with new transactions has started. How would you set up monitoring for suspicious transactions if you know nothing about this project?
SQL: list all products with a price higher than the average price in their category (table products with fields product_id, category, price).
Behavioral question: how do you work with new, unfamiliar information (for example, a large array of articles)?
Tell us about your projects. Describe your course project — the Bitcoin price predictor.