📊 Social Media Analysis

📕 Table of Contents

• Problem Statement
• Objective
• Tools Used
• Dataset Overview
• Key Findings
• Recommendations
• Project Presentation
• Project Learnings
• Installation and Usage

❓ Problem Statement

While the social media platform shows active user engagement and clear trends in content preferences, there are opportunities to optimize hashtag usage, leverage influential users, and enhance regional content strategies. The platform faces challenges in balancing the influence of top users, capitalizing on trending topics, and ensuring consistent engagement across different content types and geographical regions. Additionally, there's a need to understand and replicate the success factors of highly bookmarked posts and active commenters to boost overall user interaction and content visibility.

🎯 Objective

The primary objective is to enhance user engagement, expand the platform's reach, and optimize content strategy across the social media platform. This involves leveraging popular hashtags, nurturing influential users, encouraging active participation, and understanding regional content preferences. The goal is to increase overall user activity, improve content visibility and interaction rates, and create a more balanced and dynamic user ecosystem that fosters growth and engagement across all user segments and geographical areas.

🛠️ Tools Used

• Analytical: MySQL
  
• Presentation: Microsoft Power Point
  

📅 Dataset Overview

• Data source: Internet
• Dataset Link
• Data model

🔎 Key Findings

1. #beautiful is the most used hashtag, closely followed by #festival and #socialmedia
2. Arthur & Logan are the most followed users, with Omicron just 1 follower behind
3. Brodie is the most active user and is 6 followers short of being the top followed user
4. Most posts originate from Maharashtra
5. Top 5 posts are bookmarked 5 times each
6. Jacob made the most comments
7. Sanjay, Calum, and Charlie have the highest post-to-like ratio with 21 likes per post (but only one post each)
8. Sahib Singh uses the most diverse hashtags
9. #festivesale is the most followed hashtag

💡 Recommendations

1. Leverage popular hashtags (#beautiful, #festival, #socialmedia) for increased visibility
2. Engage top influencers (Arthur, Logan, Omicron) as brand ambassadors
3. Highlight and incentivize active users like Brodie
4. Develop targeted content strategies for high-activity regions, especially Maharashtra
5. Analyze and replicate success factors of highly bookmarked posts
6. Encourage active commenting through user spotlights
7. Study high-engagement posts to understand and replicate success
8. Promote diverse hashtag usage for broader reach
9. Create campaigns around top followed hashtags like #festivesale
10. Balance top influencer promotion with nurturing emerging active users

📌 Project Presentation

Video Presentation

Slides

The detailed presentation slides for this project can be found here

🧠 Project Learnings

1. Creating new schema and table.
2. Group by.
3. Join tables.
4. Common Table Expressions (CTE).
5. Window function.
6. Data storytelling.
7. Sharpened analytical and problem-solving abilities.
8. Strengthened strategic planning and presentation skill.
9. Enhanced communication skills.
10. Actionable Insights Generation.

💻 Installation and Usage

• Open MySQL Workbench
• Create new schema
• Create new table
• Import CSV into the table
• If import doesn't work try removing table headers and import again