Exploring a Newsfeed Feature Engagement Using Tableau's Analytical Power
Case Description
Overview: In this Newsfeed Analysis in Tableau project, we will tackle a real-world case and gain hands-on experience optimizing a website’s newsfeed feature for maximum user engagement. Dive deep into a real-life database, perform data analysis in Tableau, and unearth crucial insights that can enhance our professional portfolio and skillset.
Objective: Our main goal is to generate graphs that analyze users’ interaction patterns with the 365 platform’s Newsfeed service. For this purpose, we must craft a data visualization in Tableau that captures critical findings from 01-01-2023 to 05-31-2023. Build this Tableau dashboard from scratch, utilizing it to deduce necessary conclusions and recommend potential refinements.
The challenge: A newsfeed is a part of a website that constantly updates with new content, showing the latest news or activities. This feature facilitates real-time discoveries and encourages user engagement by presenting fresh content each time the user accesses the platform. The 365 platform’s Newsfeed offers a mix of automated and manual posts. Automated entries showcase students’ milestones, such as completing an award card collection or earning a certificate of achievement. On the other hand, manual entries are texts created by students to share insights or opinions with the community. The aim of this Newsfeed Analysis in Tableau project is to determine which type resonates more with our audience and identify potential issues with these features, along with suggestions for enhancements. The task is to create several visualizations giving crucial information about the newsfeed and how the users react to it.
Drawing from your findings, we can create a strategy to optimize the newsfeed service, ensuring it’s engaging and encourages prolonged platform usage—fostering a vibrant online community and, ultimately, influencing course subscriptions and renewals.
Part 1: Creating a Dual Graph: Monthly Post Activity and Average Likes Part 2: Creating a Bar Chart: Subtype Post Distribution Part 3: Creating a Bar Chart: Subtype Popularity Measured in Likes Part 4: Creating a Bar Chart: Subtype Popularity Measured in Comments Part 5: Creating a Bar Chart: Newsfeed User Engagement Part 6: Creating the Dashboard Part 7: Formatting the Dashboard Part 8: Interpreting the Results
Project requirements: We will work with Tableau Public 2023.1 or newer for this Newsfeed Analysis in Tableau project.
Project files:
- For building the required visualizations in Tableau:
- newsfeed_analysis.twbx – a file containing the necessary CSV files for creating the graphs
- For directions on the required visualizations:
- dashboard_sketching.pdf – A file with a draft of the essential dashboard
Topics covered:
- Data Visualization
- Data Analysis