Accenture North America Data Analytics and Visualization
As a Data Analyst at Accenture Cleaned, modelled and analyzed 7 datasets to uncover insights into content trends to inform strategic decisions Prepared a PowerPoint deck and video presentation to communicate key insights for the client and internal stakeholders
Social Buzz Project: Leveraging Data to Understand User Behavior
Objective: We analyzed Social Buzz user data (similar to a bike-share program) to identify key differences between engaged and casual users. The goal was to create strategies for turning casual users into engaged, active members.
Key Findings (Data Analysis Insights):
- “Animals” and “Science” Categories Lead in Popularity: Our analysis shows that users highly engage with content related to “Animals” and “Science,” similar to how frequent bike-share users may prefer practical routes.
- “Food” as a Common Theme: The presence of “Food” indicates a broad interest area, reflecting how bike-share users may use the service for leisure and recreation, particularly in areas with food services.
- January as Peak Activity Month: This peak reflects seasonal trends, similar to how bike-share usage spikes during summer.
- High Reaction Count for “Animals” Content: With 1897 reactions, this shows a clear favorite category, much like how members may frequently use specific bike types or routes.
- 16 Unique Content Categories: Highlighting a diverse content landscape, similar to bike-share’s various stations and bike types available.
- Excel-Based Analysis: The analysis was carried out using excel, demonstrating a flexible and efficient use of data analysis techniques.
Recommendations for Social Buzz:
-
Target Casual Users with Focused Messaging:
- Use the popularity of “Animals” and “Science” to emphasize quality, real-life, and factual content to engage casual users more effectively.
- Relate engagement to clear value, similar to how bike-share users may be targeted with routes for work/leisure.
-
Engage Users with “Food” Content:
- Partner with “healthy eating” brands to boost user engagement, similar to partnering with locations along frequent routes.
- Leverage the presence of this common theme to align user needs and content creation.
-
Incentivize Engagement During Off-Peak Times:
- Offer content series or promotions outside peak months to encourage consistent user activity, similar to bike-share incentives during winter months.
-
Highlight Efficiency and Adaptability
- Showcase how insights can be generated quickly using tools like Excel.
- Emphasize how real-time analysis can be implemented for continuous improvements.
Impact:
By understanding the data, we can provide actionable insights that enable Social Buzz to improve its user engagement and potentially convert casual users into active, engaged members. This ultimately leads to a thriving community and a more sustainable content platform.”
Skills i optained :
- Communication
- Data Analysis
- Data Modeling
- Data Understanding
- Data Visualization
- Presentations
- Project Planning
- Public Speaking
- Storytelling
- Strategy
- Teamwork










