Sales Dashboard in Power BI | Power BI Dashboard

Подписаться 54 тыс.

Просмотров 892 тыс.

50% 1

✔ Download the Excel data file for Practice & dashboard background Image:
leanexcelsolutions.com/sales-...
✔ Download the dashboard & all resource files from the store:
leanexcelsolutions.com/produc...
In this video, it is demonstrated to create a sales dashboard in Power BI. A similar dashboard is created in Microsoft Excel earlier. The link to watch it is provided below.
Sales Dashboard in Excel: • Sales Dashboard in Exc...
Timeline:
00:00 Overview
01:15 Import Data to Power BI
01:52 Edit Data in Power Query Editor
03:02 Create Columns & Measures
04:41 Create Visuals
10:50 Format Dashboard Background
12:09 Format Visuals
Recommended Videos:
✔ Interactive Sales Dashboard for B2C Business: • Sales Dashboard in Exc...
✔ Customer Analytics Dashboard in Power BI: • Customer Analytics Das...
Recommended Playlist:
Stock Portfolio Dashboard: • Share Market Dashboard...
Check the Links:
◼ Channel: / leanexcelsolutions
◼ Website: leanexcelsolutions.com
◼ Facebook: / leanexcelsolutions
◼ Instagram: / leanexcelsolutions
✔ Share this Video:
• Sales Dashboard in Pow...
#powerbi
#powerbitutorials
#powerbidashboard
#dashboard
#leanexcelsolutions
#english

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

19 июн 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 237

@sadakat-arabi Год назад

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 Год назад

I already know how to use PowerBI, but I found this video very satisfying to watch, keep it up!

@LeanExcelSolutions Год назад

Much appreciated your kind words. Thank you!

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

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

@Ayotundejerry 10 месяцев назад

Concise, to the point and very helpful. You just gained a new subscriber.. Thank you

@LeanExcelSolutions 10 месяцев назад

Thank you very much! 😊

@ravsingh1576 2 года назад

Great Power BI videos. They are really helpful and interesting to watch. Thank you for sharing

@LeanExcelSolutions 2 года назад

Glad you like them!

@ykmahi7025 Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-F2GY5U-uVhI.html

@enprincegoode3341 2 года назад

clear instruction and really learn a lot from the video.thank you!

@LeanExcelSolutions 2 года назад

Glad it was helpful!

@ykmahi7025 Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-F2GY5U-uVhI.html

@kanjoostube631 2 года назад

Thank you very much. Awesome tutorial with well explanation.

@LeanExcelSolutions 2 года назад

Thanks!

@ykmahi7025 Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-F2GY5U-uVhI.html

@sivaramkodali1 Год назад

I bought the file for $5 But learned $5000 worth of course. Thank you so much

@LeanExcelSolutions Год назад

Much appreciated

@verra4343 Год назад

Thank you so much! Really great work!!

@LeanExcelSolutions Год назад

Glad you like it!

@ferorozco7547 2 года назад

I love data visualization. I've been working with Power BI by 4 years and still enjoy it.

@LeanExcelSolutions 2 года назад

Great to hear!

@warisahrari Год назад

What is the first thing you do when a data is given to you? (Asking for Help)

@ykmahi7025 Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-F2GY5U-uVhI.html

@Saraliese Год назад

What is your job?

@paramuhari5367 Год назад

Hi bro any job vacancy available kindly let me know i love power bi

@iwop6122 2 года назад

All clear, in a simple way

@LeanExcelSolutions 2 года назад

🙏 Thanks!

@SM-Learner 4 месяца назад

Thanks for sharing all the tips and tricks!

@LeanExcelSolutions 4 месяца назад

👍

@sjvvill7100 2 года назад

seamless! thank you. kindly upload more vids.

@LeanExcelSolutions 2 года назад

Thank you, I will

@ykmahi7025 Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-F2GY5U-uVhI.html

@mahmoudarafa8905 2 года назад

great, We need more about Power Bi

@LeanExcelSolutions 2 года назад

Yes, sure!

@GameHub999 10 месяцев назад

Thanks for this tutorial and source files 😃

@LeanExcelSolutions 10 месяцев назад

You're welcome 😊

@waelodat7258 Год назад

Very informative! Thank you

@LeanExcelSolutions Год назад

Most welcome!

@duong.21 2 месяца назад

your instruction is very helpful, thank you!

@LeanExcelSolutions 2 месяца назад

Glad to hear that 😊

@swastiktripathy8412 5 месяцев назад

Nicely explained. Helpful for beginners to prepare dashboard.

@LeanExcelSolutions 5 месяцев назад

Happy to hear that 😊 Thank you!

@imamsibromuhlisi1520 10 месяцев назад

This is so good. Thank you!

@LeanExcelSolutions 10 месяцев назад

