BI as Business Insight

Proving that what you do has real impact.

Parameters for What-If Scenarios in Power BI

Scenario If we increase the current forecast by 5%, what would have happened with the variance to forecast? If we had reduced by 3% instead, then what? How can we provide an input parameter to calculate variables and see the impact of that change in the charts and trends? Let’s start from a simple report… Read more

Dynamic TopN & Ranking in Power BI

Scenario Let’s assume we have data about projects, and we want to rank the projects by budget, so that if we filter the data by some criteria (i.e. region, country, or some other classification) the ranking recalculates for the new scope. We also want some metrics calculated for the TopN projects, i.e. total budget for… Read more