Welcome to the competitive world of cat influencers! These furry stars dominate social media with their whisker-twitching antics and adorable antics. As their data analyst, your job is to find insights into their performance, help them gain followers, and secure more sponsorship deals.
📂Here’s the spreadsheet for the Cat Influencers’ Social Media Analytics case study. This file contains anonymized social media performance metrics for 10 fictional cat influencers.
Task: Create a dashboard in Google Looker Studio and use only a bar chart, pie chart and a table to answer the following questions.
- Which cat influencer has the highest total engagement by (Likes + Comments + Shares)?
- What is the most popular post type based on the number of posts?
- Which cat influencer generates the most sponsorship income relative to their engagement?
- Based on the data, which two cat influencers would you recommend for a brand partnership and why?