Accenture Task 3 & 4 | Data Visualization & Storytelling Internship | Forage Certification

Summary

This video script from an Accenture forage internship task focuses on data visualization and storytelling. It outlines the process of analyzing social media data, identifying top content categories, and presenting insights. The key findings include animals as the most popular category, with a significant reaction count, and January being the most active month for posts.

Takeaways

• 📈 The video is a walkthrough of Task 3 of the Accenture forage internship, focusing on data visualization and storytelling.
• 📚 Viewers are encouraged to like and subscribe for insights into enhancing storytelling skills with data.
• 📊 Task 3 involves learning how to create effective data visualizations and will be executed using Excel.
• 🔍 The presentation guidelines emphasize the importance of a clear agenda, project recap, problem statement, analytics team introduction, and process explanation.
• 📝 The analytics team's goal is to uncover insights such as the number of unique content categories, reaction counts to the most popular categories, and the month with the highest post volume.
• 📋 Pivot tables in Excel are the primary tool for creating charts, and a tutorial offer is made for those who need it.
• 🎯 Task 4 provides guidelines for creating high-quality presentations, which are crucial for effectively communicating data insights.
• 📉 The project recap includes a 3-month Proof of Concept (POC) focusing on auditing social bus big data practices, guiding an IPO, and analyzing top content categories.
• 📝 The process involves five key steps: data understanding, data cleaning, data modeling, data analysis, and uncovering insights.
• 🐾 Data insights reveal that there are 16 unique content categories, with 'Animals' being the most reacted to, garnering 1897 reactions.
• 📅 January was identified as the month with the most posts.
• 🏆 The top five content categories based on popularity scores are Animals, Science, Healthy Eating, Technology, and Food, with Animals leading by a significant margin.
• 📊 A pie chart illustrates the parity of shares from the top five categories, showing Animals and Signs as the most popular, indicating a preference for real-time and factual content.

Q & A

What is the main focus of Task Three in the Accenture Forage Internship?

The main focus of Task Three is data visualization and storytelling.

What should you do to enhance your storytelling skills with data according to the script?

You should like the video and subscribe if you haven't already, to enhance your storytelling skills with data.

What are the main points to consider when making a presentation according to the guidelines provided?

The main points to consider are agenda, project recap, problem, the analytics team, and process.

Which insights do they want to see in Task Three?

They want to see how many unique categories there are, how many reactions there are to the most popular categories, and the month with the most posts.

What tool is recommended for creating charts in Task Three?

Excel is recommended for creating charts in Task Three.

What are the three main tasks Accenture is focusing on during the 3-month POC?

The three main tasks are auditing social bus Big Data practices, guiding through a successful IPO, and conducting analysis to find the social bus top five most popular categories of content.

What are the five key steps in tackling the data analytics problem?

The five key steps are data understanding, data cleaning, data modeling, data analysis, and uncovering insights.

How many unique categories are in the data set and what are some examples?

The data set contains 16 unique categories, including food, animal, and soccer.

Which category had the most reactions and how many were there?

The animal category had the most reactions with 1897 reactions.

What was the month with the most posts?

The month with the most posts was January.

Which are the top five categories of posts from the analysis?

The top five categories of posts are animals, science, healthy eating, technology, and food.

What was the aggregate popularity score of the animals category?

The aggregate popularity score of the animals category was 74,900 65.

What does the pie chart show regarding the top five categories?

The pie chart shows the share of each category, with the largest gap between animals and science being 1.1%.

What is the significance of the animals and science categories in business terms?

In business terms, the animals category stands out from all other categories, indicating that real-time and factual content are the most popular.

What should viewers do if they found the content helpful?

If viewers found the content helpful, they should subscribe for upcoming and virtual certification, and continue learning and practicing more.