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
Number of jobs reviewed: Calculate the number of jobs reviewed per hour per day for November 2020.
Throughput: Calculate the 7-day rolling average of throughput. Discuss your preference for daily metric or 7-day rolling and why.
Percentage share of each language: Calculate the percentage share of each language in the last 30 days.
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
User Engagement: Calculate the weekly user engagement to measure the activeness of users.
User Growth: Calculate the user growth for the product over time.
Weekly Retention: Calculate the weekly retention of users from the sign-up cohort.
Weekly Engagement: Calculate the weekly engagement per device to measure user activeness.
Email Engagement: Calculate the email engagement metrics to measure user interaction with emails.
BEN02 Planning and Presenting a Micro-Enterprise Idea BTEC Level 1/2
Read MoreBTEC Unit 35: Engineering Services Delivery Plan for Sector-Specific Organizations | HND Level 5 Assignment 2
Read MoreTQUK Level 3 Administering Medication and Monitoring Effects in Adult Care Assignment
Read MoreUnit 10: 3D Modelling and Assembly Drawing for Vice – Engineering Design Portfolio BTEC Level 3
Read MoreWhy is it important that you correlate the appropriate information of the patient when they arrive for their appointment?
Read MoreNCFE Level 3 Roles and Responsibilities in Health And Social Care
Read MoreMP3395 Turbocharger Performance Evaluation and System Analysis CW2 Assessment, AY2024-25
Read MoreKey Research Policies and Funding Models at University of Strathclyde
Read MoreCIPD Level 5 Associate Diploma Key Assessment Questions
Read MoreLaw Assignment Questions Critical Legal Analysis & Solutions
Read More