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.