See how Microsoft Fabric simplifies P&L forecasting with connected planning. Create budgets and forecasts from historical data, simulate scenarios, collaborate across teams, and manage allocations with a code-free planning experience.
Master multidimensional planning and allocation in Microsoft Fabric with this hands-on session on Fabric Plan Cube, where real-world use cases like expense allocation, chart of accounts allocation, forecast allocation, and gross margin calculation are demonstrated using Cube in Fabric Plan. Learn how to build multidimensional planning models, handle related and unrelated dimensions without coding, perform bidirectional allocations, allocate OPEX across products and channels, create gross margin calculations using reference measures, and connect Power BI semantic models to Fabric Plan. This session also covers practical implementation steps including setup connections, planning sheets, allocation logic, and spread/distribution techniques for enterprise FP&A and planning workflows.
Take your cash flow planning further with scenario analysis in Fabric Planning. In this demo, see how to simulate real-world financial decisions by adjusting key assumptions like investment levels and accounts receivable, using 2026 as a baseline. Learn how to create a sandbox scenario, compare actuals, forecasts, and simulations side by side, and instantly visualize the impact on KPIs like cash conversion and reinvestment ratios. This walkthrough shows how to test strategies, optimize working capital, and make confident, data-driven decisions—all within a single, integrated planning and analytics environment.
Learn how to build and forecast a cash flow statement using Fabric Planning in a fully integrated environment. In this demo, see how to create a planning layer on top of your semantic model, add a 2027 forecast series, and dynamically plan values without relying on spreadsheets. Watch how your updates instantly reflect in a waterfall chart, enabling real-time analysis of operating, investing, and financing activities—so you can make faster, data-driven financial decisions without refreshes or manual effort.
