This project focuses on analyzing Instagram user data using SQL and MySQL Workbench to generate meaningful business insights. As a data analyst working with Instagram’s product team, the objective is to study user engagement, activity patterns, and platform behavior to support data-driven decision-making.
The analysis helps different teams — including marketing, product, and investors — understand user interactions, improve engagement strategies, detect fake accounts, and optimize platform growth.
Instagram generates massive amounts of user interaction data every day. The challenge is to analyze this data effectively to answer critical business questions such as:
- Who are the most loyal users?
- Which users are inactive?
- What content performs the best?
- Which hashtags are trending?
- Are there fake or bot accounts on the platform?
Using SQL queries and relational database analysis, this project aims to uncover insights that can improve user engagement, marketing strategies, and business performance.
- MySQL
- MySQL Workbench
- SQL Queries
- Aggregate Functions
- Joins
- Subqueries
- Group By & Having Clauses
- Data Filtering & Sorting
Identified the five oldest users on Instagram who have been using the platform for the longest time. These loyal users can be rewarded through special promotions or recognition programs.
Analyzed users who have never posted a photo on Instagram. These inactive users can be targeted through email campaigns and engagement strategies to encourage platform activity.
Determined the user whose photo received the highest number of likes, making them the winner of the Instagram contest.
Identified the top five most frequently used hashtags on the platform to help brands improve reach and engagement in marketing campaigns.
Analyzed user registration trends to determine the day of the week when most users join Instagram. This insight helps the marketing team schedule advertisements and campaigns more effectively.
Calculated:
- Average number of posts per user
- Ratio of total photos to total users
These metrics help investors understand whether users remain active and engaged on the platform.
Identified suspicious accounts that liked every photo on the platform — behavior commonly associated with bots or fake accounts.
This analysis helps maintain platform authenticity and improve user trust.
The project provides valuable insights into:
- User engagement behavior
- Platform activity trends
- Popular hashtags and content strategies
- Inactive and highly active users
- Detection of fake or automated accounts
- Best timing for marketing campaigns
This project demonstrates how SQL can be used to analyze social media data and solve real-world business problems. By extracting insights from Instagram user activity, businesses can improve engagement strategies, optimize marketing campaigns, and enhance user experience.
The analysis highlights the importance of data-driven decision-making in growing and managing large digital platforms like Instagram.