There is also interest from the CEO about the work you are doing and a desire to understand the broader framing of the channel he of improving engagement/retention, thinking beyond the data provided. What other research, experiments, or approaches could help the company get to more clarity kn the problem?
Senior Product Analyst Interview Questions
487 senior product analyst interview questions shared by candidates
Can you help us identify which factors are associated with better engagement/retention? Can you propose and recommendations (business initiatives or product changes) that could address these opportunities?
Whilst there are projects you will be working on, there are still ad-hoc requests that come in and need dealing with, is this something you are comfortable with?
How to measure the accuracy of store visitors counters when you need to replace one with another
I don't remember the questions exactly but they gave me access to a test database with a few tables that could be joined together and a few simple SQL-based questions like "How many users used product X in the month of March?"
Pick the diagram that represents ice cream, vanilla ice cream and desserts. You were provided multiple options of sets to represent the relationship. This I answered incorrectly after thinking about it after.
One question on SQL was to find out the employees from a employee salary table who have received increment atleast twice in the past.
Tell me about a time when you failed and how did you handle it.
Was asked about previous work experiences, projects and tools used in them. Questions were majorly on database management systems and python with a few questions on financial terms. 1) Types of Normalization and the differences 2) Python libraries and their uses 3) Was asked to write a code for reading a file from pc(any language).
What was the most complex SQL query that you wrote?
Viewing 41 - 50 interview questions