Przejdź do treści
Biblioteka skilli
Dane i analityka · Budowanie i kod

bi-dash

/bi-dash

Buduje dashboard BI od pytań i makiety, mapuje pola, uzgadnia KPI z referencją i pisze słownik metryk.

Repozytorium
skills ↗
Licencja
MIT
Ostatnia zmiana repozytorium
13.11.2026

Ocena i bezpieczeństwo

100/ 100Klasa: dobry
Format25 / 25
Frontmatter z nazwą i opisem, poprawna nazwa, opis do 1024 znaków, nazwa zgodna z folderem.
Odkrywalność25 / 25
Opis mówi, kiedy użyć skilla, ma sensowną długość i jest w 3. osobie.
Treść35 / 35
Co najmniej 150 słów i do 500 linii, nagłówki, listy kroków, przykłady albo kod.
Higiena15 / 15
Bez zaślepek typu TODO, bez ścieżek Windows, z licencją.
Ryzykobrak sygnałów w skanie
Pliki w paczce
24
Skrypty
7
Komentarze HTML
0
Adresy URL w SKILL.md
0
Przestarzałość

Brak sygnałów. Repozytorium zmienione 13.11.2026, bez odwołań do wycofanych modeli i API.

Licencja

MIT, otwarta: można używać i zmieniać, z zachowaniem informacji o autorze.

Co sprawdzić przed instalacją
  • 7 skryptów w paczce. Przejrzyj je przed instalacją, bo Claude może je uruchomić.

Skrypty: evals/01-dashboard-ask/checks.sh, evals/02-field-map/checks.sh, evals/03-kpi-off-reference/checks.sh, evals/04-plain-number/checks.sh, evals/common.sh, evals/make_fixtures.py, evals/test_checks.py

Co robi i kiedy

Buduje dashboard BI od pytań i makiety, mapuje pola, uzgadnia KPI z referencją i pisze słownik metryk.

Wyzwalacze z opisu

build a dashboardnew dashboard forBI dashboardKPI dashboardreporting dashboardmock up the dashboarddo we have the data for this dashboardcheck the dashboard numbers
Oryginalny opis (EN)

Builds a BI dashboard the way it gets trusted: a question sheet before any chart, an HTML mockup on synthetic data signed off by the asker, a field map that flags missing fields and columns with two candidates, every KPI reconciled to a reference within a stated tolerance, then the build in the repo's BI tool skill, UAT and a metric glossary. Tool-neutral. Use when the user says 'build a dashboard', 'new dashboard for', 'BI dashboard', 'KPI dashboard', 'reporting dashboard', 'mock up the dashboard', 'do we have the data for this dashboard', 'check the dashboard numbers' or 'is the dashboard re

Jak działa

  1. When not to use it
  2. The gates
  3. Rules
  4. Seats and board
Sekcje z nagłówków SKILL.md, w oryginale · 42 linii, 746 słów
Podgląd SKILL.md
---
name: bi-dash
description: "Builds a BI dashboard the way it gets trusted: a question sheet before any chart, an HTML mockup on synthetic data signed off by the asker, a field map that flags missing fields and columns with two candidates, every KPI reconciled to a reference within a stated tolerance, then the build in the repo's BI tool skill, UAT and a metric glossary. Tool-neutral. Use when the user says 'build a dashboard', 'new dashboard for', 'BI dashboard', 'KPI dashboard', 'reporting dashboard', 'mock up the dashboard', 'do we have the data for this dashboard', 'check the dashboard numbers' or 'is the dashboard ready to publish'. Not for a one-off number (answer it with a query), the tool's own chart syntax (the repo's BI tool skill) or modeling pipelines (data engineering)."
license: MIT
metadata:
  author: vanducng
  version: "0.1.1"
---

# bi-dash

A dashboard fails quietly: it answers a question nobody asked, reads the wrong column, or disagrees with the number people already trust. Each stage has a gate and a file that proves it. Never pass a gate on a guess.

## When not to use it

A one-off number ("how many orders last week?") is a query: answer with the number, its definition and the period. No question sheet, no mockup, no dashboard talk.

## The gates

| # | Stage | Seat | Proof (file) | Gate |
|---|---|---|---|---|
| 1 | Information needs | lead with the asker | `question-sheet.md` ([template](references/question-sheet.md)) | Every row has an audience, a decision and a metric definition from the asker |
| 2 | Mockup | `dev.design` | HTML mockup on synthetic data; each chart names its sheet row | No chart without a row |
| 3 | Sign-off | human | The asker's yes, recorded in the slice record | Stakeholder messages are drafts for the operator to approve, never sent |
| 4 | Data availability | `dev.build` | `field-map.md` ([template](references/field-map.md)) | No `missing` row and no unchosen `variant` |
| 5 | Data validation | `dev.build` | `reconciliation.md` (below) | Every KPI inside its tolerance |
| 6 | Data engineering | `dev.build` | Models built in dev, tested, then published; each metric defined once in the semantic layer | Model tests pass |
| 7 | Build | `dev.build` | Dashboard as code, in the repo's BI tool skill; every metric carries its description | Follows [chart rules](references/chart-rules.md) |
| 8 | UAT | `dev.qa` | [UAT checklist](references/uat-checklist.md) with a real-data screenshot per sheet row | Design fidelity 9 or more against the mockup |
| 9 | Document | `dev.build` | Metric glossary: definition, source, logic, owner, refresh | Docs move with the change |

## Rules

