2 of 22

Project Description:

The project is all about understanding the behaviour of Instagram users and to get insights for marketing team and to know performance of Instagram for investors so that they can make decisions accordingly.
On SQL, the programming language post running the dataset. First of all, there requires a deep analysis of the data which is in the tabular form, what all tables are present and the connection between the tables.
Then lookout answers for all questions, that were being asked by running the query and know the reasons behind by visualising the desired outcome.

3 of 22

Introduction:

User analysis is an attempt to get to know more about users expectations towards the product or service, it basically give the answers to the questions like what attracts the users most, reasons what they like and why, etc by looking at the patterns.
Analytics help the company by analysing data in depth, getting insights from it and visualising the desired outcome and then presenting the key insights to the stakeholders and that will guide them to take further decisions. This increases the efficiency and performance of the product.

4 of 22

Key questions:

Marketing: The marketing team wants to launch some campaigns, and they need the help with the following:
1. Find the 5 oldest users of the Instagram from the database provided?
2. Find the users who have never posted a single photo on Instagram?

5 of 22

3.The team started a contest and the user who gets the most likes on a single photo will win the contest so Identify the winner of the contest and provide their details to the team?

4.Identify and suggest the top 5 most commonly used hashtags on the platform?

5.What day of the week do most users register on Instagram?

6 of 22

B. Investor Metrics: Our investors want to know if Instagram is performing well and is not becoming redundant like Facebook, they want to assess the app on the following grounds

1. User Engagement: Provide how many times does average user posts on Instagram? Providing the total number of photos on Instagram/total number of users.

2. Bots & Fake Accounts: The investors want to know if the platform is crowded with fake and dummy accounts so provide data on users (bots) who have liked every single photo on the site?

7 of 22

Approach:

My approach towards the project is that firstly I have read what is the objective of the project and what is provided in the form of dataset and what is asked to find.
After installation of software and run the dataset, I have thoroughly understand the tables and their connections.
To make it precise and up to the point, I have executed the query to get the desired information and added some visuals to make it more clear and at last I have concluded it by adding the result and recommendation.

8 of 22

Tech-Stack Used:

MySQL Workbench 8.0

Version 8.0.31

MySQL is a open-source and free, programming language which uses Structured Query Language (SQL) that allow to create, manipulate, and share share data from Relational Database Management System (RDBMS).
It allows to extract the desired information from the massive dataset.

9 of 22

Findings & Insights

10 of 22

A1. Find the 5 oldest users of the Instagram from the database provided?�

People who have been using the platform for the longest time should get Reward for most loyal users.

11 of 22

A2. Find the users who have never posted a single photo on Instagram?�

Inactive users could be reminded by sending promotional emails or while using their instagram, they can get reminder to post the first photo.
There were 26 users who have never posted a single photo on the Instagram.

12 of 22

A3. The team started a contest and the user who gets the most likes on a single photo will win the contest so identify the winner of the contest and provide their details to the team?�

The winner of the contest is a user named Zack_Kemmer93.

13 of 22

A4. Identify and suggest the top 5 most commonly used hashtags on the platform?�

14 of 22

A5. What day of the week do most users register on Instagram?�

15 of 22

B1. User Engagement: Provide how many times does average user posts on Instagram?

The total number of photos on Instagram / total number of users ie, average user per post is 2.57. This shows about the users still active and posting on Instagram or not.

16 of 22

B2. Bots & Fake Accounts: The investors want to know if the platform is crowded with fake and dummy accounts so providing data on users (bots) who have liked every single photo on the site?�

There were almost 13 accounts of the users present on Instagram, who have liked every single post on the site.

17 of 22

Result:

The 5 oldest users of the Instagram are:

Darby_Herzog, Emilio_Bernier52, Elenor88, Nicole71, Jordyn.Jacobson2 and they should be rewarded for their loyalty.

Winner of the contest who gets the most likes on a single photo:

Username Zack_Kemmer93 won the contest with most likes (48) on a single photo.

Top most commonly used hashtags:

Smile, beach, party, fun.

18 of 22

Result:

Day of the week do most users register:

Thursday & Sunday

Average user posts on Instagram:

There is 2.57 post per user

Bots & Fake Accounts:

There were 13 fake accounts who had liked every single photo.

The users who have never posted a single photo:

There were 26 users who have never posted, out of which 13 users account were found fake (bots) accounts.

19 of 22

Action and Recommendations

20 of 22

Recommended actions:

Thursday and Sunday are the days of the week, when mostly users register on Instagram, so marketing and advertising campaigns should therefore target these particular days of the week.
There were 26 users who have never posted a single photo on Instagram, out of which 13 users account were found fake (bots) accounts, who had liked every single photo.
Partner brands can reach out most of the users on Instagram through those commonly used hashtags (Smile, beach, party, fun).

1 of 22