Project Details
User Engagement Analysis
This project is part of the Job simulation by Accenture North America on Forage.
During a simulation at Accenture, I was tasked with advising a hypothetical social media client. This scenario required a deep dive into the role of a Data Analyst, providing a practical opportunity to apply my analytical skills to real-world decision-making.
Situation
The main objective was to clean, model, and analyze seven datasets to extract insights into content trends. Specific questions that needed to be addressed included:
- How many unique categories exist?
- What are the top 5 categories, and what is the total reaction for the top category?
- Which month experiences the peak in user engagement?
User Engagement Analysis Dashboard.
Action
To achieve these objectives, I employed a structured approach involving:
- Data Cleaning and Modeling:
- Processed the datasets to ensure accuracy and relevance.
- Structured the data to facilitate efficient analysis.
- In-Depth Analysis:
- Explored the datasets to identify unique categories and top content categories.
- Analyzed user engagement patterns across different months.
- Dashboard Creation:
- Created a Tableau dashboard to visualize the insights.
- Ensured the dashboard addressed the client’s specific questions while providing a comprehensive view of user engagement trends.
Result
The resulting dashboard provided clear and actionable insights, answering the client’s key questions and highlighting significant user engagement trends:
Top 5 Categories:
- Animals: 1,897 reactions
- Science: 1,796 reactions
- Healthy Eating: 1,717 reactions
- Food: 1,699 reactions
- Technology: 1,698 reactions
Reactions for the Top Category (Animals):
- Adore: 114
- Cherish: 125
- Disgust: 122
- Dislike: 115
- Hate: 128
- Heart: 120
- Indifferent: 100
- Interested: 110
- Intrigued: 116
- Like: 101
- Love: 119
- Peeking: 129
- Scared: 132
- Super Love: 123
- Want: 122
- Worried: 121
Total: 1,897 reactions
Peak Month for User Engagement:
May 2021
Conclusion
The comprehensive dashboard not only addressed the client’s specific inquiries but also unveiled critical insights into user engagement and content trends. These insights can inform strategic decisions, helping the client optimize content strategy and enhance user engagement. This project underscored the importance of meticulous data analysis and visualization in driving data-driven decision-making.