excel-weekly-dashboard
CommunityAutomate Excel KPI Dashboards
Authordfpalhano
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill automates the creation of refreshable Excel dashboards, transforming raw data files into structured, validated, and report-ready workbooks with minimal manual intervention.
Core Features & Use Cases
- Automated Data Ingestion: Uses Power Query to ingest data from various file types (CSV, XLSX, DOCX/PDF exports).
- Data Cleansing & Validation: Implements robust validation rules to ensure data quality and identifies issues.
- Repeatable Reporting: Designs structured tables and pivot-driven dashboards that update automatically with new data.
- Use Case: Automatically generate a weekly KPI report from a folder of CSV files, ensuring data accuracy and providing interactive slicers for analysis.
Quick Start
Build me a Power Query pipeline for this file so it refreshes weekly with no manual steps.
Dependency Matrix
Required Modules
None requiredComponents
assets
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: excel-weekly-dashboard Download link: https://github.com/dfpalhano/openclaw-workspace/archive/main.zip#excel-weekly-dashboard Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.