Tag: Advanced DAX

Predict Future Profitability within Power BI Using DAX

In this video tutorial, I will showcase some of the analytical work I enjoy completing the most in Power BI..that is working on future predictions.  I am always fascinated with trying to understand what could happen in the future. I’ll show you a technique around how you can almost predict future profitability and one that

Continue reading

Learn How to Detect Abnormal Patterns Behavior in Your Datasets – Advanced Power BI

In this video tutorial, I will show you in detail how you can discover abnormal patterns of behavior within your data sets. This is not something that will immediately stand out when running analysis across your data so you have to think quite analytically about it. By thinking deeply about what you want to achieve and

Continue reading

The Ultimate Advanced Viz. Technique in Power BI – Multi Measure Dynamic Visuals

This video tutorial showcases one of the best visualizations technique I’ve discovered in Power BI to date — the multi-measure dynamic visuals technique.  If you want to create dynamic visuals that can really make your analysis stand out? Then you need to make use of it. It allows you to work and present your results

Continue reading

How to Calculate The Number of Transactions Made in the Last N Days – Power BI Using DAX

Sometimes with your analysis in Power BI you may want to know how many transactions have occurred over a particular period of time. In this particular tutorial, I’ll show you exactly how you can calculate transactions within a given period of days.  Analyzing the transactional frequency could be crucial for a business.  Especially if you

Continue reading

When Did Your Customers Make Their Last Purchase? – DAX Techniques in Power BI

It’s the goal of every organization to see their business become successful. That said, understanding customer behavior deeply is one of the elements you can leverage for increased business success.  In this video tutorial, I am going to demonstrate how you can work out how many days it has been since a customer last purchased

Continue reading