power-query-coaching
Power Query Coach
Overview
This skill helps users transform "ugly data" that can't be used for analysis into clean, structured data ready for Pivot Tables, Power BI, or any analytical tool. The coach:
- Diagnoses data structure problems by analyzing user input (description, upload, screenshot)
- Explains why the current structure is problematic and what issues it will cause
- Visualizes the ideal "goal state" with proper data structure
- Guides step-by-step transformations using Power Query UI (70-80% of problems solvable without M code)
- Suggests best practices to prevent future issues
Target users: Office workers who know basic Power Query but struggle to visualize how to transform problematic data structures.
More from thepexcel/agent-skills
graphic-designer
Designs graphics for thumbnails, social media, banners, and presentations. Applies design principles (CRAP, Gestalt, visual hierarchy) with research-backed techniques. Integrates with /geometric-elements for decorative assets. Use when creating layouts, choosing typography/colors, or designing any graphic assets. For photography/cinematography prompts, use /art-director instead.
399deep-research
Fast research that beats plain websearch — discovers what exists before searching specifics (Landscape Scan), catches recent releases within days/weeks (Recency Pulse + upstream supply chain), and runs parallel queries for multi-angle coverage. Good for everyday research and current-info questions. Use when user requests research, comparison, or "what's the latest on X". For high-stakes decisions requiring hypothesis testing, COMPASS audit, Red Team, or full report → use /deep-research-pro instead.
94explain-concepts
Explains difficult concepts using master teaching methodologies (Feynman, Socratic, Cognitive Load, Dual Coding). Use when user asks to explain a concept, "I don't understand X", ELI5 requests, "what is X", "how does X work".
80generate-creative-ideas
Creative problem-solving and ideation using SCAMPER, First Principles, Random Word, and AI-optimized techniques. Use when generating ideas, breaking creative blocks, brainstorming alternatives, or innovating.
80manage-business-strategy
Structured business strategy frameworks — SWOT, OKR, Porter's Five Forces, McKinsey 7S, BCG Matrix, Blue Ocean, and change management models. Use when explicitly planning company/product strategy, setting measurable business goals, analyzing competitive positioning, or designing organizational change. Not for general business discussion — user should be asking for a framework or structured analysis.
77design-business-model
Business model design and validation using Business Model Canvas, Lean Canvas, and Value Proposition Canvas. Use when designing new business models, validating startup ideas, achieving product-market fit, or innovating existing business models.
47