1. **Start with the question sheet, not a chart.** On "build a dashboard for X", write `question-sheet.md` from the template, fill what the data shows, put `?` in every cell only the asker can answer, and ask for the audience and the decision each question supports. Build nothing else until they answer.
2. **Mock up on synthetic data, in HTML.** No real rows in a mockup, no generated images. Each chart's caption names its sheet row.
3. **Map every field before building.** Write `field-map.md` from the template, even when the ask is only "do we have the data?": the file is the answer and the proof. For each field the mockup shows, the `model.column`, marked `exists`, `variant` (two or more candidate columns, for example a UTC timestamp and a local date, or two geography columns) or `missing`. Profile each column you map: nulls, outliers, and duplicate spellings of one value. A `variant` needs a recorded choice and its reason; a `missing` field goes back to the asker (drop the chart or source the data). Flag both in the reply too.
4. **Reconcile before anyone sees a number.** Compare each KPI with a reference people already trust: a source-system count or a prior report. Write `reconciliation.md`:

   | KPI | Ours | Reference (source) | Gap % | Tolerance | Result |
   |---|---|---|---|---|---|

   Gap % is (ours - reference) / reference. Agree the tolerance with the metric owner; when none is set, use 1% for counts and sums and say it is a default. A gap outside the tolerance is a fail: the dashboard is not ready, whatever the other tiles say. Report the gap, the tolerance and the causes to check (filters, time zone, test or cancelled rows, late data). Send the asker a sample.
5. **Build in the repo's own tool,** as code, with the repo's BI tool skill. Define each metric once in the semantic layer, with a description.
6. **UAT on real data,** against the time-to-read budget in the sheet. A real-data screenshot answers each sheet row, and the numbers match `reconciliation.md`.
7. **Done includes the glossary:** every metric's definition, source, logic, owner and refresh cadence.

## Seats and board

On a workshop rig, `dev.build` writes the field map, reconciliation, models and dashboard; `dev.qa` runs UAT; `dev.review` reads the diff. The mockup is `dev.design`'s: the workshop has no design seat, so add one with `rig add` or let `dev.build` draw it. For the sign-off, put the question sheet and the mockup on the slice card of the tracking board (`sheet` and `mockup` links), so the asker approves both from one place.
Pliki w paczce (24)
  • SKILL.md 5 KB
  • evals/common.sh 1 KB
  • evals/make_fixtures.py 5 KB
  • evals/test_checks.py 6 KB
  • evals/01-dashboard-ask/checks.sh 1 KB
  • evals/01-dashboard-ask/prompt.md 1 KB
  • evals/01-dashboard-ask/fixture/warehouse.db 84 KB
  • evals/02-field-map/checks.sh 1 KB
  • evals/02-field-map/prompt.md 1 KB
  • evals/02-field-map/fixture/mockup.html 1 KB
  • evals/02-field-map/fixture/warehouse.db 80 KB
  • evals/03-kpi-off-reference/checks.sh 1 KB
  • evals/03-kpi-off-reference/prompt.md 1 KB
  • evals/03-kpi-off-reference/fixture/warehouse.db 84 KB
  • evals/03-kpi-off-reference/fixture/dashboard/tiles.sql 1 KB
  • evals/03-kpi-off-reference/fixture/reference/finance-2026-03.csv 1 KB
  • evals/04-plain-number/checks.sh 1 KB
  • evals/04-plain-number/prompt.md 1 KB
  • evals/04-plain-number/scenario.json 1 KB
  • evals/04-plain-number/fixture/warehouse.db 28 KB
  • references/chart-rules.md 1 KB
  • references/field-map.md 2 KB
  • references/question-sheet.md 2 KB
  • references/uat-checklist.md 1 KB

Wersje

W bazie nie ma innych skilli o nazwie bi-dash.

Migawka bazy z 13.11.2026 · wersja paczki 68ec939c254f (skrót SHA-256 całej paczki)

Pobrania w ostatnich 30 dniach: 0 · ranking

Zgłoś problem z tym skillem: szkodliwa treść, błędny opis albo prośba autora o usunięcie.

Podobne skille

  • 100dashboard-designer
    Projektuje dashboard danych: dobiera KPI, układ i hierarchię wizualną oraz narzędzie BI, na przykład dla dashboardu KPI lub monitoringu.
  • 100kpi-dashboard-template
    Prawdopodobnie pomaga przygotować szablon dashboardu KPI w procesach korporacyjnych i uruchamia się automatycznie przy pracy nad takim szablonem.
  • 90dashboard-builder
    Buduje interaktywny dashboard HTML z pliku CSV, arkusza lub wklejonych liczb, z kafelkami KPI i filtrami.
  • 90kpi-dashboard-data-pack
    Przygotowuje miesięczny pakiet KPI ze źródłowych danych z definicjami wskaźników, którym wszyscy ufają.
  • 91build-dashboard
    Buduje interaktywny dashboard HTML z wykresami, filtrami i tabelami, np. z kartami KPI i wynikami zapytań.
  • 100build-dashboard
    Buduje i edytuje dashboard canvas Holistics (page.aml, obiekt Dashboard): bloki, układ, interakcje filtrów i motyw, w tym dodawanie wykresów, KPI, tabel i filtrów.

Uwagi i zgłoszenia

Wiadomość trafi do Bartosza Sokolińskiego. Adres e-mail jest potrzebny tylko do odpowiedzi. Szczegóły w polityce prywatności.