Skip to content

Sumankanta/Social-Media-Analysis

Repository files navigation

📱 Student Social Media Analysis Dashboard

An interactive visualization project using Power BI, Tableau, and Excel, designed to explore patterns in student social media behavior and its impact on mental health, academic performance, and daily habits across regions and genders.


📌 Overview

The Student Social Media Analysis Dashboard provides a multidimensional view of how students engage with social media. This project analyzes usage patterns, platform preferences, mental health scores, academic correlations, and demographic insights—enabling educators, researchers, and policymakers to understand social media’s influence on youth.


🛠️ Tech Stack

  • 📊 Power BI – For building an analytical dashboard with performance and regional segmentation.
  • 📉 Tableau – For visualizing trends in device usage, conflicts, and regional behavior.
  • 📗 Microsoft Excel – Used for pivot-based insights and gender/regional comparisons.
  • 💻 Jupyter Notebook – Machine Learning analysis of addiction and mental health (optional).
  • 📁 File Formats.pbix, .twb, .xlsx, .ipynb

📂 Data Source

Source: Aggregated student survey data
The dataset includes:

  • Age, Gender, Region
  • Daily Social Media Usage Hours
  • Most Used Platform
  • Mental Health & Addiction Scores
  • Academic Performance
  • Device Preferences
  • Purpose of Social Media Use
  • Conflict Levels Over Social Media

🌟 Features

• Business Problem

Rising student dependence on social media platforms raises concerns about academic performance, mental well-being, and digital habits. Institutions need clear insights to guide interventions.

• Goal of the Dashboards

To deliver interactive visuals that:

  • Track and compare addiction, study hours, and mental health.
  • Segment insights by gender, age, region, and academic tier.
  • Guide support strategies for balanced student digital engagement.

📊 Key Visuals

Power BI Dashboard

  • 📈 Addiction Score by Age – Peaks at age 18, then declines.
  • 🌎 Regional Addiction Heatmap – Identifies hotspot areas.
  • 🧠 Mental Health Score by Gender – Comparison via donut chart.
  • 📚 Study Time vs Performance – Better performance linked to more study hours.
  • 🔍 Most Used Platform – Instagram leads, followed by WhatsApp and Facebook.

Excel Dashboard

  • 📊 Usage vs Academic Performance – Highest usage among students with poor performance.
  • 🎯 Purpose of Use Pie Chart – Education, Socializing, Entertainment split.
  • 📍 Interactive Filters – Slice data by gender and region.
  • 🌐 Country Platform Popularity – Map view showing dominant platform by country.

Tableau Dashboard

  • 🌍 Region-wise Student Count – North has the highest concentration.
  • 📱 Device Usage Over Years – Mobile use rises significantly post-2023.
  • 🧑‍🎓 Age Distribution Histogram – Most users are between 20–21.
  • ⚠️ Conflicts Over Social Media – Males report more social conflicts.
  • 📊 Mental Health Trends – Compared by education level and sleep patterns.

💡 Insights & Business Impact

  • 📌 Digital Behavior Trends: Young students (18–21) are most at risk for addiction.
  • 📉 Academic Alert: High social media usage correlates with lower academic outcomes.
  • 🧠 Mental Health Awareness: Females show slightly higher addiction and mental health variance.
  • 🎯 Platform-Specific Interventions: Instagram dominates—targeted campaigns could be more effective here.
  • 💻 Device Strategy: Shift to mobile usage indicates a need for mobile-optimized interventions.

📁 Files

  • Social_Media_Analysis.pbix – Power BI dashboard file
  • Social_Media_Analysis.twb – Tableau workbook file
  • Social_Media_Analysis.xlsx – Excel-based dashboard and source data
  • student_analysis.ipynb – Jupyter Notebook with ML analysis
  • Screenshot_*.png – Visuals of each dashboard for quick reference

🖼️ Dashboard Preview

Power BI

Dashboard Preview

Excel

Dashboard Preview

Tableau

Dashboard Preview

About

The Student Social Media Analysis Dashboard provides a multidimensional view of how students engage with social media. This project analyzes usage patterns, platform preferences, mental health scores, academic correlations, and demographic insights—enabling educators, researchers, and policymakers to understand social media’s influence on youth.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors