Product Analyst

**SQL tasks** 1) Highlight the number of orders with status "processing" for each executor for March 2024 ONLY for high priority orders (priority = 'high').

Intern

Avito

**SQL tasks** 1) Display the number of orders with status "processing" for each executor in March 2024, ONLY for high-priority orders (priority = 'high'). Sort by descending order count. Exclude executors with 0 orders. 2) Show the number of successfully completed orders by categories, where the average revenue is > 70000, considering only customer orders with ID >= 1002. Exclude categories with unknown average revenue. 3) Add a column 'rank' to the orders_log table, ranking records for each executor by timestamp in ascending order, but only for orders with status "pending" or "processing". Example result (executor=1):

Intern

Avito

20. Valid Parentheses Given a string s containing just the characters '(', ')', '{', '}', '[' and ']', determine if the input string is valid. An input string is valid if: 1. Open brackets must be closed by the same type of brackets. 2. Open brackets must be closed in the correct order. 3. Every close bracket has a corresponding open bracket of the same type. Example 1: Input: s = "()" Output: true Example 2: Input: s = "()[]{}" Output: true Example 3: Input: s = "(]" Output: false

Intern

Avito

**Python tasks** A Pandas DataFrame with data from orders_log is called df. 1) Filter the rows: status "processing" AND revenue > 50000 AND priority "high". Display the result. 2) Create a column 'revenue_group' according to the rules: ‘Small’ (< 50000), ‘Medium’ (50000 <= revenue < 90000), ‘Large’ (>= 90000). Then count the number of orders in each group by categories (Category) and display the result. 1) df[(df["state"] == "processing") & (df["revenue"] > 50000) & (df["priority"] == "high")] 2)

Intern

Avito

**SQL tasks** 1) Count the number of orders with status "processing" for each executor in March 2024 ONLY for high-priority orders. 2) Find the average revenue for each product category. 3) Determine how many unique clients made orders in the "Electronics" category. 4) List orders that were rejected or canceled, if any. 5) Find the executor who processed the most orders with status "completed".

Intern

Avito

Tell me more about the team project: who participated in the team, what was your area of responsibility, and how was communication organized within the team?

Intern

Avito

What are your expectations from the internship? Do you see yourself as an experienced specialist in product analytics in the future?

Intern

Avito

How do you feel about machine learning and Data Science? Are you interested in this field?

Intern

Avito

Tell us about yourself and your experience. What are you currently doing?

Intern

Avito

What tasks in analytics do you like the most, and which ones do you like less? What area of analytics attracts you? Are you interested in A/B testing and hypothesis testing?

Intern

Avito