Dashboard from your data

Why this exercise?

Until now you made games — fun, but your boss wants dashboards. Here, you transform data into something you would show in a meeting.

Open a new conversation

Click the small + next to the "New chat" tab.

Choose your data

Download one of the sample datasets below, or use your own spreadsheet:

You can also find all files on the Files page.

Tip: For the ecommerce dataset, start with just one file (e.g. orders). For the product normalization file, try asking ToqanClaw to audit the data quality and categorization.

Drag the file into the chat

Drop it directly into the message box.

The prompt

I've attached a spreadsheet to this conversation.

First, take a quick look and tell me in one sentence
what this data is about.

Then build me a single-page dashboard:
- Three big numbers at the top — the ones a busy
  person would want to know first.
- Two small charts below that tell the story of the data.
- A short paragraph at the bottom called "What stands out",
  written like a friendly note from a colleague.

Use the ToqanClaw palette: orange accents on cream,
with a touch of pink. Friendly labels, no jargon.

Once the dashboard works, use the deploying-with-claw-apps skill
to deploy it as a new app. I'll open it from the Apps tab.

Open the dashboard

Apps tab.

Use data from Google Sheets via MCP

Instead of dragging a CSV, you can connect ToqanClaw directly to Google Sheets and pull live data.

In the conversation, ask: "Read the spreadsheet [name or link] from my Google Drive and build a dashboard from it."

If you already connected Google Workspace in exercise TC3, this works right away.

I've uploaded orders, payments, and reviews data.
Join them together and show me:
1. Revenue trend by month
2. Average review score vs delivery time
3. Top 10 product categories by revenue
4. Payment method distribution

Build a professional dashboard with filters.