How To Create these useful Power Bi Visuals that Excel Lacks
HTML-код
- Опубликовано: 16 июн 2024
- 👉 Join our popular FREE Power BI QuickStart course today: link.xelplus.com/yt-d-visuals...
Dive into the world of advanced data visualization with Power BI! Our video tutorial showcases some of the most impactful visuals in Power BI, turning complex data into insightful, actionable information. Perfect for business analysts, data scientists, and anyone looking to elevate their report design skills.
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
⭐ If you're ready to become a Power BI Pro, join our "Fast Track with Power BI" 👉 link.xelplus.com/yt-d-visuals...
Highlights of This Tutorial:
▪️ Ribbon Chart: Discover how to track rank changes and data over time.
▪️ Decomposition Tree: Explore this AI-powered visual for multi-dimensional analysis.
▪️ Scatter Chart with Play Axis: Learn how to analyze changes over time with interactive scatter plots.
▪️ Infographics & Custom Visuals: Get creative with custom shapes and dynamic visuals in your reports.
Here is a list of my favorite Microsoft Power BI visuals. I'll show you how you can turn data into actionable decisions. You'll learn about 4 powerful visuals in Microsoft Power BI. We'll start with the ribbon chart to easily identify rank changes over time. Next is the Power BI decomposition tree which lets you visualize data across multiple dimensions. It automatically aggregates data and enables drilling down into your dimensions in any order. It also has an Artificial Intelligence (AI) feature that can find insights for you. Then we'll take a look at the scatter chart in Power BI which comes with a special twist. It has a play button so you can visualize the change in the bubbles over time. And finally, I'll show you how easy it is to use infographics in Power BI to get your message across. Neither of these charts is easy to setup in Excel.
00:00 Powerful Data Visualization in Power BI
00:55 Ribbon Chart
03:17 Decomposition Tree
05:49 Scatter Chart with Play Axis
07:08 Infographics
10:17 Wrap Up
🎬 LINKS to related videos:
- How to Use Microsoft Power BI: • Power BI Tutorial For ...
- 10 Power BI Tips for Better Dashboards: • 10 Power BI Tips for B...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#powerbi
![100 Days - [Minecraft Creative 2]](http://i.ytimg.com/vi/OmogWsk_ZZg/mqdefault.jpg)
If you found this video helpful, you're going to LOVE my FREE Power BI QuickStart course 👉 link.xelplus.com/yt-c-beginner-powerbi-freecourse
It's designed to get you results FAST, without the techy jargon.
do you know of a free course for teachers? My school is moving towards mounting these TVs that are interactive. I have been using an iPevo. FYI, I teach mathematics. Thank you steve
When can we enroll for the full course
The quick chart we part in SharePoint is poor
Definitely suggest adding Knaflic’s book, ‘Story Telling with Data’, to your resources list. The book is detailed, simple, and easy to digest - just like my ideal visuals 😊
This Scatterer over time is a real deal, big boooom. Great video Leila as always, thanks and keep it up.
Thank you for the Power BI videos! You teach very well and they are easy to understand. You speak well and clearly too, which helps a lot when I'm trying to follow along with you. Please continue to share more Power BI tutorial! More power! ❤️
Glad you like them!
This is so informative. As always, you provide excellent content! Thanks for sharing!
Super impressed with these visuals that I never dared trying out for my models. Thanks for sharing!
This video is insane! 🤯
Too much Incredible insights.
Thanks a lot!
Best wishes from Brazil! 🙋🏻♂️🇧🇷
Super video Leila! I am using Power BI, but got to know so much more about these visuals! And the way you explain is simply amazing! I am previewing your new Power BI course and already impressed! You are doing a great job, and I am buying this course for sure! 👍
Yay, thank you Vijay. Looking forward to seeing you inside the course!
Thanks Leila, I am teaching Excel and Power BI to workers in different businesses as part of a continuing ed program. I always plug your channel with "By the way, if you want more check out this channel". Keep up the great work.
Thank you for your support, Donna! I hope your students will find the videos helpful.
Please more Power BI videos. The power of this tool is amazing. Do you have advice on how to create narrative stories? If you elongated a page I can see a great opportunity for infographics. 😊
Hi Leila, This is an amazing video. Thank you very much !
Would you mind please creating a video on how to build a risk matrix using Power BI ?
This would be extremely helpful.
I'm looking forward to watching your video on the risk matrix :)
Many thanks.
Excellent Videos. Very professional approach and cystal clear examples. Thanks for this Leila.
Wow... this is what I have been waiting to learn.... Thank you very much again!...
Wow, another great video! Thank you @Leila for making us discover all the "power" of Power BI 🙂. Btw, I'm at 47% of your free preview and I've learned a lot.
Awesome! Thank you!
Amazing...😀 The capability of Power BI is vast, so one needs to upscale their knowledge and know how to use the various visualization tools. Sure the upcoming course will do just that!
Great video as always Leila.
It really is a power tool. Hope to see you soon inside the course!
Hi Leila, I really enjoyed this video. I had a 2nd thought whether to enrol in the main course but the diverse visuals you showcased has changed my mind. I can't wait to enrol
Yay, that's great to hear Shadrack! See you soon inside the course.
Hi Leila. Thank you so much I get much information about Power BI.
very informational to see all these rarely used features being highlighted!
Fantastic video that was easy to follow and sparked a lot of interesting Power BI ideas I want to try. Thank you!
I knew you could do a time element with Tableau’s scatter plots, but for some reason I didn’t think to check that PowerBI also had that same functionality. Thanks, that will be useful.
Thank you ma'am 🙏🙏 please keep posting videos of Power BI
Hi Leila, great content as always. Quick question question. I'm very knew to Power BI. Where did the data come from in this example? Was it an imported excel file?
Fantastic! The last visual for me is more interesting!
Thanks for the video. I’ve enrolled in your PowerBI course and I’m enjoying it.
Great to hear!
Excellent as usual! Thank you.
Thanks for this video! Useful and inspiring as usual. Suggestion: another video specifically on the ribbon chart, how to enhance the input to be taken from the lighter areas (if we can add fields, etc... same way we do for the "Tootips") and if it's possible to have the total for each ribbon at the top. This visualization can be really informative so probably it's worth to have a dedicated tutorial to it... Thanks again! :)
A highly valuable knowledge share. Thank you!
Great and very useful presentation. Thank you for this.
Great work, again, Leila. Thank you!
Thanks a lot for educating us!🙂
I was thinking about this yesterday actually. Power BI does have some really cool visuals that would be very much welcomed in Excel. Let's hope the development team sees this!
👍
@@LeilaGharani Not going to happen though is it, or else it will cut subscribership, there's loads of tools that could directly be added to Excel but not good business for MS when we pay monthly for Power Bi
@@swake1822 there are reasons not to use Excel for important business processes. I love Excel and I know how to handle it. But many people don't. And in bad hands Excel quickly becomes a mess. Also, many organizations who have moved to Office 365 have PBI already covered by their subscription already. They just don't bother using it, because Excel culture stands in their way
@@alexgry4763 Good call, I like people to use my reports, not mess about with them 👍
You are too good Leila,Keep it up!Please upload more Power BI videos.
As always - really helpful video with valuable hints ! It’s always a pleasure watching - vielen Dank ☺️
Bitteschön 😊
Thanks for sharing this wonderful video.
Your Videos are very helpful! I’m a big fan
This was great! Infographics are amazing! I am going to try it now!
Great content as always ! Thanks.
Great to know all these, thanks from the heart!
Cool charts explained in short video !
Thank you for dropping this
Nice and informative video, as always. In the decomposition tree, is there any way that I can see all branches of tree as one visual? I want to see all the tree and not only one branch.
OMG ... yet again (no surprise) another thought-provoking video ... a fast-flowing river of ideas ... 😍😍😍😍
Thanks again, Chris!
Got more information about the use of Decomposition tree. Thanks
Nice job! One tip, in the Scatter chart, select a data point, then play. A line will display the change over time. Easier to understand.
Cool, thanks!
Awesome tips, thank you!
I really enjoyed this video, great job! Also I have a question..in the infographic part I noticed the shape resize after applying filters with the slicers, how can I fix the shape in order to do not resize it ?
Do you also show the raw data in another video? It would be good to catch a glimpse of source figures that generate these awesome visuals . Thanks
Lovely !! That Decomposition tree can be an extremely powerful tool for finance performance analysis and measurement in finance and management accounting spaces.
Absolutely!
This is actually next level stuff... Way too good.. Thanks Leila..
My pleasure 😊
Brilliant, thanks. Can you provide more videos on the visualisations in PowerBI
Thank you so much. By the way, do you know how we can show all the months of the last year but only the months that we select of the current year in a line graphic?
Excellent as always, thanks Leila!!
Thanks again, Chris!
Always usefully and helpfully video from you, thank you very much
You are most welcome, Giorgi!
Nice!!! must try! thanks Leila
Still The greatest teacher on RUclips
Gold standard presentation!
New tips to excel in Excel... thanks 👌🏼❤
Most welcome!
You are the reason of my promotion! I love you! ❤
Thanks for the great tips!!!!
I admire you a lot .... you teach us so many cool stuffs
...
I love the stats at the beginning
Thank you sooo much!!!
Very impressive thank you😊
You're simply amazing!
Superb - thank you
Excellent tutorial.
Great video. I suggest you make a video of presenting. I have noticed 98% of all videos on RUclips the presenter use a lot of disturbing hand gestures. Why? News reporters keep their hands on the table, why? I saw a video of one person with a helmet camera driving a motorcycle and he started making gestures with both hands while driving. He almost lost control and had an accident! Always keep your hands on the handlebar while driving!
You have a good clear voice and good speed in your talking on your videos, perfect.
Hey, Leila! Waiting for the scripts course! Will this be made available on udemy? :)
Would love to see your DAX playlist on power BI
Leila - I always watch your videos and am subscribed. Can you please post a video about how Iranians in Iran can utilize VPNs? They require guidance and you are very precise and technical and can explain the process very clearly.
Absolutely fantastic
Thank you
Hi Leila - Loving your Power BI training videos and Fast Track course !! One question about Visuals that I can't seem to figure out - Is there a way to set custom increments for the range of values displayed on the x-axis & y-axis ? For example - If a Clustered Column Chart defaults to increments of $5M on the y-axis - is there any way to change this to smaller increments ? Thanx and keep the great training videos coming !!
Hi James. Currently in Power BI, you can just set the start and end / min and max. There is an (old) request with a lot of votes that's still pending ideas.fabric.microsoft.com/ideas/idea/?ideaid=8d290c47-1aba-4044-920c-ba0ae3981742 - The recent BI updates don't also seem to have anything added for this purpose... If we can think of any workarounds will let you know.
By the way, it's best if you post future questions in the comment section of the course. This way we make sure we don't miss your comment. On RUclips sometimes they go under :)
Thank you 😊
Hi Leila. What’s the model of your laptop shown in the video? Would you recommend buying a new surface laptop 5 or is the 4th series more than enough for the analysis tasks you do.
About the composition three, is there a way to see the values as %%?
Thanks for de video!
wonderful. this is amazing.
blessed to learn
this is so informative, thanks a lot!
Glad you enjoyed it!
Wow great job👍
awesome content leila
Thank you really usefull
thank you.
Excellent!
Last one is more informative visual!!!
I know a guy who knows a guy who counted the visualizers on the market-and there are about 70! They mostly imitate each other as their makers vie for a pice of the pie.
This video shows a step in the right direction-which is to automate the creation of effective visuals, instead of forcing people to learn Python & other languages.
Super informative ❤!
Glad you think so!
Hi Lela, @9:18, why did you choose 1 as the maximum value? Thank you
really very nice
Gracias
Will the Power BI on Udemy soon? Thank you!
Hi Leila. Is there any way to integrate PBI to excel or word file?
Thanks!
Thank you, Kurt!
love it!
Great Work ! when i tried to replicate the same, i dont see some features currently avaialble any alternate suggestions please
Which measure have you added to profit, to use it in the decomposition tree?
2M subscribes soon 👍
Maybe it is because I am not a frequent user, but Power BI frustrates me a lot compared to Excel, but some of its visualisation tools are great, and it's nice to be able to easily use Python to access proprietary databases without having to export and import data manually.
The way I see it Excel let's you do whatever you want but isn't very "smart" about it. So you need to manually connect all the pieces of the puzzle. The complexer the puzzle you make, the more lose ends you have to deal with (and it can end being a lot more work then you imaged). PowerBI on the other hand limits you in what you can do but this is to ensure it continues to understand your logic. I find that once I get going it is so much easier to finish a project and typically it just works without any undesired consequences no matter the complexity. So PowerBI is frustrating in the beginning but in the long run it just works.
2:58 I like how add runs away from mouse cursor.
And your hair today are absolutely stunnig!🤩
Haha, thanks for noticing. My video editor will get a kick out of this 🕺
#hairbydyson 😊🙏
@@LeilaGharani Why kick out? Give him a premium !
Also give one to Dyson. He made brilliant outlook of our beautiful teacher!☺
Amazing Leila