Create an Insightful and Stunning Pareto Table in Power BI 🤯
HTML-код
- Опубликовано: 30 июл 2024
- Pareto Analysis in Power BI | How to Do 80/20 Analysis in Power BI
Learn DAX & Data Modelling - goodly.co.in/learn-dax-powerbi/
Download the Power BI file - goodly.co.in/pareto-analysis-...
In this video, I'll show you how to create a Pareto Table visualization in Power BI that classifies top products in one category and groups the rest.
This Pareto analysis, also known as 80/20 analysis, helps you identify key products that drive most of your revenue, making it easier to optimize inventory and marketing strategies. You'll also learn how to create a slider to dynamically define the percentage for grouping products, adding more flexibility and precision to your analysis.
Follow Gustaw Dudek's on LinkedIn - / gustaw-dudek
===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -
goodly.co.in/learn-m-powerquery/
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step-by-Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File ⬇️ - goodly.co.in/pareto-analysis-...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers! Наука
📌Learn DAX & Data Modelling - goodly.co.in/learn-dax-powerbi/
⬇Download the Power BI file - goodly.co.in/pareto-analysis-in-power-bi
Absolutely wonderful pure golden tutorial. Cool formulas, amazing examples and outstanding presentation 🎉❤
It's perfect. I have learned a lot about your knowledge as well as your logical reasoning step by step. Thank you very much.
Thanks for the wonderful tutorial. I have learned a lot.
Very insightful & useful - thank you Chandeep!
So amazing, thanks Chandeep!!!
Very insightful visual. I am gonna add this to my next project fs.
excellent.....Thanks for teaching👍👍👍
Truly amazing vid, really!
Again a great education
Awesome!!
Thanks for sharing !!! l learned a lot from your video.
So elegant
Thanks
impressive
Agin one of 👍👍TOP PRESENTATION 👍👍, we have two parts A+ and others, what if I want to create more groups with some condions, group A should have top 80% of sales, group B have at top of 50% and C top 30% and the others. Or some another percentage A=90%, B= 70%, C=40%, D=10%,and other, It would be nice as one additional video. TOP
Will have to watch this first thing in the morning 😂😅😊🙏🏻🙏🏻
When I replace the product name with split category [prod name], the total sales became total amount across all the products. Where did I go wrong?
Anybody knows what is the app he is using to draw/annotate in his screen?
Thnx 4 ur effort, please build up your file with us step by step ..i belive that u need to accelerate your video but build with us
I have faced a problem. i have sales qty column in multiple table. sum all tables sales qty colum as well as sales target qty. and made another measure sales qty / sales target qty. all tables has division product wise 4 years sales data. now i want to count how much product sales ach% is greater than 100% for division? can you help me?
was a wonderful video and it came in the right time I was thinking on the pareto visual. Howver I have an issue - RT Split = SWITCH(
true(),
value(SELECTEDVALUE('Split category table'[Value])="A+" & [Running contribution]
Nice work. I don't get the cross joined table though. Seems to work just fine with a two row table of the two categories and no relationship.
First like and comment is mine.😁
Hi sir do we have any EMI options for your course?
sorry not as of yet
why I don't see the calculated groups feature in my PBI?
update it
Very very insightful🫡
Sundar IS FROM iit Kanpur