Category: Business Intelligence

Power BI Financial Reporting Tips and Techniques For Accounting & Finance

In this particular tutorial, I’ll be going over some integrated Power BI Financial Reporting techniques which was covered in an Enterprise DNA Learning Summit in the past. Integrated Reporting provides greater context for performance data and decision-making. When completing a financial reporting analysis in Power BI, it is highly likely that you will need to

Continue reading

Basket Analysis Introduction – Best Practice Tips For Power BI

Today, I’m going to introduce the amazing things that you can do with the basket analysis technique. With Basket Analysis inside Power BI, you can try to analyze the customer sales of one grouping of products versus another grouping of products. There’s plenty of application for this across Power BI. But for this tutorial, I

Continue reading

Advanced Product Budgeting – Actual Results To Budgets Per Product

I’m going to go over something specific in product budgeting. It’s quite advanced but if you can understand the concepts and the techniques that I go through here, you’ll also have a good understanding of what Power BI can do, how DAX works, and how you can combine a lot of different functions to get

Continue reading

How To Create Budgets With Seasonality Impact Using Power BI

I’m going to show you something specific and quite advanced on budgeting through Power BI. We’re going to dive into how to create budgets with consideration on seasonal impact.  This has great potential mostly because it paves the way for highly effective analysis. It also enables you to automate some of the insights that you

Continue reading

Projecting The Current Trend in Your Power BI

In this unique example, I want to show you how to project a historical trend in Power BI and repeatedly project it forward. This particular example came from a question in the Enterprise DNA support forum. An Enterprise DNA member needed to carry out this analysis in the real world using historical information, which could

Continue reading