Portfolio / Community Intelligence Dashboard

Community Intelligence Dashboard

Compares 22 talent communities across 7 platforms on one scorecard, so the team can see where its effort pays off.

Google SheetsPivot TablesKPI DesignData Visualization

The problem

There was no single view of how target communities performed on each platform, so partnerships could not be prioritised on real engagement numbers.

What I built

I built a Google Sheets dashboard that brings together follower counts, engagement rates and each community’s strongest platform, across 22 communities.

Results

22Communities benchmarked
~7MFollowers analysed
7Platforms tracked

Built with

Google SheetsPivot TablesKPI DesignData Visualization

Diagram

See the workflow diagram →

What you see here

The demo runs on made-up sample data. Real records, internal methods and anything confidential are left out.

Want something like this?

Tell me about the process you want off your plate. The brief takes about three minutes, and the project is priced before I start.

Start a Brief