“What’s your favorite color?” Likeee 🤔 “Tell me about a time a teammate made you angry.” “If you could be any animal, what would you choose?” Pls lmfao 💀
Product Analyst Interview Questions
4,419 product analyst interview questions shared by candidates
Why are you not interested in other career opportunities or grad school?
Do you have experience in handling tickets?
Etude de cas sur le poste de Product Owner.
One about measurements, one about determining possible answers
Take home: Given 5 days to complete analytics challenge, pretty standard nothing too crazy Virtual on-site: 1 hr data analysis challenge and 45 mins to explain takeaways with interviewer, 30 min behavioral with standard behavioral questions, 45 min case question similar to MBB with focus on some standard math calcs, 45 min sql test using online editor similar to hackerrank/leet code problems
What price should Thumbtack charge professionals for quotes?
Table 1: Analysis.dimProducts Column DataType ProductID INT(PK) Identity Name Varchar(100) Cost money Table 2: Analysis.dimCustomers Column DataType CustomerID Int (PK) IDENTITY FirstName Varchar(100) LastName Varchar(100) Table 3: Analysis.dimSales Column DataType SalesID INT (PK) IDENTITY ProductID INT (FK) CustomerID INT (FK) Quantity INT Questions 1. Write a query that would return the cost associated with a product of the name of “Shampoo” 2. Write a query that would return the first and last name (with one column as the return set instead of two) of all customers 3. Write a query that would return all sales associated with a customer with the first name of “Bob” and the last name of “Smith” 4. Write a query that would return the total number of products purchased by a customer with the first name of “Bob” and the last name of “Smith”. 5. Alter the query in question #4 to return the total number of products purchased by a customer with the first name of “Bob” and the last name of “Smith”, but still returning a value of zero if that name had no sales 6. Write a query that would return the amount of money made in revenue total based on the sales made of products. The result should be just one column. 7. Insert a new customer with the name of “Phil” and the last name of “Frank” 8. Delete a product with the name of “Shampoo” (make sure to incorporate all tables that would need to be validated before you do this delete) 9. Using joins, update the amount of the product “Shampoo” ordered by a customer with the name “Bob Smith” to 5 (assume there’s only one SaleID that represents this customer)
How do you create a product roadmap?
The picky interviewer kept asking "what is your added value?" After getting a not so perfect answer, he kept picking on me for half and hour and totally unrecognized my precious achievements . They just don't know how to let people go.
Viewing 601 - 610 interview questions