This skill helps office workers transform messy data into clean, analysis-ready formats using Power Query UI.
1---2name: 246-sources-117b03b13description: Sources & Attribution4---5# Sources & Attribution67## Tool & Technology89### Power Query10| Aspect | Source |11|--------|--------|12| Core Technology | Microsoft Power Query (Get & Transform) |13| Official Docs | [Microsoft Power Query Documentation](https://learn.microsoft.com/power-query/) |14| M Language | Microsoft Power Query M Formula Language |1516### Data Transformation Concepts17| Concept | Context |18|---------|---------|19| Tidy Data | Hadley Wickham - "Tidy Data" paper |20| Long vs Wide Format | Data normalization principles |21| ETL Patterns | Data engineering best practices |2223## Methodology Influences2425### Teaching Approach26| Method | Purpose |27|--------|---------|28| Diagnosis-First | Understand problem before solution |29| Goal Visualization | Show desired end state |30| Concept + Action | Explain WHY before HOW |31| Timely Warnings | Prevent common mistakes |3233### Coaching Principles34| Principle | Source |35|-----------|--------|36| Scaffolded Learning | Vygotsky's ZPD |37| Guided Discovery | Constructivist pedagogy |38| Progressive Complexity | Instructional design |3940## Key References4142- [Microsoft Power Query Docs](https://learn.microsoft.com/power-query/)43- [Hadley Wickham - Tidy Data](https://vita.had.co.nz/papers/tidy-data.html)44- ThepExcel.com Power Query tutorials4546## Developed by ThepExcel4748- Five-phase coaching workflow49- Thai persona design (Nong Fah coach)50- Multi-row headers handling methodology (Method 1 & 2)51- Diagnosis framework and problem patterns52- Best practices for reproducibility53- Common pitfalls documentation54- Real-world examples from Thai business contexts5556---5758*This skill helps office workers transform messy data into clean, analysis-ready formats using Power Query UI.*
Run npx skillmds@latest add tools-only/246-sources-117b03b1 in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.
Sources & Attribution It is listed under Research & Search on SkillMD.
This skill has not completed SkillMD's automated safety review yet. Independent scanners report: SkillSpector: PASS, Skill Scanner: PASS. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.
This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.
Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.
tools-only (@tools-only) published this skill. Their other Agent Skills are listed on their SkillMD profile.
tools-only