SOCIALBUZZ
Data Analysis & Visualisation
Data Analysis & Visualisation
Created using a dataset from the Accenture Data Analysis & Visualisation simulation. The dataset had multiple tables like User, Profile, Content, Reaction, Reaction Types, and more. I selected, cleaned and analysed the relevant data to meet the client's needs.
Tools: Power BI for data preparation, analysis, and visualisation.
Business Context & Problem Statement
🚀SocialBuzz, a fast-growing social media platform, needed to adapt its content strategy effectively to support rapid scaling and an upcoming IPO.
Tools: Power BI for data preparation, analysis, and visualisation.
Business Context & Problem Statement
🚀SocialBuzz, a fast-growing social media platform, needed to adapt its content strategy effectively to support rapid scaling and an upcoming IPO.
🌟With their rapid growth, SocialBuzz wanted to understand user engagement trends, identify the top content categories, and determine the effectiveness of content formats in boosting engagement.
Objectives
• Provide an overview of monthly post counts.
• Identify the top 5 content categories by reaction scores to determine their popularity.
• Analyse user sentiment trends over time.
• Understand which content types (photos, videos, GIFs) are most effective.
Interactive Features
Cross-visual interaction: Selecting a data point filters all related visuals.
• Identify the top 5 content categories by reaction scores to determine their popularity.
• Analyse user sentiment trends over time.
• Understand which content types (photos, videos, GIFs) are most effective.
Interactive Features
Cross-visual interaction: Selecting a data point filters all related visuals.
Key Insights
• May 2021 had the most posts, showing a rise in content sharing.
• Animals and Science were the most popular categories, indicating strong user interest.
• Positive sentiment dominates overall user reactions.
• Photos and videos have the highest engagement.
• Animals and Science were the most popular categories, indicating strong user interest.
• Positive sentiment dominates overall user reactions.
• Photos and videos have the highest engagement.
Conclusion
Focusing on popular categories and formats can help SocialBuzz optimise engagement. Interactive features make the report accessible to all stakeholders.
Focusing on popular categories and formats can help SocialBuzz optimise engagement. Interactive features make the report accessible to all stakeholders.
