Skip to content

This MySQL-Tableau project is a cloned mimic version of Instagram's Database. I performed data analysis and answer real-world business-related questions.

Notifications You must be signed in to change notification settings

PriyankaJhaTheAnalyst/SQL_Tableau_InstagramClone

Repository files navigation

Project Overview

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.


Data and Exploration

- Dataset

The database ig_clone is created using SQL.
There are 7 tables: Users, Photos, Likes, Comments, Follows, Tags, Photo Tags.

- Exploration Questions

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

Data Visualization

See the Interactive Dashboard live on my Tableau Public profile.

Instagram Clone Data Analysis Dashboard

About

This MySQL-Tableau project is a cloned mimic version of Instagram's Database. I performed data analysis and answer real-world business-related questions.

Topics

Resources

Stars

Watchers

Forks