This MySQL project is a cloned mimic version of Instagram's database. It is used to perform data analysis for real world business related questions and scenarios. MySQL is the language used to create the database and analyse it. And Tableau is used to visualize the dataset.
The database ig_clone is created using SQL.
There are 7 tables: Users, Photos, Likes, Comments, Follows, Tags, Photo Tags.
The following questions are explored in this case study:
- First 10 users on the platform
- Total number of registrations
- Total number of posts
- Number of Sign-ins per Day
- Inactive users
- Most likes on a photo
- Number of photo posted by most active users
- Most popular tag names by usage
- Most popular tag names by likes
- Users who have liked every single photo on the platform
- Percentage of users who have either never commented on a photo or likes every photo
- Total years on the platform
See the Interactive Dashboard live on my Tableau Public profile.
