Simple Data Exploration project using SQL Queries to get insights from the data.
User analysis is done on the users data that is provide in the database. The insights generated from this analysis can be used by business to improve user experience.
- From data who are the top 5 people that are using Instagram from long time?
- From Data who are the users that never posted a single photo?
- Who is the user with most liked photo?
- What are the top 5 hashtags used?
- Which day of the week would be the best to launch a Ad campaign?
- From data provide , On an Average, how many posts, users posted on Instagram?
- fake or bot accounts?
Marketing team want to know who are the people that are using instagram from a long time, to reward them.
We need the data of people who never post anything on intagram to send promotional mails to post their 1st photo.
There are 26 people who never posted anything.For this 26 poeple marketing team can send promotional mails to upload their first post.
Team has conducted a contest to prize the person with most liked photo
'Zack_Kemmer93' photo is the most liked on.
Team needs to know what are the top 5 hashtags used.
Find the days in which most users created their account. This answers which day to launch the campaign
Team want to know how active the users are on the instagram
On average 3 to 4 photos posted/user
