본문으로 건너뛰기
TakoAPI
스킬로 돌아가기

excel-weekly-dashboard

kowl64 제작

PDF & Documents
3.4kclawskills.sh가 보고한 다운로드 수
3스타
0조회수
좋아요 0개로그인하면 이 스킬에 좋아요를 누를 수 있습니다
—아직 평가 없음
내 평가

요약

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. 1

    Identifies source type as folder of CSVs and locates the stable business key (e.g., PayNumber)

  2. 2

    Defines canonical schema with required columns, types, and allowed values

  3. 3

    Writes Folder ingest query with missing-column handling and column name normalization

  4. 4

    Creates Data_Staging and Data_Clean queries with validation flag columns

  5. 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-dashboard

CLI 명령을 실행하거나, 프롬프트를 Claude Code, Cursor, Codex 등 사용하는 코딩 에이전트에 붙여넣으세요.

링크