I love data visualization. I've been working with Power BI by 4 years and still enjoy it.
@LeanExcelSolutions
2 жыл бұрын
Great to hear!
@warisahrari
2 жыл бұрын
What is the first thing you do when a data is given to you? (Asking for Help)
@ykmahi7025
2 жыл бұрын
kzitem.info/news/bejne/p2h9v2mLZqeHm34
@Saraliese
Жыл бұрын
What is your job?
@paramuhari5367
Жыл бұрын
Hi bro any job vacancy available kindly let me know i love power bi
@Sadakti
Жыл бұрын
You are a Pro really... The way you made the background shows intensive level of planning and smartness , I am very delighted I got this channel here . Your work and arrangements, are - something I should admire and say thanks for this marvelous video really.
@LeanExcelSolutions
Жыл бұрын
Thank you so much for your appreciation 😀
@edwinjonah
2 жыл бұрын
I already know how to use PowerBI, but I found this video very satisfying to watch, keep it up!
@LeanExcelSolutions
2 жыл бұрын
Much appreciated your kind words. Thank you!
@sivaramkodali1
2 жыл бұрын
I bought the file for $5 But learned $5000 worth of course. Thank you so much
@LeanExcelSolutions
2 жыл бұрын
Much appreciated
@eduardodiniz7303
Ай бұрын
That sound in the background reminded me of The Sims. Thank you for sharing this!
@bhavinitanna1925
2 жыл бұрын
Thank you so much for sharing this. I made dashboard through this quick video. Continue making such videos on power bi and excel dashboards
@LeanExcelSolutions
2 жыл бұрын
Thanks 🙏
@duong.21
5 ай бұрын
your instruction is very helpful, thank you!
@LeanExcelSolutions
5 ай бұрын
Glad to hear that 😊
@Ayotundejerry
Жыл бұрын
Concise, to the point and very helpful. You just gained a new subscriber.. Thank you
@LeanExcelSolutions
Жыл бұрын
Thank you very much! 😊
@mahmoudarafa8905
2 жыл бұрын
great, We need more about Power Bi
@LeanExcelSolutions
2 жыл бұрын
Yes, sure!
@swastiktripathy8412
8 ай бұрын
Nicely explained. Helpful for beginners to prepare dashboard.
@LeanExcelSolutions
8 ай бұрын
Happy to hear that 😊 Thank you!
@santossantos8522
2 жыл бұрын
OMG, awesome!!!! Even without fluent english I saw that I can learn. thank you very much for share your knowledge.
@LeanExcelSolutions
2 жыл бұрын
Thank you for appreciation 😊
@ykmahi7025
2 жыл бұрын
kzitem.info/news/bejne/p2h9v2mLZqeHm34
@kanjoostube631
2 жыл бұрын
Thank you very much. Awesome tutorial with well explanation.
@LeanExcelSolutions
2 жыл бұрын
Thanks!
@ykmahi7025
2 жыл бұрын
kzitem.info/news/bejne/p2h9v2mLZqeHm34
@MKENAWI
2 жыл бұрын
This is a very useful one.... I have shared it in LinkedIn
@LeanExcelSolutions
2 жыл бұрын
Thank you,😊🙏
@SM-Learner
7 ай бұрын
Thanks for sharing all the tips and tricks!
@LeanExcelSolutions
7 ай бұрын
👍
@COOKINGBIRD
4 ай бұрын
I really appreciate the video you shared! Thanks a lot! 🎥😄
@LeanExcelSolutions
4 ай бұрын
My pleasure 😌
@ExcelTechhfreeExcelTraining
7 ай бұрын
Really amazing vedio. You are excellent nice explanation. Working style really appreciated 👌
@LeanExcelSolutions
7 ай бұрын
Thank you so much for the appreciation 😊
@iwop6122
2 жыл бұрын
All clear, in a simple way
@LeanExcelSolutions
2 жыл бұрын
🙏 Thanks!
@RasithaAbayakoon
8 ай бұрын
Thanks, it is a concise elaboration, superb
@LeanExcelSolutions
8 ай бұрын
😊
@sjvvill7100
2 жыл бұрын
seamless! thank you. kindly upload more vids.
@LeanExcelSolutions
2 жыл бұрын
Thank you, I will
@ykmahi7025
2 жыл бұрын
kzitem.info/news/bejne/p2h9v2mLZqeHm34
@fg0611
2 жыл бұрын
Amazing job! Thank you very much. I did my second pbix dashboard file with your tutorial it help me a lot!
@LeanExcelSolutions
2 жыл бұрын
Well done & thank you for appreciation!
@alimaatouk2424
2 жыл бұрын
Hi Francisco, do you mind sharing your project? I'm facing some issues.
@pantomima5841
2 жыл бұрын
Super job. Would like to see a Financial Analysis project too. Thank you.
@LeanExcelSolutions
2 жыл бұрын
Thank you so much!😊 Sure will work on financial project too!
@ykmahi7025
2 жыл бұрын
kzitem.info/news/bejne/p2h9v2mLZqeHm34
@sivamagesh
2 жыл бұрын
Excellent video. Short and sweet. Please give us more design tips i.e theme colours, how to PowerPoint design.
@LeanExcelSolutions
2 жыл бұрын
👍
@ykmahi7025
2 жыл бұрын
kzitem.info/news/bejne/p2h9v2mLZqeHm34
@ravsingh1576
2 жыл бұрын
Great Power BI videos. They are really helpful and interesting to watch. Thank you for sharing
Thanks! That's right. Did I mentioned something wrong?
@rohail260
2 жыл бұрын
@@LeanExcelSolutions I am not sure because I am learning Power BI from your amazing videos...but at 4:02 when I tried your calculation for Profit = SUM ([Total Selling Value]) - SUM (Total Buying Value]) I was getting same values for alllll entries in this new column (Profit) . So I changed it to [Total Selling Value] -[TotalBuying Value] . btw thank you so much for your videos..I have never learned so much in such short time
@julessiby9834
8 ай бұрын
Thank you for the video. I had a small question: How do I proceed if I remove all filters and want my cards and visuals to display data for the last month instead of the cumulative data for the entire year ?
@Troublesolver123
2 жыл бұрын
But it is not adaptive, right? What will happen if I open it on a smartphone?
@tambao5883
3 ай бұрын
Thanks a lot for your instruction, btw can you share about the color pallets that you applied for Power BI? I dunno how to choose color wisely to apply for each background. Thanks.
@enprincegoode3341
2 жыл бұрын
clear instruction and really learn a lot from the video.thank you!
@LeanExcelSolutions
2 жыл бұрын
Glad it was helpful!
@ykmahi7025
2 жыл бұрын
kzitem.info/news/bejne/p2h9v2mLZqeHm34
@EliiBarbosa4
2 ай бұрын
Muito obrigadoooooo😊😊😊❤🎉
@LeanExcelSolutions
2 ай бұрын
Most welcome 🤗
@Natarajan-ut8rk
6 ай бұрын
I have a doubt mam , I wants to know what are the contents that needs to be analyse and visualize from the data in power bi
@mrJay9205
7 ай бұрын
Seriously amazing ❤ I watched this video at speed of 0.75 😂
@LeanExcelSolutions
7 ай бұрын
Thank you 👍
@atjjr
2 жыл бұрын
Hi . Profit margin . i d have said profit divided by sales(or sum of total selling value ....but i believe you said profit /sum(total buying value)... thats mark up at 4:22
@LeanExcelSolutions
2 жыл бұрын
Yes, thanks for correction. I didn't noticed that & I think that was the mistake!
@Web3girly
Жыл бұрын
Love your work but please slow Down a bit
@LeanExcelSolutions
Жыл бұрын
Sure, thanks!
@rubenbasco7554
Жыл бұрын
very informative, pushes me to learn more..
@LeanExcelSolutions
Жыл бұрын
Glad to hear that! Thank you :)
@Datallanalysis
2 жыл бұрын
there is something wrong when you calculate profit % you should calc profit / total sales not buying and thank you for your efforts
@LeanExcelSolutions
2 жыл бұрын
Ok, will check
@BlessedNumbers
2 жыл бұрын
Great content, keep posting
@LeanExcelSolutions
2 жыл бұрын
Thank a lot! Definately, will add more!
@SubhranshuSekharJena
Жыл бұрын
One more problem I have faced in this background is when I'm going to convert IN pdf by export pdf it is disappearing the background so what to do in such case Plss reply. And this video is really awesome I have also shared with my several friends.
@LeanExcelSolutions
Жыл бұрын
Thank you for your appreciation! At my end, the export to PDF option appears to be working; however, I am not sure why it is not working at your end. Please try printing (Ctrl+P) and saving it as a PDF.
@waldoh
Жыл бұрын
Upload your pbix file to power bi service and share the link free. See in youtube how do that
@SubhranshuSekharJena
Жыл бұрын
@@LeanExcelSolutions thank you so much
@SubhranshuSekharJena
Жыл бұрын
@@waldoh thank you so much
@GameHub999
Жыл бұрын
Thanks for this tutorial and source files 😃
@LeanExcelSolutions
Жыл бұрын
You're welcome 😊
@davidcampos5998
24 күн бұрын
Can I use this model for everyday report sales? 😮
@HarshaVardhan-mb1qw
2 жыл бұрын
The video is very good informative and I subscribed too also but the real time work also same like this?
@LeanExcelSolutions
2 жыл бұрын
Yes, absolutely
@ryandconan
Жыл бұрын
can I put power BI into a website so everyone can access it?
@garciavher2303
2 жыл бұрын
Kindly provide a step by step for creating the template background that will be using in POWER BI dashboard or maybe a link. Thank You
@LeanExcelSolutions
2 жыл бұрын
Hi, it is explained step by step in Excel dashboard version (please watch sales dashboard in Excel tutorial) & also link to download background image is in the description!
@TIPPAVARAMMAHENDER-wq3nx
Жыл бұрын
Please share the data set link.
@LeanExcelSolutions
Жыл бұрын
Hi, it's already there in the description.
@RobertHorvat93
7 ай бұрын
Hey friend what software program do you use to record what you do on PC screen and also to talk to and also save in video format ?
@davibarbutti5813
5 ай бұрын
What a great video!
@LeanExcelSolutions
5 ай бұрын
Thanks 😊
@CruelViper88
Жыл бұрын
I tried it...but it seems Power Bi only reads data in columns. Need to create a new tab in my file to flip my rows and columns and into a table. I mean my own datasheet that is made for ppl to enter values.
@Roadmanshy
Жыл бұрын
Hey any chance you can share the powerpoint format of the background image ?
@sjvvill7100
2 жыл бұрын
if i may can you please share to us the power point file where the background and colors
@LeanExcelSolutions
2 жыл бұрын
Hi, added background image download link in description.
@syazwanimustaffa8985
Жыл бұрын
great video! love it. i have a question. at 5:34 when i try to add the total selling value. why did my power bi change it to ''sum of total selling value''. i try to delete/choose only for ''total selling value'' but the option isn't there. How do i solve this? please help me 😭
@abhishekkumarsingh3289
Жыл бұрын
Right click on the Sum of total selling and select don't summarise. Power BI by default consider take aggregate value for numeric column.
@sanskritibokde
Жыл бұрын
@@abhishekkumarsingh3289there is no option like don't summarise
@Wissou_
9 ай бұрын
When I merge the two tables there are columns who have the "value" : null. I don't know how to fix this, since the two tables don't have the same number of lines ? Can someone please explain to me what iam doing wrong
@vasimishaq9419
2 жыл бұрын
Hi i installed mysql connector and also install odbc connector but till power bi showing error connector need one or more components.... Error. I have 64 bit system plz help me in this. Thank you
@brendamg7298
2 ай бұрын
Thank you!!
@LeanExcelSolutions
2 ай бұрын
Most welcome
@Mo0n_river
2 жыл бұрын
Great video. thank you
@LeanExcelSolutions
2 жыл бұрын
Most welcome!
@vadiyarhemadri1903
2 жыл бұрын
excellent mam its like amazing thanks for your support
@LeanExcelSolutions
2 жыл бұрын
Thanks and welcome! 😊
@waelodat7258
Жыл бұрын
Very informative! Thank you
@LeanExcelSolutions
Жыл бұрын
Most welcome!
@indianlocal9990
6 ай бұрын
very good video but background music is dominating cannot concentrate what you are telling i have reversed many times thank you for video
@kiba6634
2 жыл бұрын
Thanks for this tutorial. my dashboard looks amazing. However I have a problem, when i change computer with a smaller screen the background doesn't feet anymore. Do you have any solution to fix this issue?
@ykmahi7025
2 жыл бұрын
kzitem.info/news/bejne/p2h9v2mLZqeHm34
@lyubimayadorama
2 жыл бұрын
my teacher also told me to work on this program but it is very difficult😭
@LeanExcelSolutions
2 жыл бұрын
😂 Thank you for the comment, but it is not that much difficult, if you know power BI little bit!
@lyubimayadorama
2 жыл бұрын
@@LeanExcelSolutions but I don't know🤣
@manhaabdellah3474
Жыл бұрын
amazing very easy to understand!
@LeanExcelSolutions
Жыл бұрын
Thanks 👍
@verra4343
Жыл бұрын
Thank you so much! Really great work!!
@LeanExcelSolutions
Жыл бұрын
Glad you like it!
@amirasobhy1809
2 жыл бұрын
Please, why are you using the average profit inside total profit? and the average profit percentage inside the total profit percentage?
@LeanExcelSolutions
2 жыл бұрын
Hi, I think for both total profit & percentage, I have used sum only, not average.
@amirasobhy1809
2 жыл бұрын
Thank you
@imamsibromuhlisi1520
Жыл бұрын
This is so good. Thank you!
@LeanExcelSolutions
Жыл бұрын
You're welcome! 😊
@omprakashthakur4515
2 жыл бұрын
Hello sir can I get all dashboard data folder or file link.tq sir
@LeanExcelSolutions
2 жыл бұрын
Hi, the link to download the input data sheet is in the description.
@nasroddinemansour9865
Жыл бұрын
how to get this file, because didn't exist in the link, and thanks
@malikumberhina2839
Жыл бұрын
You cannot select 'list' and other options in the latest Power BI. How to go about it, please?
@LeanExcelSolutions
Жыл бұрын
Hi, do you mean the Slicer List?
@leonardobevilacqua5988
Жыл бұрын
Is the free version fully functional? Thanks
@lazzybear_
Жыл бұрын
thank you but may i know one thing the data you shows in the starting so that means we only need these informations in power bi if we are creating sales dashboard please answer because i always get confused here
@LeanExcelSolutions
Жыл бұрын
Hi, you can download the data file I mentioned at the beginning. Link is in the description to download. I already have covered this data file explanation in the earlier Sales Dashboard in Excel tutorial. That's why I skipped it here, you may watch that too for more details.
@LeanExcelSolutions
Жыл бұрын
And that is the only data you need to create this dashboard
4 ай бұрын
Amazing!
@LeanExcelSolutions
4 ай бұрын
Thank you 😊
@renanfviegas
Жыл бұрын
beautiful but no answers for my ops. nothing that I already would know.
@imtiazahmed3222
Жыл бұрын
Hey, please use a cursor highlighter because its very difficult to follow/find on what you clicking since the video/ you are doing it quite fast
@LeanExcelSolutions
Жыл бұрын
Sure, will take care of that
@mariaceverichemarin5165
Жыл бұрын
Where Can I find those backgrouns
@lukmanadamu5778
Жыл бұрын
How do I get the dataset, to practice?
@LeanExcelSolutions
Жыл бұрын
The link is in the description to download it.
@muhammadyaseenmengal4322
2 жыл бұрын
cool, can you please share the excel sheets used ................Thank you for sharing
@LeanExcelSolutions
2 жыл бұрын
Thanks, the link to download the Excel sheets used in the description. You can download it from there.
@harshjain6042
2 жыл бұрын
Doubt: how can I calculate top product, I am using Card but there is no filter of top N things.
@ykmahi7025
2 жыл бұрын
kzitem.info/news/bejne/p2h9v2mLZqeHm34
@Megtheanalyst_
2 жыл бұрын
Hello, Kindly Help With The Sales Data Used For This Project
@LeanExcelSolutions
2 жыл бұрын
Hi, the link is in the description to download practice file. Thanks!
@Megtheanalyst_
2 жыл бұрын
@@LeanExcelSolutions Seen…. Not Free? Must Be Paid For?
@LeanExcelSolutions
2 жыл бұрын
@@Megtheanalyst_ data file is free there
@thuyazaw1366
2 жыл бұрын
I can't open the Common Practice file in excel.
@shotforyou
2 ай бұрын
Why show my project in Propertice ="This setting has moved.To Change the slicer style ,select Format>Slivcer setting >Options>Style."
@LeanExcelSolutions
2 ай бұрын
This project was completed in an older version of Power BI. Now the slicer option settings location have been changed.
@khaled23011
Жыл бұрын
nice review keep up !! plz share the dataset i cant acces from the decription
@LeanExcelSolutions
Жыл бұрын
Thank you :) Here is the link to download the practice file: leanexcelsolutions.com/wp-content/uploads/2022/04/Sales-Dashboard-practice-file.xlsx
@PennyTrow
7 ай бұрын
@@LeanExcelSolutions Hi, this link is not working anymore. Could you upload once again please?
@LeanExcelSolutions
7 ай бұрын
Hi, I just checked it & it is working 🙂
@PennyTrow
7 ай бұрын
@@LeanExcelSolutions hmm when I click on the link I get thousands of weird signs like:"PK�����!�KªN-†��Œ���[Content_Types].xml ¢( ���������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������ÄUÉnÂ0...." This is how it should look like? :D If yes, what I should do with it?
@idolsensei7
2 жыл бұрын
Hi, Thanks for sharing this. I do have one question or a sample based from the dashboard you have shown. Let's say in the month slicer I chose Jan and in the year slicer to 2022. In the bar graph visual, I wanted to show the 12 month roll of data so technically, what I wanted to show in there will be from Jan 2021 until Jan 2022 only. For the card visuals, in here it will only show the Jan 2022 data since that is what I've chosen in the slicer. May I ask how we can achieve that in one sheet. Or maybe you have a video tutorial on that? Thanks
@MultiPrashantmishra
2 жыл бұрын
According to me, you can use a slicer in different ways. Simply you need to select slicer and put the date in a field where you will get an option to select a date range. It will work for you. Please let me know does it works for you or not. 😊
@ykmahi7025
2 жыл бұрын
kzitem.info/news/bejne/p2h9v2mLZqeHm34
@henryworgu8855
2 жыл бұрын
Great video but a little too fast to follow by beginners.
@LeanExcelSolutions
2 жыл бұрын
Thank you so much for your appreciation! Yes, it fast for beginners. I am trying to keep it slower for new videos.
@hassanali7763
2 ай бұрын
Nice
@LeanExcelSolutions
2 ай бұрын
Thanks 👍
@hozifah8
2 жыл бұрын
at 3:26 when i do the same measure the app show message "A single value for column 'QUANTITY' in table 'InputData' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as ...etc" how can i solve this i hope u read my comment
@srikanthkalluri318
2 жыл бұрын
Use ADD NEW COLUMN instead of NEW MEASURE, bcoz Measure needs to start with aggregated function
@KaleemUllah-qi7hf
2 жыл бұрын
I love you wala thank you 😅😅😅😅
@LeanExcelSolutions
2 жыл бұрын
😃😍
@RhitikGaur
7 ай бұрын
Please provide the link of the dataset
@LeanExcelSolutions
7 ай бұрын
Hi, it's already there, the link is in the description to download it.
@thoruain
Жыл бұрын
i love it
@LeanExcelSolutions
Жыл бұрын
Glad to hear that! 😊
@prasadplk90
9 ай бұрын
How to implement temple
@justdrawit3038
2 жыл бұрын
Awesome video! Thanks for the uploading! But, the title is misleading - isn't that a Power BI report other than a dashboard?
@xhyhbdka
2 жыл бұрын
How do you differentiate the 2? :)
@LeanExcelSolutions
2 жыл бұрын
🤔 Sorry, I don't get it!
@miaberenyi5398
2 жыл бұрын
It is a report indeed. But if you have pro or premium you can turn it into a dashboard.
@LeanExcelSolutions
2 жыл бұрын
Yes, thanks!
@onurerdogan6725
2 жыл бұрын
hey amazing video. Can you share pptx document
@LeanExcelSolutions
2 жыл бұрын
Thanks, the link to download the background image is in the description. Will share the pptx file soon!
@onurerdogan6725
2 жыл бұрын
Share please :)
@TheJ3YA
2 жыл бұрын
@@LeanExcelSolutions Hi There, have you shred the pptx link ?
@mohamedkadry2125
Жыл бұрын
how can i download the dashboard
@zillehuma4244
Жыл бұрын
How l start only dash board
@abhijit2810
Жыл бұрын
Please upload data link
@LeanExcelSolutions
Жыл бұрын
It is already there in the description
@zillehuma4244
Жыл бұрын
Assalamaalikum sir
@joshuajato3878
11 ай бұрын
Nice video. But you're too fast. Finding it really hard to follow. 😅
@LeanExcelSolutions
11 ай бұрын
Thanks for the feedback. Yes it is too fast. It is one of the initial videos & I was trying to keep as short as possible.
@faizasajid7831
10 ай бұрын
You can slow down speed from settings
@mrJay9205
7 ай бұрын
I did the same 0.75 speed is perfect
@jacobs4985
2 жыл бұрын
hello! is there any way that I can get the power point file? I may need to adjust some of the things in the background
@LeanExcelSolutions
2 жыл бұрын
Hi, You can download it from store. Link is in the description.
@jacobs4985
2 жыл бұрын
@@LeanExcelSolutions hi! i only saw the background image not the power point. I want to modify something
@orahrobinsondavidfriday1272
2 жыл бұрын
Can we get the dataset you used
@LeanExcelSolutions
2 жыл бұрын
Hi, it is already there. Please check the video discription, you can find link to download it.
@dsahera
Жыл бұрын
what is the dimension of this dashboard ?
@LeanExcelSolutions
Жыл бұрын
16:9, (1920:1080) the default power bi canvas size
@ankushjain313
2 жыл бұрын
Please give us background design video link
@LeanExcelSolutions
2 жыл бұрын
Hi, it's in the "Sales dashboard in Excel" video. Here is the link for it kzitem.info/news/bejne/w6CCr3Vnr4Wieqg
Пікірлер: 247