You're welcome! 😊

@julessiby9834 4 месяца назад

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 ?

@BlessedNumbers 2 года назад

Great content, keep posting

@LeanExcelSolutions 2 года назад

Thank a lot! Definately, will add more!

@sivamagesh 2 года назад

Excellent video. Short and sweet. Please give us more design tips i.e theme colours, how to PowerPoint design.

@LeanExcelSolutions 2 года назад

👍

@ykmahi7025 Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-F2GY5U-uVhI.html

@user-vp3cw4uz8g 5 месяцев назад

Thanks, it is a concise elaboration, superb

@LeanExcelSolutions 5 месяцев назад

😊

@COOKINGBIRD Месяц назад

I really appreciate the video you shared! Thanks a lot! 🎥😄

@LeanExcelSolutions Месяц назад

My pleasure 😌

@rubenbasco7554 11 месяцев назад

very informative, pushes me to learn more..

@LeanExcelSolutions 11 месяцев назад

Glad to hear that! Thank you :)

@manhaabdellah3474 Год назад

amazing very easy to understand!

@LeanExcelSolutions Год назад

Thanks 👍

@MKENAWI 2 года назад

This is a very useful one.... I have shared it in LinkedIn

@LeanExcelSolutions 2 года назад

Thank you,😊🙏

@pantomima5841 Год назад

Super job. Would like to see a Financial Analysis project too. Thank you.

@LeanExcelSolutions Год назад

Thank you so much!😊 Sure will work on financial project too!

@ykmahi7025 Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-F2GY5U-uVhI.html

@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 Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-F2GY5U-uVhI.html

@Mo0n_river Год назад

Great video. thank you

@LeanExcelSolutions Год назад

Most welcome!

@tambao5883 2 дня назад

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.

@ivanguerreroramirez4589 2 года назад

Thank You!

@LeanExcelSolutions 2 года назад

You're welcome!

@ExcelTechhfreeExcelTraining 3 месяца назад

Really amazing vedio. You are excellent nice explanation. Working style really appreciated 👌

@LeanExcelSolutions 3 месяца назад

Thank you so much for the appreciation 😊

@vadiyarhemadri1903 Год назад

excellent mam its like amazing thanks for your support

@LeanExcelSolutions Год назад

Thanks and welcome! 😊

@shahidib587 Год назад

Hey any chance you can share the powerpoint format of the background image ?

@RobertHorvat93 3 месяца назад

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 ?

@ArnaudJoakim 6 месяцев назад

Wow! My job security just went way up!

@LeanExcelSolutions 6 месяцев назад

Great

21 день назад

Amazing!

@LeanExcelSolutions 21 день назад

Thank you 😊

@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 Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-F2GY5U-uVhI.html

@davibarbutti5813 Месяц назад

What a great video!

@LeanExcelSolutions Месяц назад

Thanks 😊

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

@feradita Год назад

Very nice

@LeanExcelSolutions Год назад

Thank you

@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

@thoruain 8 месяцев назад

i love it

@LeanExcelSolutions 8 месяцев назад

Glad to hear that! 😊

@masumahmad679 Год назад

Nice works

@LeanExcelSolutions Год назад

Thank you very much

@kiba6634 Год назад

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 Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-F2GY5U-uVhI.html

@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 Год назад

How do you differentiate the 2? :)

@LeanExcelSolutions Год назад

🤔 Sorry, I don't get it!

@miaberenyi5398 Год назад

It is a report indeed. But if you have pro or premium you can turn it into a dashboard.

@LeanExcelSolutions Год назад

Yes, thanks!

@rohail260 2 года назад

amazing video....just one issue...i think Profit = [Total Selling Value] -[TotalBuying Value]

@LeanExcelSolutions 2 года назад

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

@Natarajan-ut8rk 3 месяца назад

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

@Troublesolver123 2 года назад

But it is not adaptive, right? What will happen if I open it on a smartphone?

@Web3girly Год назад

Love your work but please slow Down a bit

@LeanExcelSolutions Год назад

Sure, thanks!

@vasimishaq9419 Год назад

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

@mrJay9205 4 месяца назад

Seriously amazing ❤ I watched this video at speed of 0.75 😂

@LeanExcelSolutions 4 месяца назад

Thank you 👍

@garciavher2303 Год назад

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 Год назад

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!

@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

@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

@leonardobevilacqua5988 Год назад

Is the free version fully functional? Thanks

@MirGlobalAcademy Год назад

Like it

@LeanExcelSolutions Год назад

Thank you 😊

@write2ruby Год назад

Added

@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 11 месяцев назад

@@abhishekkumarsingh3289there is no option like don't summarise

@KaleemUllah-qi7hf Год назад

I love you wala thank you 😅😅😅😅

