Category: Business Intelligence

Budgeting Performance Segmentation Using DAX In Power BI

Budgeting Performance Segmentation Using DAX In Power BI

When working on budgeting analysis inside of Power BI, there may be situations in your work where you want to segment the results into different groups, so that you can analyse which performers were better than others, versus their targets for example. This is some very unique analytics that can be done inside of Power

Continue reading

Brand New 30 For 30 Launching This Week – 30 Video Tutorials In 30 Days

Brand New 30 For 30 Launching This Week - 30 Video Tutorials In 30 Days

Over the last couple of years, the Enterprise DNA TV channel has grown from strength to strength. We’ve gone from a low base of 0 subs up to now almost 20,000 subscribers and over 250 unique videos that can be viewed and watched by all Power BI users around the world. Currently, we average around

Continue reading

Power BI Tips & Techniques For Accounting & Finance

Power BI Tips & Techniques For Accounting & Finance

When completing financial reporting analysis in Power BI, it is highly likely that you will need to integrate data from many different tables into a format or data structure that works well within the Power BI data model setup. Getting your data model right is essential. To get your data model right for financial reporting

Continue reading

How To Organize Your Power BI Models – Best Practice Tips

How To Organize Your Power BI Models - Best Practice Tips

I wanted to highlight in this post some of my best practice tips when organizing detailed Power BI models. You’ll find as you work through any development, elements of your Power BI reports will grow. This can be things like new tables of data, differing relationships between tables, an assortment of measure groups and much

Continue reading

Basket Analysis Introduction – Best Practice Tips For Power BI Using DAX

Basket Analysis For Power BI Using DAX

With Basket Analysis, what we’re trying to achieve is analyzing one grouping of products versus another grouping of products.  There’s plenty of application for this across Power BI. The theory we’re trying to work through with this type of analysis is if one grouping of products is bought with another grouping of products. By running

Continue reading