Category: DAX

Detailed Ranking Example Using DAX in Power BI

Enterprise DNA Video Tutorial Power BI Ranking Examples Using DAX

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

Enterprise DNA Video Tutorial 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

Enterprise DNA Video Tutorial on How to Compare Results to Yearly Budget in Power BI using 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 – Event Wrap Up

Enterprise DNA Power BI Performance Summary Dashboard Template

And that’s it. We wrapped up the first Enterprise DNA Learning Summit today. Another great session, thanks to all who came today and really any of the days. I think as a first go at it, it went very well and will see where to next with the concept. I think overall it felt not

Continue reading

Enterprise DNA Learning Summit – Session 3 Preview

Enterprise DNA Performance Scenarios Dashboard Template

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