From KR Digital + Tritelligent

<aside> <img src="/icons/cursor-click_brown.svg" alt="/icons/cursor-click_brown.svg" width="40px" />

HANDS-ON

</aside>

<aside> <img src="/icons/clock_brown.svg" alt="/icons/clock_brown.svg" width="40px" />

20 to 30 MIN

</aside>

<aside> <img src="/icons/robot_brown.svg" alt="/icons/robot_brown.svg" width="40px" />

CLAUDE

</aside>

In this exercise, you will use Claude to build a local dashboard that turns spreadsheet exports into useful metrics, charts, and insights.

You will start with a dataset you can export from a business application. For example, you might export social media analytics, CRM data, help desk activity, survey results, etc.

Claude will use a sample export to build the dashboard based on how the data is organized.

Once the dashboard is built, you can use it without Claude. Drop in a new dataset, and the dashboard will read the data, do the calculations, and update the results for you.

Because the dashboard follows the same rules and calculations every time, once you have tested that it is working correctly, you can expect it to process future datasets the same way, as long as their structure does not change.

2026-09-16_Bigfoot_LinkedIn-Dashboard_v6.html

<aside>

The Scenario

You run marketing for Bigfoot Sighting Tours, a fictitious company with big ambitions!

Once a week, you download LinkedIn analytics for the company page, format the results, and share them with your team.

Now the board wants an interactive dashboard. You have eighteen weekly downloads from March through July (Bigfoot busy season!), and no easy way to combine them or see the full picture.

Until now!

logo-horizontal.png

</aside>

What You’ll Need

Before and After