How To Create these useful Power Bi Visuals that Excel Lacks

Рет қаралды 442,268

Күн бұрын

👉 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

Пікірлер: 206

@LeilaGharani Жыл бұрын

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.

@stevenisaakcoronadohs4256 Жыл бұрын

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

@salembalkhair9656 Жыл бұрын

When can we enroll for the full course

@atabak1972 Жыл бұрын

The quick chart we part in SharePoint is poor

@ryds2722 Жыл бұрын

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 😊

@cvijodubocanin1407 Жыл бұрын

This Scatterer over time is a real deal, big boooom. Great video Leila as always, thanks and keep it up.

@donnataylor8715 Жыл бұрын

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.

@LeilaGharani Жыл бұрын

Thank you for your support, Donna! I hope your students will find the videos helpful.

@TheSweetMaze Жыл бұрын

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! ❤️

@LeilaGharani Жыл бұрын

Glad you like them!

@fluffybasket5674 Жыл бұрын

Super impressed with these visuals that I never dared trying out for my models. Thanks for sharing!

@samlimam2740 Жыл бұрын

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.

@sonia25266 Жыл бұрын

This is so informative. As always, you provide excellent content! Thanks for sharing!

@SetYourBarTo10 Жыл бұрын

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.

@shadrackawunyo7786 Жыл бұрын

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

@LeilaGharani Жыл бұрын

Yay, that's great to hear Shadrack! See you soon inside the course.

@vijayarjunwadkar Жыл бұрын

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! 👍

@LeilaGharani Жыл бұрын

Yay, thank you Vijay. Looking forward to seeing you inside the course!

@robsonmachado2703 Жыл бұрын

This video is insane! 🤯 Too much Incredible insights. Thanks a lot! Best wishes from Brazil! 🙋🏻‍♂️🇧🇷

@carlaniesen4912 Жыл бұрын

Excellent as usual! Thank you.

@Cheechorito Жыл бұрын

very informational to see all these rarely used features being highlighted!

@andrewcharlesmoss Жыл бұрын

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 Жыл бұрын

👍

@swake1822 Жыл бұрын

@@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

@alexgry4763 Жыл бұрын

@@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

@swake1822 Жыл бұрын

@@alexgry4763 Good call, I like people to use my reports, not mess about with them 👍

@carlaniesen4912 Жыл бұрын

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. 😊

@pondyanand Жыл бұрын

Great content as always ! Thanks.

@brianbaheramouzegarletsbui6533 11 ай бұрын

Great work, again, Leila. Thank you!

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

Hi Leila. Thank you so much I get much information about Power BI.

@martinsmednis5544 3 ай бұрын

Thanks a lot for educating us!🙂

@taizoondean689 Жыл бұрын

Thank you ma'am 🙏🙏 please keep posting videos of Power BI

@diegobevilacqua4391 Жыл бұрын

Fantastic! The last visual for me is more interesting!

@silvestrecamposano6317 Жыл бұрын

Wow... this is what I have been waiting to learn.... Thank you very much again!...

@smbsid Жыл бұрын

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.

@LeilaGharani Жыл бұрын

Awesome! Thank you!

@modalities Жыл бұрын

A highly valuable knowledge share. Thank you!

@pedrofontes22182 Жыл бұрын

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! :)

@muhammedabdulkareem7111 Жыл бұрын

Thank you for dropping this

@mail2mazhar 11 ай бұрын

Cool charts explained in short video !

@SyedMuzammilMahasanShahi Жыл бұрын

Thanks for sharing this wonderful video.

@user-xh8cr9pk5g Жыл бұрын

Excellent Videos. Very professional approach and cystal clear examples. Thanks for this Leila.

@ExcelTutorials1 Жыл бұрын

I love the stats at the beginning

@aydoganilhan1 Жыл бұрын

Great to know all these, thanks from the heart!

@pthapa55 11 ай бұрын

Awesome tips, thank you!

@sheebanishat Жыл бұрын

Thanks for the video. I’ve enrolled in your PowerBI course and I’m enjoying it.

@LeilaGharani Жыл бұрын

Great to hear!

@davestewart1196 Жыл бұрын

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?

@ExcelTutorials1 Жыл бұрын

Thanks for the great tips!!!!

@mahaboobkhan7439 Жыл бұрын

Great and very useful presentation. Thank you for this.

@VeganSmasher Жыл бұрын

Fantastic video that was easy to follow and sparked a lot of interesting Power BI ideas I want to try. Thank you!

@wodibalanakassoukpala2472 Жыл бұрын

Got more information about the use of Decomposition tree. Thanks

@MarinaV-P Жыл бұрын

Thank you sooo much!!!

@tomr9969 Жыл бұрын

This was great! Infographics are amazing! I am going to try it now!

@mikemartin2694 Жыл бұрын

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.

@LeilaGharani Жыл бұрын

Cool, thanks!

@learnexcelwitht Жыл бұрын

