Segmentation Example Using Advanced DAX in Power BI

Once you get more and more into advanced DAX formulas, you will see the world of analytical opportunities immeasurably expand for you. In this example I will show you by just how much. In this blog post, I am going to explore some relatively advanced DAX logic and then build upon it by combining an

Continue reading

Group Customers Dynamically By Their Ranking w/RANKX In Power BI

As many of you know by now, I am huge on showcasing how you can apply Advanced DAX Formula to discover insights that historically have been difficult to find and also showcase easily. Well, this is another example of that and a great way to segment or group results rather than just showing results by

Continue reading

Course Completion Certificates Now Available At Enterprise DNA Online

The Enterprise DNA Team has been working hard to deliver a brand-new certificate offering for those working through our education content at Enterprise DNA Online.  We now have the ability to create and issue course module completion certificates on any course that you might work through at the online education portal.  Check out below how we’ve created these certificates, and how they would look like

Continue reading

How To Organize Your Power BI Data Model – Best Practice Tips

BEST PRACTISE TIPS FOR MODEL ORGANIZATION

I wanted to highlight in this post some of my best practice tips for Power BI data modelling. In this tutorial, I go through many techniques in detail which I think you’ll find very beneficial as soon as you start implementing these into your reports. You’ll find that as you work through any development, certain

Continue reading

Using Power BI DAX Functions To Deal With Products That Have Changing Prices Overtime

DEALING W/ PRODUCTS WHERE PRICES CAN CHANGE

In this blog post, we are going to work through an advanced but real-world analysis involving Power BI DAX functions. The scenario in question is when you have products which change prices over time. A lot of the demos/showcases you have reviewed over time suggests that a product’s price stays exactly the same from the

Continue reading