@LeanExcelSolutions Год назад

😃😍

@nasroddinemansour9865 Год назад

how to get this file, because didn't exist in the link, and thanks

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

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

@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

@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 3 месяца назад

@@LeanExcelSolutions Hi, this link is not working anymore. Could you upload once again please?

@LeanExcelSolutions 3 месяца назад

Hi, I just checked it & it is working 🙂

@PennyTrow 3 месяца назад

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

@muhammadyaseenmengal4322 Год назад

cool, can you please share the excel sheets used ................Thank you for sharing

@LeanExcelSolutions Год назад

Thanks, the link to download the Excel sheets used in the description. You can download it from there.

@mariaceverichemarin5165 Год назад

Where Can I find those backgrouns

@ryandconan Год назад

can I put power BI into a website so everyone can access it?

@hozifah8 Год назад

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

@srikanthkalluri9440 Год назад

Use ADD NEW COLUMN instead of NEW MEASURE, bcoz Measure needs to start with aggregated function

@harshjain6042 2 года назад

Doubt: how can I calculate top product, I am using Card but there is no filter of top N things.

@ykmahi7025 Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-F2GY5U-uVhI.html

@Skd833 2 года назад

Can you please share a direct link to the data source used in this dashboard? That would be really helpful

@LeanExcelSolutions 2 года назад

It is already there in the description!

@ykmahi7025 Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-F2GY5U-uVhI.html

@avishekchauhan1474 Год назад

@@LeanExcelSolutions i think we have to pay for downloading the data set as well. which is why you guys are making money. please provide data set at free of cost.

@LeanExcelSolutions Год назад

Hi the dataset is free, please check the link

@Wissou_ 5 месяцев назад

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

@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 10 месяцев назад

how can i download the dashboard

@indianlocal9990 2 месяца назад

very good video but background music is dominating cannot concentrate what you are telling i have reversed many times thank you for video

@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

@prasadplk90 5 месяцев назад

How to implement temple

@thuyazaw1366 2 года назад

I can't open the Common Practice file in excel.

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

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

@zillehuma4244 Год назад

Assalamaalikum sir

@TIPPAVARAMMAHENDER-wq3nx Год назад

Please share the data set link.

@LeanExcelSolutions Год назад

Hi, it's already there in the description.

@lukmanadamu5778 Год назад

How do I get the dataset, to practice?

@LeanExcelSolutions Год назад

The link is in the description to download it.

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

@user-hk5lv9cr1j 3 месяца назад

Please provide the link of the dataset

@LeanExcelSolutions 3 месяца назад

Hi, it's already there, the link is in the description to download it.

@renanfviegas Год назад

beautiful but no answers for my ops. nothing that I already would know.

@Megtheanalyst_ Год назад

Hello, Kindly Help With The Sales Data Used For This Project

@LeanExcelSolutions Год назад

Hi, the link is in the description to download practice file. Thanks!

@Megtheanalyst_ Год назад

@@LeanExcelSolutions Seen…. Not Free? Must Be Paid For?

@LeanExcelSolutions Год назад

@@Megtheanalyst_ data file is free there

@zillehuma4244 Год назад

How l start only dash board

@ankushjain313 Год назад

Please give us background design video link

@LeanExcelSolutions Год назад

Hi, it's in the "Sales dashboard in Excel" video. Here is the link for it ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bjLIA1vSqGs.html

@dsahera Год назад

what is the dimension of this dashboard ?

@LeanExcelSolutions Год назад

16:9, (1920:1080) the default power bi canvas size

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

@dasrildepoy 11 месяцев назад

how to share to the team ?

@LeanExcelSolutions 11 месяцев назад

You must first subscribe to Power BI services in order to share and collaborate with the Team.

@wano 2 года назад

mungkin kami bisa mengikuti jejeknya

@LeanExcelSolutions 2 года назад

👍

@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

@madhangajulapallisubramany805 Год назад

hi I need this excel file

@LeanExcelSolutions Год назад

Hi, you can download the Excel file for dashboard here: leanexcelsolutions.com/sales-dashboard-in-excel-power-bi/

@henryworgu8855 Год назад

Great video but a little too fast to follow by beginners.

@LeanExcelSolutions Год назад

Thank you so much for your appreciation! Yes, it fast for beginners. I am trying to keep it slower for new videos.

@abhijit2810 11 месяцев назад

Please upload data link

@LeanExcelSolutions 11 месяцев назад

It is already there in the description

@joshuajato3878 8 месяцев назад

Nice video. But you're too fast. Finding it really hard to follow. 😅

@LeanExcelSolutions 8 месяцев назад

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 6 месяцев назад

You can slow down speed from settings

@mrJay9205 4 месяца назад

I did the same 0.75 speed is perfect