support@w4writers.com +44 7743 307695
Jun 11, 2024

Assignment Task

Operation Analytics for Company Growth

Description

Operation Analytics involves analyzing the end-to-end operations of a company to identify areas for improvement. As a Data Analyst Lead at Microsoft, you collaborate with various teams to derive insights from collected data, enabling better automation, cross-functional understanding, and workflow efficiency.

Case Study 1

Table-1: job_data

  1. Number of jobs reviewed: Calculate the number of jobs reviewed per hour per day for November 2020.

  2. Throughput: Calculate the 7-day rolling average of throughput. Discuss your preference for daily metric or 7-day rolling and why.

  3. Percentage share of each language: Calculate the percentage share of each language in the last 30 days.

  4. Duplicate rows: Describe how you would display duplicate rows from the table.

Case Study 2

Table-1: users Table-2: events Table-3: email_events

  1. User Engagement: Calculate the weekly user engagement to measure the activeness of users.

  2. User Growth: Calculate the user growth for the product over time.

  3. Weekly Retention: Calculate the weekly retention of users from the sign-up cohort.

  4. Weekly Engagement: Calculate the weekly engagement per device to measure user activeness.

  5. Email Engagement: Calculate the email engagement metrics to measure user interaction with emails.

Recent Post

Order this Assignment now

Total: GBP120

fables template