Showcasing Results For 80%/20% And Then Diving Into The Top 20%

by EnterpriseDNA Regular Visitor ‎08-07-2018 05:59 PM - edited ‎08-07-2018 07:37 PM

Have you ever heard of the Pareto rule? It is the theory that says 20% of your customers or products will deliver 80% of your profits.

 

I have created a short tutorial around the formula and visualization techniques you can use to effectively showcase this analysis inside of Power BI.

 

In this particular video, I run through different considerations around the formula combinations you need to apply in a particular context in your reports and visuals to showcase the 80/20 rule effectively.

 


Following on from this tutorial, I broke out our results so we could dive further into the top 20% since this is where the greatest amount of return is coming from. We want to understand the 20% deeply because this is where we'll likely get the biggest return from our efforts and actions.

 

Here I utilized an example around customers. We will analyze who these customers are, what they are doing, and why they are appearing in the top 20%.

 


If you think about all this analysis combined together, you will agree that this is a really powerful stuff.

 

You can start at a very high level to look at all your results but then focus and drill into what is actually creating the biggest impact. By doing this we are going to be able to determine the underlying factors and variables which are creating a particular outcome for us.

 

By completing this type of analytical work we should be making better decisions. There's no better way to add value to your data consumers than to create this type of analysis.

 

Hopefully, you'll get a lot out of these tutorials and that you can find a way to implement some of these ideas inside your own analysis. I'm sure and I'm confident that your consumers will love it.

 

All the best.

 

Sam

 

 

**** Learning Power BI? ****

FREE COURSE - Ultimate Beginners Guide To Power BI

FREE COURSE - Ultimate Beginners Guide To DAX

FREE - 60 Page DAX Reference Guide Download

FREE - Power BI Resources Enterprise DNA Membership

Enterprise DNA Online

Comments
by revolynu12 New Member
on ‎08-15-2018 11:25 PM

Revolyn Ultra has 100% Garcinia cambogia extract that could aid you suppress your irregular cravings as well as reduce the manufacturing of fats in the body. With the aid of HCA, these pills could assist in improving your serotonin levels in the body that boosts power, causing weight reduction. The combination of these two all-natural components could offer you a fat-free and also lean body. Revolyn Ultra weight loss formula is available for sale in France https://votofelforce.fr/revolyn-ultra/