DO MORE with LESS / How to use PARETO CHARTS to Maximise your IMPACT // Beginners Guide to Power BI

Рет қаралды 11,741

Күн бұрын

In this video we're going to look at how you can build a Pareto chart in Power BI.
🕓 TIMESTAMPS
0:00 - Intro
00:31 - What is the Pareto Principle?
01:09 - Demo
04:09 - Pareto Line Chart
10:26 - Formatting
11:51 - Applying Pareto on Category
12:58 - Applying Pareto on Products
-
📣 Get Demo Files HERE
bit.ly/3dJE2O7
🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.
solutionsabroad.thinkific.com/
📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more
solutionsabroad.co.uk/newsletter
🛒 Power BI TEMPLATES and more at our digital shop
solutionsabroad.co.uk/store
ko-fi.com/solutionsabroad/shop
❤ Other ways to SUPPORT us
/ solutionsabroad
ko-fi.com/solutionsabroad
📧 GET IN TOUCH
Website: solutionsabroad.co.uk/
Email: fernan@solutionsabroad.co.uk
LinkedIn: / solutionsabroad
Facebook: / solutionsabroad
Instagram: / solutions_abroad
🤝 SOLUTIONS ABROAD
Hi Power BI fans, my name is Fernan. In 2018 I founded Solutions Abroad to help fellow data enthusiasts learn Microsoft’s tool, Power BI. I’m currently based in London with over 8 years of experience working with data and business intelligence. In this channel I provide educational videos about Power BI including tips and tricks, step by step tutorials, news, and all of it for FREE. I also provide some paid content such as courses, templates as well as consultancy services.
If you like what we’re doing here and would like to support, consider purchasing something or donating through our Patreon, every little penny helps us keep the channel going.
🙏 THANK YOU
Thank you so much for checking out my channel and my videos. You, the community, have been instrumental in growing the channel to where it is now. Hope to see you again on my next video!
#PowerBI #DataAnalytics #BusinessIntelligence

Пікірлер: 33

@agapheputrasusilo741 4 ай бұрын

straight to the point, no ads. this guy is a life saver

@tamannathakur4852 20 күн бұрын

You are Super awesome man.. This video helped me a lot. Thanx a tonnnn

@musariololade2204 Жыл бұрын

This is a fantastic presentation. I love the way you broke it down and explained how this can be applied to any data set. Thank you.

@AbouAli01006300091 4 ай бұрын

What I love the most is the simplicity of illustration to understand a hard topic ! Very well done 👏🏻👏🏻

@dannyb7734 3 ай бұрын

AWESOME!!

@shafa7668 Жыл бұрын

Fantastic mate. Really useful. I am going to add this on live dashboard tomorrow. Thanks

@mart1484 23 күн бұрын

awesome man

@hendrik-stack22 Жыл бұрын

Great video. I really like that u have a nice understanding of technical and business-topics. Adding a second axis which cumulates the vales is a nice and fresh addition to boring column-charts. Well done. Keep up the "business-topics"

@manggnorora Жыл бұрын

Thank you! i found another gold youtuber. Keep it up sir!

@stoutis_tavern4203 11 ай бұрын

fantastic job, thank you so much!

@faraazali9589 11 ай бұрын

Great presentation bro. I'm gonna use this for our channel managers to focus on the top customers. Good job.

@unnikrishnansanthosh Жыл бұрын

Excellent one, thank you for sharing

@arbazahmad7177 Жыл бұрын

Excellent 🎉... Thank for this

@joelluis4938 Жыл бұрын

Great video !!

@EugegegeSky 3 ай бұрын

Im your fan! Thanks Fernan

@Rajesh-gw7di 4 ай бұрын

useful chart thank you sir

@ErnestoSantos-ro9oc 10 ай бұрын

Great Job. I like paretos charts. I do have 2 questions. Can we add a vertical line where 80% meet? and using a single slicer where we have the ability to switch Category and Product and the chart will change it? Thank You!

@ElricherRM 9 ай бұрын

Hi Fernan, great video as always!! Question: How can i add to this measure a parameter slicer so the user can select how many itens he wants to keep in the graphic?

@Me_anmolkohli27 3 ай бұрын

Thanks man, u explained it well. Need to present this today.

@jorstube Жыл бұрын

Another excellent video friend; the content of it is very precise; I have a question ; Have you done this analysis in a dynamic way, that is, can it be segmented in specific periods of time? Because most of the real cases that I have had, this analysis is required to be more dynamic; Regards

@mart1484 23 күн бұрын

QUESTION: How to use a slicer to change from country to product in 1 pareto chart

@michaellilov845 10 ай бұрын

Can you please create some videos of what one can and cannot do in terms of fax in live connection?

@JamalAzarouali 5 ай бұрын

how did you move the visualization pane to the ribbon in PBI?

@mdsultanahemad Жыл бұрын

Hi, I wasn't able to understand one thing in var _cumulative sum= sumx(filter(_sumtable,[total sales] >_current) But in _sumtable we didn't have [total sales] we have [sales] ?

@curiousape001 Жыл бұрын

Hi, what if there are 2 (or more) countries with exactly the same sales value? Pareto line will have the same value for both countries (the line will be flat between these points)?

@cathrerinezetadrones3169 Жыл бұрын

Same question! How would handle ties? Something with RANK…?

@teddyfabriciocordovasaenz3018 10 ай бұрын

@@cathrerinezetadrones3169 Same! anyone solved it?

@bejukacarlson6454 11 ай бұрын

Great content. Please where can u get free online data in which I can practice on? Thanks

@kian69topgun1 Жыл бұрын

Hi Ferran, can you please make a series of DAX videos wherein we can learn how to make such complicated calculations ?

@agapheputrasusilo741 3 ай бұрын

specifally DAX is not a difficult programming languange to understand and you dont have to understand all at once from the beginning

@user-jb7sm7lv6c 7 ай бұрын

I tried to show the count of 80% in a card visual. It worked, but when I clicked on any column in pareto chart, the card value changes to 0 or blank. I used this measure for card visual: Contributed to 80% Revenue = SUMX(KEEPFILTERS(ADDCOLUMNS(ALLSELECTED(LC[Account Alias]),"Count",[Revenue Pareto])),IF([Count]

@user-ld3po8nl6s 4 ай бұрын

percentage part dosen't worked for me