Тёмный

How To Create these useful Power Bi Visuals that Excel Lacks 

Leila Gharani
Подписаться 2,7 млн
Просмотров 462 тыс.
50% 1

Опубликовано:

 

27 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 207   
@LeilaGharani
@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
@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
@donnataylor8715
@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
@LeilaGharani Год назад
Thank you for your support, Donna! I hope your students will find the videos helpful.
@ryds2722
@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 😊
@carlaniesen4912
@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. 😊
@andrewcharlesmoss
@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
@LeilaGharani Год назад
👍
@swake1822
@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
@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
@swake1822 Год назад
@@alexgry4763 Good call, I like people to use my reports, not mess about with them 👍
@sakibahmed1815
@sakibahmed1815 Год назад
Would be helpful if you had given the excel file in the description box that you are using to create power bi charts .
@TheSweetMaze
@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
@LeilaGharani Год назад
Glad you like them!
@cvijodubocanin1407
@cvijodubocanin1407 Год назад
This Scatterer over time is a real deal, big boooom. Great video Leila as always, thanks and keep it up.
@sass520
@sass520 Год назад
Excel Is Excel and Power Bi is POWER BI 😇😇
@ExcelTutorials1
@ExcelTutorials1 Год назад
I love the stats at the beginning
@skirolf
@skirolf Год назад
Great video. I suggest you make a video of presenting. I have noticed 98% of all videos on RU-vid 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.
@vijayarjunwadkar
@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
@LeilaGharani Год назад
Yay, thank you Vijay. Looking forward to seeing you inside the course!
@samlimam2740
@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.
@bggg1
@bggg1 Год назад
You are the reason of my promotion! I love you! ❤
@sonia25266
@sonia25266 Год назад
This is so informative. As always, you provide excellent content! Thanks for sharing!
@makarand1985
@makarand1985 Месяц назад
Great Video Leila !!!
@diegobevilacqua4391
@diegobevilacqua4391 Год назад
Fantastic! The last visual for me is more interesting!
@JahongirJalilov-c8k
@JahongirJalilov-c8k 6 месяцев назад
Hi Leila. Thank you so much I get much information about Power BI.
@think3technology640
@think3technology640 Год назад
Last one is more informative visual!!!
@fluffybasket5674
@fluffybasket5674 Год назад
Super impressed with these visuals that I never dared trying out for my models. Thanks for sharing!
@taizoondean689
@taizoondean689 Год назад
Thank you ma'am 🙏🙏 please keep posting videos of Power BI
@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.
@abdulsaidmkamara7305
@abdulsaidmkamara7305 Год назад
Lovely !! That Decomposition tree can be an extremely powerful tool for finance performance analysis and measurement in finance and management accounting spaces.
@LeilaGharani
@LeilaGharani Год назад
Absolutely!
@mohitupadhayay1439
@mohitupadhayay1439 Год назад
Would love to see your DAX playlist on power BI
@mahaboobkhan7439
@mahaboobkhan7439 Год назад
Great and very useful presentation. Thank you for this.
@smbsid
@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
@LeilaGharani Год назад
Awesome! Thank you!
@wodibalanakassoukpala2472
@wodibalanakassoukpala2472 Год назад
Got more information about the use of Decomposition tree. Thanks
@tomr9969
@tomr9969 Год назад
This was great! Infographics are amazing! I am going to try it now!
@sheebanishat
@sheebanishat Год назад
Thanks for the video. I’ve enrolled in your PowerBI course and I’m enjoying it.
@LeilaGharani
@LeilaGharani Год назад
Great to hear!
@VeganSmasher
@VeganSmasher Год назад
Fantastic video that was easy to follow and sparked a lot of interesting Power BI ideas I want to try. Thank you!
@reenamohanta2994
@reenamohanta2994 Год назад
I admire you a lot .... you teach us so many cool stuffs ...
@SetYourBarTo10
@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.
@Mr.Nichols
@Mr.Nichols 10 месяцев назад
That intro had me H Y P E. Let's GOOOO #DataFam📈📈
@muhammedabdulkareem7111
@muhammedabdulkareem7111 Год назад
Thank you for dropping this
@modalities
@modalities Год назад
A highly valuable knowledge share. Thank you!
@aydoganilhan1
@aydoganilhan1 Год назад
Great to know all these, thanks from the heart!
@Rice0987
@Rice0987 Год назад
2:58 I like how add runs away from mouse cursor. And your hair today are absolutely stunnig!🤩
@LeilaGharani
@LeilaGharani Год назад
Haha, thanks for noticing. My video editor will get a kick out of this 🕺 #hairbydyson 😊🙏
@Rice0987
@Rice0987 Год назад
@@LeilaGharani Why kick out? Give him a premium ! Also give one to Dyson. He made brilliant outlook of our beautiful teacher!☺
@ajibolamoromoke8640
@ajibolamoromoke8640 Год назад
Thank you
@srininsmp
@srininsmp 10 месяцев назад
Thank you really usefull
@alexanderlawrence7707
@alexanderlawrence7707 Год назад
New tips to excel in Excel... thanks 👌🏼❤
@LeilaGharani
@LeilaGharani Год назад
Most welcome!
@cerealport2726
@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
@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.
@pondyanand
@pondyanand Год назад
Great content as always ! Thanks.
@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 Год назад
It really is a power tool. Hope to see you soon inside the course!
@brianbaheramouzegarletsbui6533
Great work, again, Leila. Thank you!
@Bhavik_Khatri
@Bhavik_Khatri Год назад
Excellent tutorial.
@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.
@nanettereyes
@nanettereyes Год назад
You're simply amazing!
@Otis151
@Otis151 10 месяцев назад
I'm really interested in using a Sankey Diagram, but i dont understand how to do multiple layers.
@learnexcelwitht
@learnexcelwitht Год назад
Absolutely fantastic
@giorgidvali951159
@giorgidvali951159 Год назад
Always usefully and helpfully video from you, thank you very much
@LeilaGharani
@LeilaGharani Год назад
You are most welcome, Giorgi!
@lucasguidi
@lucasguidi Год назад
Can I edit the "play axis"? The idea is great, but it's too big in the top right corner.
@KurtSelden
@KurtSelden Год назад
Thanks!
@LeilaGharani
@LeilaGharani Год назад
Thank you, Kurt!
@MarinaV-P
@MarinaV-P Год назад
Thank you sooo much!!!
@nigelcole225
@nigelcole225 11 месяцев назад
Superb - thank you
@mehranofff
@mehranofff 7 месяцев назад
Thank you Leila, a question about AI plots, if the AI picks gender first for example, is it gonna change overtime when we feed in new data? I mean is it gonna dynamically and automatically pick another category based on newly added data? (assuming the new data actually have changed the importance of first category) Hope I could explain my question correcly 😅
@yulinliu850
@yulinliu850 Год назад
2M subscribes soon 👍
@nielsduursma1684
@nielsduursma1684 Год назад
Which measure have you added to profit, to use it in the decomposition tree?
@pthapa55
@pthapa55 Год назад
Awesome tips, thank you!
@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?
@sayedhofiani8041
@sayedhofiani8041 Год назад
awesome content leila
@mandarbivalkar1
@mandarbivalkar1 Год назад
Madam... kindly design a video of how to add excel file or csv file to data base ...
@FaysalEasyExcel
@FaysalEasyExcel Год назад
wonderful. this is amazing.
@pedrofontes22182
@pedrofontes22182 10 месяцев назад
Hi Leila! I was using the decomposition tree as a complement to Drill-Through capability. But what I notice is that when I go back to the initial page, change selection and go to the drill-through again, the "scenario" in the drill-through headers continues to appear the same even if the figures in the tree are ok. This happens up until I start clicking through the decomposition tree and then the scenario in the header of the visualisation gets updated... any idea why? Thanks!
@RZing
@RZing Год назад
Will the Power BI on Udemy soon? Thank you!
@dennyjeff1248
@dennyjeff1248 3 месяца назад
how to show the work flow system in power BI... its like a visio data visualizer
@fivetimesyo
@fivetimesyo Год назад
10:26: Leila: "It just takes two minutes." You underestimate my clumsy...
@JoelHernandez-vs1kn
@JoelHernandez-vs1kn Год назад
Gracias
@rahamatmadarangi
@rahamatmadarangi Год назад
Is there a way where we can add the data for pervious year and the current year next to that and also need to see the month header to me static
@philippepierre2954
@philippepierre2954 Год назад
Hi Lela, @9:18, why did you choose 1 as the maximum value? Thank 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
@sk3ffingtonai
@sk3ffingtonai Год назад
"4 Stunning Visuals?" 5.
@birasafabrice
@birasafabrice Год назад
this is so informative, thanks a lot!
@LeilaGharani
@LeilaGharani Год назад
Glad you enjoyed it!
@hemvaidya
@hemvaidya Год назад
blessed to learn
@Listen2urInnerVoice
@Listen2urInnerVoice Год назад
Hi i am looking to add greater than and equal to symbol in power bi as single character.help me locating it
@swake1822
@swake1822 Год назад
Must be your 80% that I'm coming back for all the time! 😉
@charlesrooks7769
@charlesrooks7769 Год назад
Hi Leia, I had a challenge recently where I manually created a report in Powerpoint (from a template) and adjusted the shapes to represent the data points for the column chart. In my exuberance to show off my skills, I made the data points overlap and blend into each other, using transparency to create a visually stunning effect. My customer loved it and wanted it as part of their monthly reports. This took 2 hours to do one chart, and I was not willing to put myself through that every month. Therefore I challenged myself to re-create this report in Excel, however I have never seen that effect before, and infact I could not find anyone online who had doen this before. I spent a few hours thinking it through and came up with a unique way to get this effect. Hit me up if you are interested in seeing the results.
@kedharreddy3824
@kedharreddy3824 Год назад
yes please
@charlesrooks7769
@charlesrooks7769 Год назад
@@kedharreddy3824 I can send you a sample if you like
@kedharreddy3824
@kedharreddy3824 Год назад
@@charlesrooks7769 yes thank you
@charlesrooks7769
@charlesrooks7769 Год назад
@@kedharreddy3824 Where do you want me to send it to?
@kedharreddy3824
@kedharreddy3824 Год назад
@@charlesrooks7769 you can send here the link
@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! :)
@flourishwithMJ
@flourishwithMJ Год назад
thank you.
@MrLausell
@MrLausell Год назад
Excellent!
@alexgry4763
@alexgry4763 Год назад
Combine decomposition tree with a SWITCH-imbued measure to get the ultimate Power BI visual. This will allow users to select which function the tree is breaking down:. For ex: revenue, sales volume, budget variance and such.
@LeilaGharani
@LeilaGharani Год назад
Love it! Thanks.
@katherinewheeler3114
@katherinewheeler3114 Год назад
Please show us how to set up the excel sheets for this. It is easy to pick items on the data to fill in the available fields to make a chart. It is not easy to set up the excel sheet appropriately in order to make all of this work in the first place.
@J2LO
@J2LO 10 месяцев назад
Girl can u show how to do NSR vs BP be PY based on Producs..
@ReactionSquad158
@ReactionSquad158 6 месяцев назад
Laila you are best
@JamesWileyCPA
@JamesWileyCPA Год назад
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 !!
@LeilaGharani
@LeilaGharani Год назад
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 RU-vid sometimes they go under :)
@christinebodge7568
@christinebodge7568 Год назад
Awesome
@albert4491
@albert4491 Год назад
Hey, Leila! Waiting for the scripts course! Will this be made available on udemy? :)
@hermanbroeckx8329
@hermanbroeckx8329 Год назад
Amazing Leila
@valerdonca5694
@valerdonca5694 Год назад
I can't change shapes. I dont have mark designer. Why?
@georgevpopescu2421
@georgevpopescu2421 Год назад
Why not sharing the raw data as well? Can’t see much if underlying data base is not shown (
@aymanraouf1820
@aymanraouf1820 Год назад
I wonder if I can use this to analyse cash flow financial statements directly from Yahoo finance? Or even Income statements. Is it possible to import the financial data from the Yahoo finance and convert it to this?
@saqibriaz1373
@saqibriaz1373 Год назад
You can use an internet link as well when you click on the get data option. Give it a try.
@brainiacnetwork
@brainiacnetwork Год назад
i dont know if you can help me fix this any time i am analyzing a data about nigerian states using maps on power bi it goes outside the given country, meaning lengend for adamawa state in nigeria shows in cameroon.
@hindyal_masaeed4480
@hindyal_masaeed4480 11 месяцев назад
for gender chart, can i make each part of it have a different color
@PONCEJE
@PONCEJE Год назад
I love her
@alfiedavid1135
@alfiedavid1135 Год назад
love it!
@mail2mazhar
@mail2mazhar Год назад
Cool charts explained in short video !
@shahabband3360
@shahabband3360 Год назад
Hi Leila. Is there any way to integrate PBI to excel or word file?
@shivabalan3255
@shivabalan3255 Год назад
Hello mam in Excel ( if condition in that logical value contain text i want return true value as a color cell )ex : when I am putting a text in a cell i need a color in another cell, is this possible kindly reply mam
@AugustinaEjim
@AugustinaEjim 9 месяцев назад
@ Leila, I love your imported gender visuals. thanks
@arturo8524
@arturo8524 Год назад
Where did you get the unisex svg file? I was trying to use some images *.svg but getting the error Upload_SVGImageInsteadOfShape
@timbrykkk
@timbrykkk Год назад
I'd be watching this even if I didn't have a crush on You, miss!
Далее
You Won't Believe These Crazy PIVOT TABLE Hacks!
11:30
Просмотров 703 тыс.
Should You Learn Power Bi? Everything You Need To Know
9:07
Power BI Tips and Tricks
16:21
Просмотров 221 тыс.
AI Tool That Creates Dashboards in Minutes for Free
9:44
Excel Time-Savers - 5 Hidden Features for Busy People
14:24