How To Create these useful Power Bi Visuals that Excel Lacks

Поділитися
Вставка
  • Опубліковано 25 чер 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

КОМЕНТАРІ • 206

  • @LeilaGharani
    @LeilaGharani  Рік тому +12

    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
      @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
      @salembalkhair9656 Рік тому

      When can we enroll for the full course

    • @atabak1972
      @atabak1972 Рік тому

      The quick chart we part in SharePoint is poor

  • @ryds2722
    @ryds2722 Рік тому +14

    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
    @cvijodubocanin1407 Рік тому +1

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

  • @fluffybasket5674
    @fluffybasket5674 Рік тому

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

  • @sonia25266
    @sonia25266 Рік тому +1

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

  • @TheSweetMaze
    @TheSweetMaze Рік тому +1

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

  • @carlaniesen4912
    @carlaniesen4912 Рік тому

    Excellent as usual! Thank you.

  • @Cheechorito
    @Cheechorito Рік тому

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

  • @donnataylor8715
    @donnataylor8715 Рік тому +3

    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
      @LeilaGharani  Рік тому

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

  • @robsonmachado2703
    @robsonmachado2703 Рік тому

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

  • @brianbaheramouzegarletsbui6533
    @brianbaheramouzegarletsbui6533 11 місяців тому

    Great work, again, Leila. Thank you!

  • @taizoondean689
    @taizoondean689 Рік тому

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

  • @pondyanand
    @pondyanand Рік тому

    Great content as always ! Thanks.

  • @diegobevilacqua4391
    @diegobevilacqua4391 Рік тому

    Fantastic! The last visual for me is more interesting!

  • @modalities
    @modalities Рік тому

    A highly valuable knowledge share. Thank you!

  • @muhammedabdulkareem7111
    @muhammedabdulkareem7111 Рік тому

    Thank you for dropping this

  • @SetYourBarTo10
    @SetYourBarTo10 Рік тому +2

    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.

  • @mail2mazhar
    @mail2mazhar 10 місяців тому

    Cool charts explained in short video !

  • @samlimam2740
    @samlimam2740 Рік тому +2

    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.

  • @martinsmednis5544
    @martinsmednis5544 3 місяці тому

    Thanks a lot for educating us!🙂

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi Рік тому

    Thanks for sharing this wonderful video.

  • @pthapa55
    @pthapa55 10 місяців тому

    Awesome tips, thank you!

  • @silvestrecamposano6317
    @silvestrecamposano6317 11 місяців тому

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

  • @pedrofontes22182
    @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! :)

  • @smbsid
    @smbsid Рік тому +1

    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.

  • @aydoganilhan1
    @aydoganilhan1 Рік тому

    Great to know all these, thanks from the heart!

  • @user-io6qo8wq2h
    @user-io6qo8wq2h 3 місяці тому

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

  • @vijayarjunwadkar
    @vijayarjunwadkar Рік тому +1

    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
      @LeilaGharani  Рік тому +1

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

  • @andrewcharlesmoss
    @andrewcharlesmoss Рік тому +5

    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
      @LeilaGharani  Рік тому +2

      👍

    • @swake1822
      @swake1822 Рік тому +1

      @@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
      @alexgry4763 Рік тому +2

      @@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
      @swake1822 Рік тому

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

  • @ExcelTutorials1
    @ExcelTutorials1 Рік тому

    I love the stats at the beginning

  • @wodibalanakassoukpala2472
    @wodibalanakassoukpala2472 Рік тому

    Got more information about the use of Decomposition tree. Thanks

  • @shadrackawunyo7786
    @shadrackawunyo7786 Рік тому +4

    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
      @LeilaGharani  Рік тому +1

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

  • @mahaboobkhan7439
    @mahaboobkhan7439 Рік тому

    Great and very useful presentation. Thank you for this.

  • @carlaniesen4912
    @carlaniesen4912 Рік тому +32

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

  • @user-xh8cr9pk5g
    @user-xh8cr9pk5g Рік тому

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

  • @allaboutpakturkeydramas7063

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

  • @MarinaV-P
    @MarinaV-P 11 місяців тому

    Thank you sooo much!!!

  • @ExcelTutorials1
    @ExcelTutorials1 Рік тому

    Thanks for the great tips!!!!

  • @nigelcole225
    @nigelcole225 8 місяців тому

    Superb - thank you

  • @tomr9969
    @tomr9969 Рік тому

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

  • @_logicking
    @_logicking Рік тому

    Gold standard presentation!

  • @yourtuber2000
    @yourtuber2000 Рік тому

    Nice!!! must try! thanks Leila

  • @ajibolamoromoke8640
    @ajibolamoromoke8640 Рік тому

    Thank you

  • @aleawolf9848
    @aleawolf9848 Рік тому

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

  • @VeganSmasher
    @VeganSmasher Рік тому

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

  • @learnexcelwitht
    @learnexcelwitht Рік тому

    Absolutely fantastic

  • @sheebanishat
    @sheebanishat Рік тому

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

  • @jasonipfatsiong2062
    @jasonipfatsiong2062 Рік тому

    Very impressive thank you😊

  • @Bhavik_Khatri
    @Bhavik_Khatri Рік тому

    Excellent tutorial.

  • @chrism9037
    @chrism9037 Рік тому

    Excellent as always, thanks Leila!!

  • @davestewart1196
    @davestewart1196 Рік тому +2

    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?

  • @chiwilanjabulosikwila3487
    @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
      @LeilaGharani  Рік тому +1

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

  • @muralimohan71
    @muralimohan71 Рік тому

    Thank you 😊

  • @nanettereyes
    @nanettereyes Рік тому

    You're simply amazing!

  • @alexanderlawrence7707
    @alexanderlawrence7707 Рік тому

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

  • @hemvaidya
    @hemvaidya Рік тому

    blessed to learn

  • @prashantpotnis
    @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.

  • @thoughtfuldog5424
    @thoughtfuldog5424 Рік тому

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

  • @GerhardHolzer911
    @GerhardHolzer911 Рік тому

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

  • @FaysalEasyExcel
    @FaysalEasyExcel Рік тому

    wonderful. this is amazing.

  • @mohitupadhayay1439
    @mohitupadhayay1439 Рік тому

    Would love to see your DAX playlist on power BI

  • @AP-eb8hd
    @AP-eb8hd Рік тому

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

  • @christianwibowo6420
    @christianwibowo6420 5 місяців тому

    Still The greatest teacher on UA-cam

  • @flourishwithMJ
    @flourishwithMJ 10 місяців тому

    thank you.

  • @giorgidvali951159
    @giorgidvali951159 Рік тому

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

  • @AngelloSuarezLovera
    @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 ?

  • @sass520
    @sass520 Рік тому +1

    Excel Is Excel and Power Bi is POWER BI 😇😇

  • @bggg1
    @bggg1 Рік тому

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

  • @georgevpopescu2421
    @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
    @srininsmp 7 місяців тому

    Thank you really usefull

  • @shandor2522
    @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
    @reenamohanta2994 Рік тому

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

  • @birasafabrice
    @birasafabrice Рік тому

    this is so informative, thanks a lot!

  • @chh8860
    @chh8860 Рік тому

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

  • @bayarri81
    @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?

  • @MrLausell
    @MrLausell Рік тому

    Excellent!

  • @JoelHernandez-vs1kn
    @JoelHernandez-vs1kn Рік тому

    Gracias

  • @Khan-mc3gi
    @Khan-mc3gi Рік тому

    Wow great job👍

  • @abdulsaidmkamara7305
    @abdulsaidmkamara7305 Рік тому

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

  • @skirolf
    @skirolf Рік тому

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

  • @Mr.Nichols
    @Mr.Nichols 7 місяців тому

    That intro had me H Y P E. Let's GOOOO #DataFam📈📈

  • @mikemartin2694
    @mikemartin2694 Рік тому +1

    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.

  • @think3technology640
    @think3technology640 10 місяців тому

    Last one is more informative visual!!!

  • @alfiedavid1135
    @alfiedavid1135 Рік тому

    love it!

  • @KurtSelden
    @KurtSelden Рік тому

    Thanks!

  • @sayedhofiani8041
    @sayedhofiani8041 Рік тому

    awesome content leila

  • @fivetimesyo
    @fivetimesyo Рік тому

    10:26: Leila: "It just takes two minutes." You underestimate my clumsy...

  • @lailapsiqueira
    @lailapsiqueira 20 днів тому

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

  • @sakibahmed1815
    @sakibahmed1815 Рік тому +12

    Would be helpful if you had given the excel file in the description box that you are using to create power bi charts .

  • @christinebodge7568
    @christinebodge7568 Рік тому

    Awesome

  • @fredericktruter5292
    @fredericktruter5292 Рік тому

    I have completed your free Power BI training a gaint leap for all of us.
    I know this is not your problem, exchange rate, the cost in Big Mac's is 30 for a US citizen for us in Africa 77.5 Big Mac's.

  • @vikaasb2016
    @vikaasb2016 Рік тому

    Super informative ❤!

  • @moderncollectionkalyan3280
    @moderncollectionkalyan3280 Рік тому

    really very nice

  • @chandrakantgaddam3437
    @chandrakantgaddam3437 Рік тому

    God bless you......!!!!!!!🙌

  • @albert4491
    @albert4491 Рік тому

    Hey, Leila! Waiting for the scripts course! Will this be made available on udemy? :)

  • @nielsduursma1684
    @nielsduursma1684 Рік тому

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

  • @hermanbroeckx8329
    @hermanbroeckx8329 Рік тому

    Amazing Leila

  • @konigkakfas3392
    @konigkakfas3392 3 місяці тому

    Danke!

  • @neemaz
    @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.

  • @yulinliu850
    @yulinliu850 Рік тому

    2M subscribes soon 👍