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:

  1. 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.
  2. 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.
  3. 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.
  4. 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
example image
example image
example image
example image
example image
example image
example image
example image
example image
example image
example image