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>
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!

</aside>
A Claude account. You can use the web app at claude.ai or the Claude desktop app.
A web browser. Chrome, Edge, Firefox and Safari all work.
An internet connection when you open the dashboard.
The sample files. Download Sample-files.zip using the yellow button below, then unzip it.
<aside> <img src="/icons/save_yellow.svg" alt="/icons/save_yellow.svg" width="40px" />
</aside>
How to extract (unzip) the folder.