portfolio cover_merged

DATA A NALYSIS POR TFOLIO

TABLE OF CONTENTS 01 Portfolio -Advitya singh 02 03 Brief portfolio of advitya singh covering his present qualification and skills. 04 PROJ-1 : Data Analytics Process complete proj-1 with the detailed anaytical process explained with an example PROJ-2 : Instagram User Analytics Analysis of the social media site user data. PROJ-3 : Operational Analytics Data analysis of the operatinal facet of a company as well as inveatigation 05 PROJ-4 : Hiring Process Analytics 06 07 Analysing essential data for effective hiring process in a businees. 08 PROJ-5 : IMDB Movie Analysis data analysis of famous IMDB site, analysing various movies related data. PROJ-6 : Bank Loan Case Study case study of bank to analyse the process of banking and extract important data for banking. PROJ-7 : Impact of Car Features A comprehensive analysis of the car features and the imapact on car prices. Cont...

09 PROJ-8 : ABC Call Volume Trend 10 A comprehensive analysis of a call centre volume data and consumer response. Conclusion Closing note to the entire Data Analysis journey. 11 APPENDIX Link to all 1-8 projects completed with TRAINITY





DATA ANALYT PROJE USE OF DATA ANALYTICS

TICS PROCESS ECT -1 S IN REAL LIFE SITUATION

REAL LIFE S • TO DESIGN AND DEVELOP A REAL TIME OBJ

SITUATION JECT IDENTIFICATION WEB APPLICATION

PLA • DECIDE ON THE PLATFORMS NEEDED FOR TH APPLICATION. THE SAME ARE DECIDED AS U • HARDWARE AND SOFTWARE • KNOWLEDGE OF JAVA, HTML AND CSS • KNOWLEDGE OF LIBRARIES AND MODELS.

AN HE DEVELOPING THE KIND OF WEB UNDER :-

PREP • THE PREPRATION FOR DEVELOPING THE WEB • FLOWCHART CONTAINING THE STEPS IN THE DE • PAGE DESIGN THROUGH JAVA, HTML AND CS • ADD FUNCATIONALITY BY JAVA SCRIPT. • UPDATION AS PER USER REQUIREMENT.

PARE B APPLICATION INCLUDES THE FOLLOWING:- ESIGING PROCESS. SS.

PROC • THE PROCESS IN DEVELOPING THE APPLICAT :- • Design java script models via ML5.JS. • Use java script libraries like P5.JS. • Add bootstrap properties for screen size comp • Run web app for functionality checks.

CESS TION INCLUDES DESIGNING THE FOLLOWING patibility.

ANA • analyse the programme functionality for an • run programme for detection of any syntax er • Check model updating to remove outdated m • Identify failure to detect the real time object e • Rectify all errors and check healthy programm

ALYSE ny errors and suitability of use:- rrors. models. errors.. me codes.

AC • Finally develop the REAL TIME OBJECT IDENT requirements.

CT TIFICATION web application as per the user

Thank

k You

Instagram User A Advitya Singh

Analytics

Agenda • Project Description • Approach • Tech-Stack Used • Insights • Result 3/12/2023 Instagram Us

ser Analytics 2

Project Descriptio A) Marketing: The marketing team wants to launch some campaigns, they need your help with the following ✓Rewarding Most Loyal Users: People who have been using the platform for the longest time. Your Task: Find the 5 oldest users of the Instagram from the database provided ✓Remind Inactive Users to Start Posting: By sending them promotional emails to their 1st photo. Your Task: Find the users who have never posted a single photo on Instagram ✓Declaring Contest Winner: The team started a contest and the user who gets the likes on a single photo will win the contest now they wish to declare the winner. Your Task: Identify the winner of the contest and provide their details to the team ✓Hashtag Researching: A partner brand wants to know, which hashtags to use in t post to reach the most people on the platform. Your Task: Identify and suggest the top 5 most commonly used hashtags on the pla ✓Launch AD Campaign: The team wants to know, which day would be the best day launch ADs. Your Task: What day of the week do most users register on? Provide inInsisgthatgsraomn wUhs schedule an ad campaign

