Social Media Usage Dashboard (2022 Stats)
Project Overview
The Social Platform Statistics dashboard presents a comparative analysis of various platforms, examining their popularity, average time spent, and gender distribution. Additionally, the predictive model showcases the evolving popularity of these platforms over time. The Country Map dashboard provides insights into user demographics at a national level, highlighting the distribution of social media users across different countries in 2023 and 2027. This visualization also illustrates the regions that exhibit the highest and lowest levels of social media usage. Furthermore, the dashboard presents the average daily time spent on these platforms categorized by age groups.
- Trebuchet MS
- Century Gothic
#8FAADC
#DAE3F3
#2F5597
#F2F2F2
Excel Macro-Enabled Workbook (.xlsm)
952 KB
What's Included
- Dataset
- Pivot Tables
- 2 Dashboards (Top Social Platform Stats Dashboard, Country Dashboard)
Top Social Platform Stats Dashboard
- Average time spent on social media by users in a monthly and daily format presented through a rectangular shape with the top corner snipped design, featuring shadow transparency of 50%, reflection transparency of 70%, and soft edges of 5pt.
- Visual comparison of the percentage of male and female users on each platform, structured in a PowerPoint presentation.
- Average daily time spent per age group displayed using a pivot slicer and a timer icon.
- Combination static chart showcasing the number of platform users in columns and visits per month in a line chart. The dropdown list provides the actual numbers for each platform.
- Forecast sheet projecting the estimated total number of users by the year 2027.
Country Dashboard
- A world map presentation with countries that have the most social media users in 2023 and its increase by 2027.
- A drop-down list with the increased % for every country.
- Pivot tables & Formulas
- Drop-down List
- Interactive Navigation Buttons
- Slide-out Feature (Project Description)
- VBA macros
