# 246 Sources 117b03b1

> Sources & Attribution

- Skill: `tools-only/246-sources-117b03b1` (Agent Skill, multi-file: 3 files)
- Install (CLI): `npx skillmds@latest add tools-only/246-sources-117b03b1`
- Raw SKILL.md: https://api.skillmd.com/api/skills/tools-only/246-sources-117b03b1/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Research & Search
- Author: tools-only (https://skillmd.com/u/tools-only)
- Updated: 2026-09-22
- Page: https://skillmd.com/skills/tools-only/246-sources-117b03b1

---

# Sources & Attribution

## Tool & Technology

### Power Query
| Aspect | Source |
|--------|--------|
| Core Technology | Microsoft Power Query (Get & Transform) |
| Official Docs | [Microsoft Power Query Documentation](https://learn.microsoft.com/power-query/) |
| M Language | Microsoft Power Query M Formula Language |

### Data Transformation Concepts
| Concept | Context |
|---------|---------|
| Tidy Data | Hadley Wickham - "Tidy Data" paper |
| Long vs Wide Format | Data normalization principles |
| ETL Patterns | Data engineering best practices |

## Methodology Influences

### Teaching Approach
| Method | Purpose |
|--------|---------|
| Diagnosis-First | Understand problem before solution |
| Goal Visualization | Show desired end state |
| Concept + Action | Explain WHY before HOW |
| Timely Warnings | Prevent common mistakes |

### Coaching Principles
| Principle | Source |
|-----------|--------|
| Scaffolded Learning | Vygotsky's ZPD |
| Guided Discovery | Constructivist pedagogy |
| Progressive Complexity | Instructional design |

## Key References

- [Microsoft Power Query Docs](https://learn.microsoft.com/power-query/)
- [Hadley Wickham - Tidy Data](https://vita.had.co.nz/papers/tidy-data.html)
- ThepExcel.com Power Query tutorials

## Developed by ThepExcel

- Five-phase coaching workflow
- Thai persona design (Nong Fah coach)
- Multi-row headers handling methodology (Method 1 & 2)
- Diagnosis framework and problem patterns
- Best practices for reproducibility
- Common pitfalls documentation
- Real-world examples from Thai business contexts

---

*This skill helps office workers transform messy data into clean, analysis-ready formats using Power Query UI.*