on , and B) Investor Metrics: Our investors want to know if Instagram is performing well and is not becoming post redundant like Facebook, they want to assess the app e most on the following grounds the atform ✓ User Engagement: Are users still as active and post on y to Instagram or they are making fewer posts Your Task: Provide how many times does average user posts on Instagram. Also, provide the total number of photos on Instagram/total number of users ✓ Bots & Fake Accounts: The investors want to know if the platform is crowded with fake and dummy accounts Your Task: Provide data on users (bots) who have liked every single photo on the site (since any normal user would not be able to do this). hseenr Atonalytics 3

Approach In this project first I tried to understand the given database. was easy to understand the database because they were connected to each other . Then started writing the code and it executed successfully .

. It nI

Marketing TOP 5 OLDEST USERS INACTIVE USERS 01 Darby_Herzog 02 Emilio_Bernier52 01 Aniya_Hackett 14 Julien_S 03 Elenor88 04 Nicole71 02 Kasandra_Homenick 15 Mike.Au 05 Jordyn.Jacobson2 03 Jaclyn81 16 Franco_ 04 Rocio33 17 Nia_Ha 05 Maxwell.Halvorson 18 Hulda.M 06 Tierra.Trantow 19 Leslie67 07 Pearl7 20 Janelle. CONTEST WINNER 08 Ollie_Ledner37 21 Darby_H USER LIKES Zack_Kemmer93 48 09 Mckenna17 22 Esther.Z 10 David.Osinski47 23 Bartholo 11 Morgan.Kassulke 24 Jessyca 12 Linnea59 25 Esmera 13 Duane60 26 Bethany 3/12/2023 Instagram User

g Insights 5 Schmidt uer39 _Keebler64 aag Macejkovic 7 .Nikolaus81 Herzog Zulauf61 ome.Bernhard a_West alda.Mraz57 y20 r Analytics

Investor ACTIVE USER USER ENGAGE TOTAL POSTS 74 AVG USER POST 257 3.5( BOTS DETE USER 13 3/12/2023 Instagram User

Metrics EMENT 3-4 POSTS) ECTED LIKES 257 r Analytics 6

Tech-Stack Use To create this project I used a online w Database: MySQL v5.7 . I used this on create this project because its easy to u understand errors and its online so no n and install it . 3/12/2023

ed website DB-Fiddle nline website to use faster to need to download 7

Insights Knowledge which I got from th • I understood where to use my da • I understood that how to write co • I understand that what type of qu • While doing the project I faced s points again and solved the erro 3/12/2023 Instagram Us

he project : ata analysis skills. odes according to the questions. uestions I will get in future. so many errors then I recollected the ors. ser Analytics 8

Results After completing this project I am ve This project helped me to recall each and helped me to think how can I do 3/12/2023 Instagram U

ery buoyant about my SQL aids. h and everything which I learned o better in analysis . User Analytics 9

Thank you Advitya Singh



IN

OPERATION ANALYTICS AND NVESTIGATING METRIC SPIKE ADVITYA SINGH

AGENDA • PROJECT DESCRIPTION • APPROACH • TECH-STACK USED • INSIGHTS • RESULT



PROJECT DESCRIPTION Operation Analytics is the analysis done for the complete en this, the company then finds the areas on which it must imp team, marketing team, etc and help them derive insights out Investigating metric spike is also an important part of opera to understand or make other teams understand questions lik sales taken a dip? Etc. Questions like these must be answere metric spike.

nd to end operations of a company. With the help of prove upon. You work closely with the ops team, support t of the data they collect. ation analytics as being a Data Analyst you must be able ke- Why is there a dip in daily engagement? Why have ed daily and for that its very important to investigate

APPROACH TASK 1 : Number of jobs reviewed: Amount of jobs reviewed ov Your task: Calculate the number of jobs reviewed per hour per d TASK 2 : Throughput: It is the no. of events happening per seco Your task: Let’s say the above metric is called throughput. Calcul do you prefer daily metric or 7-day rolling and why?

CASE STUDY -1 ver time. day for November 2020? ond. late 7 day rolling average of throughput? For throughput,

APPROACH TASK 3 : Percentage share of each language: Share of each lang Your task: Calculate the percentage share of each language in th TASK 4 : Duplicate rows: Rows that have the same value presen Your task: Let’s say you see some duplicate rows in the data. How