📈 Operation and Investigation Metric Analysis 📊

Operation analytics is the analysis performed for a company's whole end-to-end operations. This helps the business identify the areas where it needs to make improvements.

Being one of the most important parts of a company, this kind of analysis is further used to predict the overall growth or decline of a company’s fortune. It means better automation, better understanding between cross-functional teams, and more effective workflows.

Investigating metric spike is also an important part of operation analytics as being a Data Analyst one must be able to understand or make other teams understand questions like- Why is there a dip in daily engagement? Why have sales taken a dip? Etc. Questions like these must be answered daily and for that its very important to investigate metric spike.

📔 Project Details

Two Cases

• Case Study 1 -Analyze the Jo Search Data
• Case Study 2 - Analyze the metrics of Social Media Paltform and understand the Customer Retention.

Case Study 1 Users Data - Consisting the data of all the users along with the Jobs they have applied with the languages and time spent to review the job.

Case Study 2 Comprises of three tables:

• Users Data - Consisting the data of the users that created their ID's and also states their status whether active/pending.
• Events Data - Consisting the data of the actions taken by the users after their sign up along with the device they used.
• Email Metrics Data - Consisting the data of the actions taken by the Users on the email activities.

🎨 Database Design

This Database Design is for the Case Study 2

⚒️ Tool Used

❓ CASE STUDY 1 Requirements:

• Calculate the number of jobs reviewed per hour per day for November 2020?
• Calculate 7 day rolling average of throughput?
• Calculate the percentage share of each language in the last 30 days?
• Let’s say you see some duplicate rows in the data. How will you display duplicates from the table?

❓ CASE STUDY 2 Requirements:

• Calculate the weekly user engagement?
• Calculate the user growth for product?
• Calculate the weekly retention of users-sign up cohort?
• Calculate the weekly engagement per device?
• Calculate the email engagement metrics?

🎯 Insights

• On an average 0.0111 seconds of time was spent by the user on every job.
• Persian Language Jobs were visited the most in the November month 2020.
• We have total 9381 active users on the platform.
• Macbook Pro have been seen as the highest used device in a single week.
• We have a email clicking rate of 14.79% and email opening rate of 33.58%.
• Our Retention rate stands at around 25.78% which is a matter of concern and needs to be looked at.
• The table of the Job Data doesn’t have any duplicate rows.