Use Decomposition Tree to Explore and Analyse your Data // Beginners Guide to Power BI in 2021

Get Demo Files here
ko-fi.com/s/fb93b48c2e
In this video I cover how you can start exploring and analysing your data using one of Power BI's AI-powered visual, the Decomposition Tree.
-
🚩 Support us to get perks such as demo files, early access and more!
www.patreon.com/solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - [e-mail]
🤵 LinkedIn - www.linkedin.com/company/solutionsabroad
📘 Facebook - solutionsabroad
📸 Instagram - solutions_abroad
🐤 Twitter - AbroadSolutions
🤖 Reddit - www.reddit.com/user/fernanespejo
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of KZbin.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
kzbin.info/www/bejne/n3ndnXyDgZKpjdU
🗺 Learn DAX to extend your Power BI calculations
kzbin.info/aero/PLa370_-deBCS5Kj3wMnhQjc-a8yznueHC
📆 Stay up-to-date on all the features Power BI releases monthly
kzbin.info/aero/PLa370_-deBCTu1VvH58zzPNC7mHSF4KvX
🧪 Get certified as a Microsoft Data Analyst Associate
kzbin.info/aero/PLa370_-deBCSTVsrfawVhU5Oitoi5hEWa
💡 Learn Power BI Features to improve your dashboards
kzbin.info/aero/PLa370_-deBCQZ1kmob-KIVlBihwCOfG53
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
powerbi.microsoft.com/en-us/downloads/
#PowerBI #DataAnalytics #BusinessIntelligence

[@Adeyeye_seyison]

My go-to Bi guru, Thanks for ALL you do and represents sir. I have a question not really related to this tutorial. You did a series in SELECTCOLUMNS and SUMMARIZE. Pls, what's is the difference between both and when to use them.

[@SolutionsAbroad]

Hi there, thanks for watching and subscribing! They're both table functions but SUMMARIZE groups the columns you feed it, whereas SELECTCOLUMNS doesnt. So if you have duplicate values on a field you use on SELECTCOLUMNS, you will get unique values if you use SUMMARIZE. Hope that helps!

[@RehanShaikh-ip9hh]

Hi Fernan, Thanks for the explanation. Can we also make budget vs actual either quantity or Price for each category i.e. Territory, county, customers. Kindly advise.

[@SolutionsAbroad]

Hi Rehan, filter context should still apply to the Decomposition Tree, if you add a Filter Slicer to your data by Territory or Country, it should still work

[@ahmedsamir3386]

there is possibility to add percentage beside the number ? for example : 2,000 (49%), as i see you can make the value numbers or percentage but not both.

[@SolutionsAbroad]

Hi there, great question! I don't think you can with this visual, you can probably have either value or percentage but not together I'm afraid

[@EyiBillion]

Hi Fernan, thank you for this. This brings me to the question : DAX fxtn on How to calculate Percentage growth by product category using same data? Hope this will suffice here .Thanks always

[@SolutionsAbroad]

Hi Eyitayo, thanks for the question! If i understood correctly, you need to show the % growth using the same data? The quickest way to show % growth is by using the ribbon chart (shows % change automatically) however if you need an explicit DAX measure it can get lengthy, i'll see about covering it in my future videos!

[@katkasabikova]

I have built a very similar tree to yours, however, at the end, where you have 'Quantity', I would like to see totals, not breakdowns. e.g. for Europe> Sweden> total of gummy bears; instead of 2 users having 4 gummy bears, 10 users having 5 gummy bears, etc.; is this possible or do I need to create a custom column? I cannot wrap my head around how the formula would even look like since I have a table exactly like yours, thx a lot

[@Soulenergy31]

Love it Guru!!!!!