कंटेंट पर जाएँ
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 या जो भी कोडिंग एजेंट आप इस्तेमाल करते हैं उसमें पेस्ट करें।

लिंक