operation analystics.pdf
The "Operation Analytics and Investigating Metric Spike" project involves analyzing a company's end-to-end operations to identify areas for improvement. As a Lead Data Analyst at a company like Microsoft, you will be provided with datasets and tables related to job data and user interactions. Your goal is to use advanced SQL skills to derive insights and answer questions from different departments. This includes calculating jobs reviewed per hour, throughput analysis, language share analysis, detecting duplicate rows, measuring user engagement, user growth, retention analysis, engagement per device, and email engagement metrics.
07 Jun 2023
Keywords
SQL
MySQL
