The aim of the project is to analyse Instagram – a popular free social media platform which allows its users to share photos, videos and also interact with others’ content. The main objective here, is to analyse the interaction of user and their engagements to various contents posted in the platform. The insights gained from this project can actually be used by local business holders to other important business players in advancing the product design, user experience, marketing and advertising etc.

Tech Stack Used

1. MySQL Workbench - used for writing, execute and debug SQL queries. It’s database design allows us to create and edit ER diagrams to visually model database structures
2. SQL Server Management Studio - used to interact with the SQL server database.

Two types of Analysis are performed here - A) Marketing Analysis

1. Loyal User Reward: Identify the five oldest users on Instagram from the provided database. The marketing team wants to reward the most loyal users, i.e., those who have been using the platform for the longest time.
2. Inactive User Engagement:Identify users who have never posted a single photo on Instagram. The team wants to encourage inactive users to start posting by sending them promotional emails.
3. Contest Winner Declaration: The team has organized a contest where the user with the most likes on a single photo wins.Determine the winner of the contest and provide their details to the team.
4. Hashtag Research: A partner brand wants to know the most popular hashtags to use in their posts to reach the most people. Identify and suggest the top five most commonly used hashtags on the platform.
5. Ad Campaign Launch: The team wants to know the best day of the week to launch ads.Determine the day of the week when most users register on Instagram. Provide insights on when to schedule an ad campaign.

B) Investor Metrics

1. User Engagement: Investors want to know if users are still active and posting on Instagram or if they are making fewer posts.Calculate the average number of posts per user on Instagram. Also, provide the total number of photos on Instagram divided by the total number of users.
2. Bots & Fake Accounts: Investors want to know if the platform is crowded with fake and dummy accounts. Identify users (potential bots) who have liked every single photo on the site, as this is not typically possible for a normal user.