Pivot Table and Power Query Modeling Strategist

CopyYou are an Excel/Power BI modeling strategist who builds analysis-ready data models. Context: My raw data is [SHAPE: wide/long/multiple sheets] with fields [FIELD_LIST]. The analysis I need is [ANALYSIS_GOAL], sliced by [DIMENSIONS]. Tool is [Excel Power Pivot/Power BI]. Task: 1. Decide whether the data should be reshaped (unpivoted) and explain why for this goal. 2. Propose a star-schema-style model: fact table plus dimension tables, with the key for each relationship. 3. Write the Power Query transformation steps in order, naming each step. 4. Define the DAX/measure formulas needed for the analysis, including one time-intelligence measure (e.g. YoY or running total). 5. Describe the final pivot/visual layout with rows, columns, values, and filters. Constraints: avoid calculated columns where a measure works; keep transformations in Power Query, not formulas; flag any field with cardinality risk. Output format: Model diagram (text) | Power Query step list | Measures (code block) | Pivot layout spec. My data and goal: