In this tutorial, we’re going to learn more about the advanced time intelligence feature in Power BI to compare current sales to the previous best month. This is actually a unique question that was raised at the Enterprise DNA Support Forum. And as soon as I heard it, I thought wow! We can actually do
Here I want to showcase a unique idea around financial reporting, which is allocating results to predetermine table templates inside Power BI. After spending quite some time working out how to create these custom templates, I’ve finally devised a strategy around Power BI development. This strategy enables us to not only create these templates, but
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
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
Budgeting in Power BI is just not that easy to implement. I wish it was as easy as bringing in your actuals and budgets and then like magic you would be able to see the insights you need visualized in a compelling way simply by using Power BI forecasting. That’s why I created this blog
