excel-weekly-dashboard
kowl64 제작
PDF & Documents요약
Designs refreshable Excel dashboards.
설명
이 스킬이 하는 일
Designs refreshable Excel dashboards using Power Query, structured tables, validation rules, and pivot reporting. Outputs a step-by-step build plan or actual M code and workbook specs depending on what you ask for. Targets weekly KPI workbooks that update from new files without manual edits.
Produces defensive, schema-aware M code that handles column changes and missing data instead of generic formulas that break on new exports.
사용 시점
- Building a folder-based Power Query pipeline for weekly CSV exports
- Setting up validation columns to catch blank or invalid rows before reporting
- Creating pivot dashboards with Year and ISO week slicers
- Refactoring an existing Excel model to handle new columns without breaking refresh
- Generating a Refresh Status sheet with row counts and error flags
예시 워크플로
User asks: Build me a Power Query pipeline for this folder of weekly CSV exports that refreshes without manual steps
- 1
Identifies source type as folder of CSVs and locates the stable business key (e.g., PayNumber)
- 2
Defines canonical schema with required columns, types, and allowed values
- 3
Writes Folder ingest query with missing-column handling and column name normalization
- 4
Creates Data_Staging and Data_Clean queries with validation flag columns
- 5
Designs pivot dashboard with Year and ISOWeek slicers and a Refresh_Status sheet showing last refresh time and row counts
WORKBOOK PLAN with sheet layout, Power Query M code template, canonical schema, validation rules, pivot design, and a refresh checklist
설치
clawhub install kowl64/excel-weekly-dashboardCLI 명령을 실행하거나, 프롬프트를 Claude Code, Cursor, Codex 등 사용하는 코딩 에이전트에 붙여넣으세요.