Inforiver Videos
MatrixEnterprise
  • Writeback Matrix
    • Overview
      • Enterprise Planning & Performance Management in Power BI
      • Real-Integrated Planning in Power BI
      • Top 5 Driver-Based Planning Techniques in Power BI
      • Power BI Writeback - A deep dive
    • Features
      • Summary
      • Collaborative commenting
      • Schedule, burst & broadcast reports
      • Data writeback
      • Writeback to Fabric OneLake/Data Warehouse
      • Ad-hoc emails
      • Dropdown lists
  • Reporting Matrix
    • Expert speak
      • Visual formulas vs DAX with Marco Russo
      • Faster reporting and insights with Matt Allington
      • The best custom visual for Power BI?
      • Build a P&L / Income statement in less than 5 minutes
      • Formatting financial statements in Power BI - P&L
    • Overview
      • No-code reporting
      • Cutting-edge data visualizations
      • Advanced data analysis
      • Data provenance & audit
      • What-if simulations
    • General
      • Reorder rows and columns
      • Layout options
      • Advanced filtering
      • Nested top N + others
      • Conditional formatting
      • Number formatting
      • Cell & value formatting
      • Notes & annotations
      • Comments with filter context
      • Totals & subtotals
      • One-click templates
      • Pagination
      • Group rows and columns
      • Search & filter
      • Expand/collapse hierarchy
      • KPI explorer
      • Audit log
      • Export to Excel
      • Comparative measures
      • Images in columns
      • Ragged hierarchies
    • Formula & calculations
      • Excel-like cell editing
      • Insert calculated and static rows
      • Insert calculated column
      • Insert calculated measure
      • Quick formula options
      • Invert signs
    • Planning, budgeting & forecasting
      • Manual data input
      • Allocations
      • What-if simulations
      • Data entry & simulations in reading view
      • No-code rolling forecasts
    • Graphical tables
      • IBCS visualizations
      • Bar charts
      • Lollipop charts
      • Waterfall charts
      • Bullet charts for 2 measures
      • Bullet charts for 3 measures
      • Stacked charts
      • Sparkline charts
      • Tornado charts
      • KPI cards
      • Blend column
    • Conditional formatting
      • One-click options
      • Semantic formatting
      • Heat map formatting
      • Format entire row
      • Traffic light & arrow alert
      • Fill icon and star rating
      • Segmentation
      • Format top/bottom N rows
      • Branch level formatting
      • Conditional formatting of multiple hierarchies
      • Dynamic conditional formatting
      • Format using if conditions
    • Visual-level formulas
      • Excel-like cell editing
      • Quick formula options
      • Smart analysis
      • Excel-like formula editor
      • Calculated measures and columns
      • 4 ways of inserting rows
      • Evaluate columns before rows
      • Manage aggregations
      • Automatic variance calculations
  • Analytics+
Powered by GitBook
On this page
  1. Reporting Matrix
  2. Planning, budgeting & forecasting

What-if simulations

PreviousAllocationsNextData entry & simulations in reading view

Last updated 2 years ago

Learn how you can perform instant what-if simulations and forecasting using Microsoft Power BI. Inforiver allows you to:

(a) Simulate at the org level and proportionally allocate them to its constituent products and geographies (top-down simulations)

(b) Simulate at granular levels and roll changes to the top (bottom-up simulations)

(c) Perform simulations intuitively using a slider

(e) Perform simulations by appending increments in percentages (e.g. +10%, -3%)

(f) Perform simulations by appending scaled values (e.g. +40m, -3.4k)

(g) Run variance analysis instantly in a few clicks, and visualize them using in-built templates

(h) Create several versions of simulations for analysis

(i) Export the simulated data (to PDF or Excel)

Related resources

Feature highlights

User guide

Blogs

Planning, budgeting & forecasting in Power BI
What-if analysis & simulations
Budgeting & allocations
5 ways to run dynamic what-if simulations in Power BI
Input & edit sales forecasts in a Power BI report
Forecasting multiple items with seasonality in Power BI