Accenture-Social_Buzz-Data_Analysis

The Accenture North America's Data Analytics and Visualization virtual internship on Forage offers an immersive experience simulating the role of a Data Analyst. Participants tackle real-world tasks, honing skills in data cleaning, modelling, analysis, visualization, and presentation, mirroring the day-to-day responsibilities of data analysts.

Certicate of Completion

There are 4 modules in this virtual experience programme

♦ Project Understanding

♦ Data Cleaning and Modelling

♦ Data Visualization and Storytelling

♦ Client Presentation

Task 1 - Project Understanding

As a data analyst, I acted as a bridge between the business and the data. I worked under the guidance of Mae Mulligan, an Accenture Managing Director, who was the client lead for Social Buzz. Social Buzz, our client, faced challenges in handling massive data due to rapid growth. Accenture was tasked with:

♦ Conducting an audit of big data practices

♦ Providing recommendations for an IPO

♦ Analyzing popular content My specific task was to analyze sample datasets and visualize the popularity of different content categories, identifying the top 5 categories with the largest popularity. About Client : Social Buzz

Meet Accenture Project Team:

Task 2 - Data Cleaning and Modelling

The first step is to use this Data Model to identify which datasets will be required to answer the business question which is to to figure out the top 5 categories with the largest popularity.

Data Model:

I identified and worked with the following datasets:

♦ Reaction Score (quantifying popularity)

♦ Content ID

♦ Reaction Types

♦ Content Type

♦ Category

I cleaned the data by:

♦ Removing rows with missing values

♦ Changing the data type of some values within columns

♦ Removing irrelevant columns

Next, I created a final dataset by merging the three cleaned tables. This resulted in one comprehensive spreadsheet that highlighted the top 5 content categories by popularity.

Task 3 - Data Visualization and Storytelling

I prepared a PowerPoint presentation using the given template, incorporating various charts such as:

♦ Pie Chart