excel-weekly-dashboardDesigns refreshable Excel dashboards (Power Query + structured tables + validation + pivot reporting). Use when you need a repeatable weekly KPI workbook that updates from files with minimal manual work.
Install via ClawdBot CLI:
clawdbot install KOwl64/excel-weekly-dashboardGrade Fair — based on market validation, documentation quality, package completeness, maintenance status, and authenticity signals.
Generated Mar 1, 2026
A retail company receives weekly CSV exports of sales data from their point-of-sale system. This skill designs an Excel dashboard that automatically refreshes to show sales by product category, region, and ISO week, with validation for missing product codes and invalid dates to ensure data integrity.
An HR department manages weekly timesheet submissions as XLSX files with changing columns. This skill creates a refreshable Excel workbook that ingests these files, validates employee IDs and hours worked, and provides pivot reports on labor costs per department and week for payroll analysis.
A marketing team collects weekly campaign data from multiple sources like CSV and PDF exports. This skill builds an Excel dashboard that combines these files, validates key metrics such as click-through rates and conversion dates, and generates pivot charts to monitor performance across campaigns and weeks.
A logistics company uses weekly CSV dumps of inventory levels from warehouses. This skill designs an Excel dashboard that refreshes automatically to track stock levels, validate SKU numbers and shipment dates, and provide pivot reports on inventory turnover and shortages by ISO week.
A tech support team receives weekly DOCX-exported tables of customer tickets. This skill refactors an existing workbook to ingest these files, validate ticket IDs and resolution dates, and create a pivot dashboard showing ticket volumes and resolution times by week and priority level.
Offer tailored Excel dashboard development as a service for clients needing automated weekly reporting. Charge based on project complexity, such as data source integration and validation rules, with ongoing support for updates and troubleshooting to ensure refresh reliability.
Develop and sell pre-built Excel template packages that integrate with common business software exports like CRM or ERP systems. Provide subscription access to updated templates and Power Query code, targeting small to medium businesses seeking cost-effective reporting solutions.
Conduct workshops or online courses teaching teams how to build and maintain refreshable Excel dashboards using this skill. Focus on hands-on training with real-world data examples, offering certification or follow-up coaching sessions for continuous learning and application.
💬 Integration Tip
Ensure source files have stable identifiers like employee IDs or product codes to maintain data consistency during refreshes; use Power Query's folder ingestion to automate combining weekly files without manual intervention.
Scored Apr 19, 2026
Data analysis and visualization. Query databases, generate reports, automate spreadsheets, and turn raw data into clear, actionable insights. Use when (1) yo...
Professional data visualization using Python (matplotlib, seaborn, plotly). Create publication-quality static charts, statistical visualizations, and interac...
Auto-generate structured weekly business reports covering KPIs, accomplishments, blockers, and plans. Save hours of reporting time every week.
Data visualization, report generation, SQL queries, and spreadsheet automation. Transform your AI agent into a data-savvy analyst that turns raw data into actionable insights.
Perform a deep competitive analysis for a solopreneur business. Use when mapping competitors in detail, finding exploitable gaps, understanding competitor strategy, benchmarking your own offering, or deciding how to position against the field. Goes deeper than the broad landscape mapping in market-research — this is focused dissection of specific competitors. Trigger on "analyze my competitors", "competitive analysis", "who are my competitors", "competitor deep-dive", "how do I beat the competition", "competitive landscape", "benchmark against competitors".
Search and analyze Reddit content using semantic AI search via reddapi.dev HTTP API. Use when you need to: (1) Find user pain points and frustrations for pro...