Detailed Ranking Example Using DAX in Power BI

Power BI is an amazing analytical engine! Today I’m going to show you how you can find your top customers – not just as static numbers, but through time and through any time period you could want. This is the power of DAX combined with the data model at its best. In this example I

Continue reading

Developing Sensitivity Analysis Logic Using DAX in Power BI

We’re getting specific today and really showcasing the analytical power of Power BI. Sensitivity analysis, or even running some ‘what ifs’ around this, allows you to almost predict what may happen in the future with your results. In this example I want to see what will happen to my profitability if I am able to

Continue reading

Compare Performance vs Forecasts Cumulatively w/DAX

Showcasing results cumulatively is, in my opinion, the best way to showcase trends in your data. When comparing data versus budget or forecasts, showing the trends or divergence in trend is essential. You want to make sure you can identify when your performance is breaking down as soon as possible and by viewing this cumulatively

Continue reading

Enterprise DNA Learning Summit – Session 3 Preview

Two sessions been and gone, with one more to go. The final session of the Enterprise DNA Learning Summit is tomorrow. Big thank you to everyone who has been involved. Have covered an immense amount about Power BI already with more to come tomorrow. Today we went through a wide array of analytical techniques inside

Continue reading