Analysing a company's end-to-end operations - identify areas for improvement within the company. Investigating metric spikes - understanding and explaining sudden changes in key metrics, such as a dip in daily user engagement or a drop in sales.
The goal is to use your advanced SQL skills to analyze the data and provide valuable insights that can help improve the company's operations and understand sudden changes in key metrics.
Case Study 1: Job Data Analysis Tasks:
- Jobs Reviewed Over Time: Objective: Calculate the number of jobs reviewed per hour for each day in November 2020.
- Throughput Analysis: Objective: Calculate the 7-day rolling average of throughput (number of events per second). explain whether you prefer using the daily metric or the 7-day rolling average for throughput, and why.
- Language Share Analysis: Objective: Calculate the percentage share of each language in the last 30 days.
- Duplicate Rows Detection: Objective: Identify duplicate rows in the data.
Case Study 2: Investigating Metric Spike Tasks:
- Weekly User Engagement: Objective: Measure the activeness of users on a weekly basis.
- User Growth Analysis: Objective: Analyze the growth of users over time for a product.
- Weekly Retention Analysis: Objective: Analyze the retention of users on a weekly basis after signing up for a product.
- Weekly Engagement Per Device: Objective: Measure the activeness of users on a weekly basis per device.
- Email Engagement Analysis: Objective: Analyze how users are engaging with the email service.