1. Define Customer Cohorts. Group the customers in the dataset into cohorts/segments based on their first-order characteristics and the month of their first order. These cohorts should be actionable, helping lead to business insights. Make hypotheses about how churn rates will differ across cohorts, which you can reflect on after performing your analysis. 2. What are the customer retention/churn rates over time for the customer groups that you defined in Part 1? Is there a significant difference in retention/churn based on different promotion values? What insights do you find from this analysis? 3. What are the dollar value retention rates over time for each customer group? What insights can you derive from your answers to Parts 2 and 3? 4. Are there any caveats to this analysis using only the provided data? What other data would be ideal to have? Please provide comments and visualizations so we can follow along with your thinking. While you won’t be penalized for approaching the analysis in multiple ways, it’s entirely sufficient to spend a few hours on just a single, well-justified approach — a few hours won’t be enough time to create a *perfect* analysis, but it should be enough to get most of the way there. Time constraints are common, and our grading rubric accounts for this.
Senior Analytics Interview Questions
890 senior analytics interview questions shared by candidates
Can you share a time that you worked with a difficult client and how you dealt with the situation? If you have not previously consulted, substitute "client" with a member of another team.
Tell me about a leadership experience.
Fluffy behavioral questions
Could you please explain you DBT experience?
Write a query that selects all of the products with a total order count greater than 5.
How many years of SQL experience did you have?
What is your availability like for the next two weeks
Name a brand that you think has lost its relevance, and needs to be revitalized-no auto or financial brands. and no 'The Gap'.
1. leadership skills 2. managing stakeholders 3. transferring technical words to non-technical stakeholders 4. data sources management
Viewing 631 - 640 interview questions