Absolutely fantastic

@chiwilanjabulosikwila3487 Жыл бұрын

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.

@LeilaGharani Жыл бұрын

It really is a power tool. Hope to see you soon inside the course!

@nigelcole225 9 ай бұрын

Superb - thank you

@allaboutpakturkeydramas7063 Жыл бұрын

You are too good Leila,Keep it up!Please upload more Power BI videos.

@yourtuber2000 Жыл бұрын

Nice!!! must try! thanks Leila

@aleawolf9848 Жыл бұрын

Your Videos are very helpful! I’m a big fan

@_logicking Жыл бұрын

Gold standard presentation!

@trustnonor5139 Жыл бұрын

Thank you

@chrism9037 Жыл бұрын

Excellent as always, thanks Leila!!

@LeilaGharani Жыл бұрын

Thanks again, Chris!

@AngelloSuarezLovera Жыл бұрын

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 ?

@Bhavik_Khatri Жыл бұрын

Excellent tutorial.

@jasonipfatsiong2062 Жыл бұрын

Very impressive thank you😊

@muralimohan71 Жыл бұрын

Thank you 😊

@thoughtfuldog5424 Жыл бұрын

Brilliant, thanks. Can you provide more videos on the visualisations in PowerBI

@nanettereyes Жыл бұрын

You're simply amazing!

@alexanderlawrence7707 Жыл бұрын

New tips to excel in Excel... thanks 👌🏼❤

@LeilaGharani Жыл бұрын

Most welcome!

@christianwibowo6420 5 ай бұрын

Still The greatest teacher on KZfaq

@GerhardHolzer911 Жыл бұрын

As always - really helpful video with valuable hints ! It’s always a pleasure watching - vielen Dank ☺️

@LeilaGharani Жыл бұрын

Bitteschön 😊

@FaysalEasyExcel Жыл бұрын

wonderful. this is amazing.

@hemvaidya Жыл бұрын

blessed to learn

@abdulsaidmkamara7305 Жыл бұрын

Lovely !! That Decomposition tree can be an extremely powerful tool for finance performance analysis and measurement in finance and management accounting spaces.

@LeilaGharani Жыл бұрын

Absolutely!

@shandor2522 Жыл бұрын

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.

@reenamohanta2994 Жыл бұрын

I admire you a lot .... you teach us so many cool stuffs ...

@bayarri81 Жыл бұрын

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?

@giorgidvali951159 Жыл бұрын

Always usefully and helpfully video from you, thank you very much

@LeilaGharani Жыл бұрын

You are most welcome, Giorgi!

@mohitupadhayay1439 Жыл бұрын

Would love to see your DAX playlist on power BI

@flourishwithMJ 10 ай бұрын

thank you.

@AP-eb8hd Жыл бұрын

This is actually next level stuff... Way too good.. Thanks Leila..

@LeilaGharani Жыл бұрын

My pleasure 😊

@birasafabrice Жыл бұрын

this is so informative, thanks a lot!

@LeilaGharani Жыл бұрын

Glad you enjoyed it!

@georgevpopescu2421 Жыл бұрын

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

@srininsmp 8 ай бұрын

Thank you really usefull

@JoelHernandez-vs1kn Жыл бұрын

Gracias

@MrLausell Жыл бұрын

Excellent!

@prashantpotnis Жыл бұрын

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.

@Khan-mc3gi Жыл бұрын

Wow great job👍

@chh8860 Жыл бұрын

OMG ... yet again (no surprise) another thought-provoking video ... a fast-flowing river of ideas ... 😍😍😍😍

@LeilaGharani Жыл бұрын

Thanks again, Chris!

@sayedhofiani8041 Жыл бұрын

awesome content leila

@alfiedavid1135 Жыл бұрын

love it!

@KurtSelden Жыл бұрын

Thanks!

@LeilaGharani Жыл бұрын

Thank you, Kurt!

@lailapsiqueira Ай бұрын

About the composition three, is there a way to see the values as %%? Thanks for de video!

@skirolf Жыл бұрын

Great video. I suggest you make a video of presenting. I have noticed 98% of all videos on KZfaq 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.

@think3technology640 10 ай бұрын

Last one is more informative visual!!!

@christinebodge7568 Жыл бұрын

Awesome

@vikaasb2016 Жыл бұрын

Super informative ❤!

@LeilaGharani Жыл бұрын

Glad you think so!

@bggg1 Жыл бұрын

You are the reason of my promotion! I love you! ❤

@cerealport2726 Жыл бұрын

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.

@Ronnet Жыл бұрын

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.

@sass520 Жыл бұрын

Excel Is Excel and Power Bi is POWER BI 😇😇

@nielsduursma1684 Жыл бұрын

Which measure have you added to profit, to use it in the decomposition tree?

@moderncollectionkalyan3280 Жыл бұрын

really very nice

@neemaz Жыл бұрын

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.