rweisssieker-xp Power BI Planning Simulation
Use this skill when the business needs decisions and scenarios, not only historical reporting.
Patterns
- Price/volume/mix simulation.
- Demand forecast and inventory what-if.
- Capacity planning and constraint simulation.
- Working capital scenario: DSO, DPO, inventory days.
- Budget and forecast variance.
- Order backlog and delivery promise simulation.
- Supplier delay and material shortage impact.
Architecture Options
- Power BI what-if parameters for lightweight scenarios.
- Writeback through Power Apps, Dataverse, Fabric, SQL, or planning tools.
- External planning systems such as SAP IBP, Anaplan, Kinaxis, Oracle Planning, Excel-controlled input.
Output Requirements
- Include scenario grain, input ownership, writeback target, security, audit trail, calculation logic, and validation.
- Flag when Power BI is only the visualization layer and planning ownership sits elsewhere.