Latest Course Release – Advanced Analytics In Power BI

You can view more about this course here – Advanced Analytics in Power BI To review the first course module, check out this link – Anomaly detection techniques for Power BI To round off a huge 2017 I’m releasing a final course into Enterprise DNA Online. It’s been a significant year for content development at

Continue reading

New Course Release – Scenario Analysis Deep Dive

You can view details about this latest course release here – Scenario Analysis Deep Dive If you want an overview of what you can achieve with scenario analysis, you can here – Scenario Analysis intro Another month and another course release into Enterprise DNA Online. As many of you already know I’m a huge fan

Continue reading

Sorting By Financial Years In Power BI

I get this question a lot in many of the live trainings that I do, and it’s how can I sort my dates by the financial year. Now, obviously, not everyone’s year runs over the calendar dates or the calendar year. Your financial year might start at July, it might start in August, November, something

Continue reading

Multiple Currency Logic In Power BI – LOOKUPVALUE Example

A really common scenario within financial analysis is having to integrate currency rates across your transactional data. Most of the time, sales data is actually recorded regardless of the currency and the currency name or code is just placed inside a column. And it could be either USD, AUD, GBP, but it isn’t actually adjusted

Continue reading

Advanced Budgeting Insights in Power BI – FREE Training Workshop

The next free training workshop in the Enterprise DNA webinar series is here. You can register here – Advanced Budgeting Insights in Power BI The virtual workshop session will run for between 45-60 mins We are going to dive into various advanced budgeting techniques in Power BI during this one. Budgeting in Power BI is

Continue reading