Sobes.tech

Data Analyst

What are other ways to solve the problem of finding employees older than the manager? (alternative approaches)

337

SQL: write a query to count the number of subscribers for each blogger (table with bloggers and subscribers).

221

SQL: list employees who are older than their manager (table employees with fields employee_id, department_id, is_chief, birthday).

177

Behavioral question: a manager recommended a model, but it shows poor results. What will you do?

172

Why did customer refunds jump by 50%? What operational risks are possible here?

167

Tell about the difficulties and mistakes in the project.

128

How did you handle seasonality and external influences in time series?

125

The monitoring model started flagging normal transactions as suspicious (false positives). What will you do?

123

Tell me about yourself: who are you, what do you do, and what are your hobbies?

122

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?

121

SQL: list all products with a price higher than the average price in their category (table products with fields product_id, category, price).

115

Behavioral question: how do you work with new, unfamiliar information (for example, a large array of articles)?

112

Tell us about your projects. Describe your course project — the Bitcoin price predictor.

73