Category: Business Intelligence

Layering Multiple ‘What If’ Scenarios Using DAX in Power BI

I’m huge on scenario analysis in Power BI. Being able to input variables inside your calculations that you can ‘shock’ to effectively predict outcomes is so powerful when trying to make decisions. In Power BI you can complete this really efficiently, and you can combine many of the formula techniques with your data models and

Continue reading

Latest FREE Workshop Announcement – Effective Power BI Reporting

The last Enterprise DNA free workshop session was a really great event, so I’ve decided to run another one before the end of this month. During this next session – Effective Power BI Reporting – I’ll be running through many of my best practice techniques around building valuable Power BI solutions. Now this doesn’t just

Continue reading

Compare Cumulative Results For Multiple Months

Showcasing your results cumulatively is such a powerful way to visualize your data over time, especially if you are trying to show the difference in performance from one time period to another. When you try to present this at a daily or even monthly level, identifying the trend isn’t always so obvious. When you place

Continue reading

Forecasting Techniques In Power BI By Using DAX

Forecasting analysis in Power BI can be completed in quite an effective manner if you utilise the time intelligence functions in DAX effectively. In this example I wanted to run through the many options you have available to start automatically creating forecasts based on historical information. Your forecasts in a lot of cases will be

Continue reading