Sales Dashboard in Excel | Dynamic Excel Dashboard for Sales

✔ Link to download the data file for Practice:
leanexcelsolutions.com/sales-...
✔ Download the complete dashboard file from Store: leanexcelsolutions.com/produc...
There are 5 sheets within the Excel Workbook-
1. Dashboard: Interactive Dashboard with visuals
2. Input Data: This sheet has to be updated regular basis to capture actual sales data
3. Master Data: This is the product catalog sheet, which has to be updated on the addition/ deletion of the product from the list
4. Analysis: This sheet includes all backend calculations done to visualize the data from the input sheet.
5. Color Guideline: This sheet has the reference color codes to customize the theme of the dashboard.
Interactive sales dashboard designed in Excel for B2C type of Businesses using Slicers, Pivot Tables & Pivot Chart. Learn step-by-step to create a highly visual dashboard in Excel.
Timeline:
00:00 - Introduction
01:03 - Dashboard Overview
02:16 - Datasheets Overview
05:10 - Prepare Database
10:31 - Analysis & Prepare Visuals
26:04 - Design Background
31:14 - Design Dashboard
38:48 - Format Visuals
Recommended Videos:
Dynamic Scrolling Chart: • Dynamic Scrolling Char...
(To learn Offset(), Name Manager & liking chart to Dynamic range as mentioned in the video)
Budget Vs Actual - Dynamic Chart: • Budget Vs Actual - Dyn...
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 Exc...
‪@LeanExcelSolutions‬
#excel
#excelDashboard
#Dashboard
#salesdashboard #pivottable #dynamicdashboard #exceltemplates #leanexcelsolutions

Пікірлер: 622

  • @ja3sk3adik55
    @ja3sk3adik55 Жыл бұрын

    It seems to me you are very passionate on what you do, thank you for sharing your knowledge!

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thank you so much :)

  • @perfectvisit
    @perfectvisit Жыл бұрын

    This is next level creating dashboards, amazing! Thank you for sharing

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Happy to hear that! Thank you 😊

  • @sandipanmajumder9419
    @sandipanmajumder9419 Жыл бұрын

    JUST FANTASTIC !!! MY head is blowing 🤯

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thanks a lot!

  • @xavierxon
    @xavierxon Жыл бұрын

    You created a Stunning dashboard. Great learning experience throughout the video. Thanks for sharing this knowledge with us.

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thank you so much!

  • @SDN-gi1nt

    @SDN-gi1nt

    27 күн бұрын

    ​@@LeanExcelSolutions Hi, No doubt it's a very fantastic dashboard I loved it but as a new learner I found it a little fast and requested you to please make a little slow video and explain the things on where we should go in which ribbon and what to select. I am stopping the video taking it backwards and looking again and again where the curser is going and what you are selecting or writing. Please, it will be very helpful for billions of new learners like me... Thank you for considering my request 😊👍

  • @karimsamnani3660
    @karimsamnani36602 жыл бұрын

    This is a wonderful Dashboard in Excel to be prepared in PowerPoint.

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 жыл бұрын

    👍

  • @daniyaragaidarov7784
    @daniyaragaidarov7784 Жыл бұрын

    Before this video i considered myself as a not bad excel user)) Thanks a lot, implemented a lot from your dashboard 🥰

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    😊 Great 👍

  • @oliverelias1356
    @oliverelias1356 Жыл бұрын

    Nice, Thanks for your video. This is the first time I see someone using Pivot and it confused me a little in the beginning but I was able to get very steep you took and the reason you know, I like reasoning why people do what they do. You've just got a new subscriber. Btw, I can see that you're really passionate about what you do and that your willpower is great. I hope you keep doing what you're doing 'cause you rock man. Have a nice day n_n

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thank you so much for your kind words. Really appreciate!

  • @rubenbasco7554
    @rubenbasco755411 ай бұрын

    enjoyed watching it, elevated me to be an excel enthusiast...

  • @blaed011
    @blaed0112 жыл бұрын

    Wow you are so creative. I didn't even know Excel could do that. I was mesmerized watching you build this....

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 жыл бұрын

    Thanks 👍

  • @ezehconfidenceadaeze6189
    @ezehconfidenceadaeze61893 ай бұрын

    I just finished working on this project with the help of your video. Thanks a lot.😊

  • @LeanExcelSolutions

    @LeanExcelSolutions

    3 ай бұрын

    Happy to hear that 😊

  • @avinashagivale5485
    @avinashagivale5485 Жыл бұрын

    Thank you from bottom of the heart for your valuable tutorial. Thank you again.. 🙏

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Your most welcome :)

  • @joedelnonan5809
    @joedelnonan5809 Жыл бұрын

    Thank you very much! I learned a lot of things because of this. All functions are working well in Office 2021 and I am able to follow all the tweaks that you did without a problem in my MS Office 2021. It's a beautiful Dashboard. Thanks a lot (y).

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Much appreciated 👍

  • @yusuf220679
    @yusuf2206792 жыл бұрын

    Amazing works and learnable too, thank you for the video, you wont get it from school.

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 жыл бұрын

    Thank you so much

  • @RaviKumar-pr2by
    @RaviKumar-pr2by Жыл бұрын

    Wow this is first Enterprise Level Dashboard Reporting it's really awesome experience...

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thank you so much :)

  • @m23isabel
    @m23isabel2 жыл бұрын

    awesome will try soon hopefully can improve my productivity! thanks for the video

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 жыл бұрын

    Great! Thanks

  • @nguyenkimlan9122
    @nguyenkimlan912210 ай бұрын

    Thank you so much. It is very very useful. I love your way of transferring knowledge.

  • @LeanExcelSolutions

    @LeanExcelSolutions

    10 ай бұрын

    Thank you for the appreciation!

  • @marketingmanager2564
    @marketingmanager2564 Жыл бұрын

    Very useful content, thank you for sharing Sopheak - Cambodia

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Most welcome, thanks 👍

  • @NitinSingh-pb3tk
    @NitinSingh-pb3tk6 күн бұрын

    A display of masterclass by Lean excel solutions. Thank you for sharing this, It will help me and others. A lot to learn.

  • @LeanExcelSolutions

    @LeanExcelSolutions

    6 күн бұрын

    Happy to hear that 😊

  • @gulsumtagyeva3541
    @gulsumtagyeva35415 ай бұрын

    Thank you for your amazing effort!!! Awesome dashboard

  • @LeanExcelSolutions

    @LeanExcelSolutions

    5 ай бұрын

    Thank you for the appreciation 😊

  • @heinhtetwin8950
    @heinhtetwin8950 Жыл бұрын

    It's really gorgeous. Thanks for your video.

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thank you & most welcome!

  • @cass3616
    @cass3616 Жыл бұрын

    Great tutorial. Thanks so much!

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Welcome, thank

  • @agustianwijaya1
    @agustianwijaya111 ай бұрын

    Your dashboards are very fun to watch and really creative. I love it & Tx

  • @LeanExcelSolutions

    @LeanExcelSolutions

    11 ай бұрын

    Thank you so much! I am so glad...😊

  • @careeredgeschool
    @careeredgeschool2 жыл бұрын

    Well done for me, just watching your vdo I able to create one. Big thank

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 жыл бұрын

    Thanks

  • @Shafeek75.

    @Shafeek75.

    2 жыл бұрын

    Wow

  • @saithejeswar5636
    @saithejeswar56362 ай бұрын

    Thank you for this awesome tutorial and most compelling dashboard, I just finished my project !!! :)

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 ай бұрын

    Great, congratulations 🎉 Happy to hear that

  • @AmandeepSingh-sx1oi
    @AmandeepSingh-sx1oi Жыл бұрын

    Awesome one…detailed to start a dashboard 👍👍

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thank you 😊

  • @devenderkumar1220
    @devenderkumar1220 Жыл бұрын

    This is amazing, nicely used of offset function.

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thank you so much!

  • @zoozooymail
    @zoozooymail2 жыл бұрын

    Amazing work!

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 жыл бұрын

    Thanks..!😊

  • @abrizhussain5357
    @abrizhussain53572 жыл бұрын

    Much love from India I am not able to afford tution fees because I am single person and your tutorial is far amazing when i show this to my friend they just shocked great work and always uploads that type videos

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 жыл бұрын

    Thank you so much:)

  • @DashLiu
    @DashLiu Жыл бұрын

    Wonderful ! Thank you very much for this video, i really learned a lot : )

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Happy to hear that! Thank you.

  • @brijeshshah1348
    @brijeshshah134811 күн бұрын

    Thanks a lot for the amazing learning experience!!

  • @LeanExcelSolutions

    @LeanExcelSolutions

    11 күн бұрын

    My pleasure 😊

  • @benmohamedhichem1988
    @benmohamedhichem1988 Жыл бұрын

    Great job, good lesson thank you 🙂

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Much appreciated

  • @realCleanK
    @realCleanK Жыл бұрын

    Thanks!

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thank you so much! :)

  • @emamul1987

    @emamul1987

    Жыл бұрын

    @@LeanExcelSolutions Madam i did not understand how did you manage scoll button in pivot table. can you make a video where you teach only to add scroll buton and spine button using pivot table... how did you remove 0 also from chart while seeing data for 1 item...............................

  • @pauluskurniawan

    @pauluskurniawan

    Жыл бұрын

    @@LeanExcelSolutions Do i need to edit from scratch? Or can i use directly ?

  • @hamzavlogs7855
    @hamzavlogs78555 ай бұрын

    its was amazing very helpful for sharing your knowledge

  • @LeanExcelSolutions

    @LeanExcelSolutions

    5 ай бұрын

    Glad to hear that 🙂

  • @jocelpitogo8950
    @jocelpitogo8950 Жыл бұрын

    I just placed mine. Learning is Exciting.!

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Wonderful!

  • @HansaniMahawewa
    @HansaniMahawewa Жыл бұрын

    Thank you so much your video was very useful and all steps are mentioned thank you so much

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    You are most welcome

  • @romanulislamsaju9727
    @romanulislamsaju97272 ай бұрын

    You Nailed it! What a Dashboard!?????

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 ай бұрын

    Thank you so much 😊

  • @andrisyam5620
    @andrisyam5620 Жыл бұрын

    I love it, and I will try. Hopefully I can make a beautiful dashboard like this

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Sure, you will 😃

  • @tonylee5038
    @tonylee5038 Жыл бұрын

    Her 45 mins is my 4 hours lol! Thank you!

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    😂 Got it...!

  • @pnkjtanwar
    @pnkjtanwar10 ай бұрын

    Thanks, need to learn lot of tricks from this videos.

  • @LeanExcelSolutions

    @LeanExcelSolutions

    10 ай бұрын

    Most welcome!

  • @lonjezomlongoti4767
    @lonjezomlongoti4767 Жыл бұрын

    This is great development one way to shape the career bravo

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    👍

  • @abhigyanrajendra2008
    @abhigyanrajendra20083 ай бұрын

    I Love your Dashboard espicially with background :)

  • @LeanExcelSolutions

    @LeanExcelSolutions

    3 ай бұрын

    Thank you! 😊

  • @georgeslehner7733
    @georgeslehner77332 жыл бұрын

    AMAZING! In the video, and I understand, it's a bit of a fast pace. So I've decided to buy it (excel version) from your site. I get it in second (thru PayPal). This will give me hours and hours to fully understand and apply this technique to a future project. Surely the best spent 5$ in my entire life! Thank you!

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 жыл бұрын

    🙏 Thank you for your kind words! 👍

  • @havynguyen7050
    @havynguyen70506 ай бұрын

    Thank your for sharing. It's really useful

  • @LeanExcelSolutions

    @LeanExcelSolutions

    6 ай бұрын

    Happy to hear that 🙂

  • @santoshkumar-it2gj
    @santoshkumar-it2gj6 ай бұрын

    Thanks for your effort..... Intresting... Learn alot...

  • @LeanExcelSolutions

    @LeanExcelSolutions

    6 ай бұрын

    Glad to hear that 😊

  • @Exceltech810
    @Exceltech810 Жыл бұрын

    Nice video, still have a lot to learn from this video

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Glad to hear that!

  • @SetChetra
    @SetChetra6 ай бұрын

    Really thanks for your sharing.

  • @LeanExcelSolutions

    @LeanExcelSolutions

    6 ай бұрын

    Most welcome :)

  • @pelumiadeyemi3480
    @pelumiadeyemi3480 Жыл бұрын

    Very helpful video, thank you

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Glad to hear that!

  • @tourgreensea5849
    @tourgreensea5849 Жыл бұрын

    Thank you for your video.

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    You are welcome👍

  • @wenxinhuang8763
    @wenxinhuang8763 Жыл бұрын

    so amazing video,i learn a lot ,thanks for sharing

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thank you very much 😊

  • @jun051786
    @jun0517862 жыл бұрын

    Thank you so much!

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 жыл бұрын

    It's my pleasure!

  • @iliesboukhatem7803
    @iliesboukhatem78032 жыл бұрын

    a great video! thank you so mush

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 жыл бұрын

    much appreciated 👍

  • @gracelawani4332
    @gracelawani4332 Жыл бұрын

    Your dashboards are very fun to watch and really creative. Thanks for the time and effort putting this in for us to see. Curious, is there a reason you did not use data model and then power pivot when creating the relationships between the tables instead of using vlookup? Thanks

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thank you so much! I was trying to keep it as simple, and as lots of learners are not very familiar with Power Query and Power Pivot, I used vlookup instead

  • @charbontogon2976

    @charbontogon2976

    9 ай бұрын

    As a new learner, its easy to follow what you did. I curious also for the power query and power pivot. Do you have a separate tutorial for this? Appreciate much.❤

  • @LeanExcelSolutions

    @LeanExcelSolutions

    9 ай бұрын

    Thanks, yeah it is there. You can look for the customer analytics dashboard on the channel.

  • @Mad1080

    @Mad1080

    8 ай бұрын

    @@LeanExcelSolutionsKindly share us some sample dashboards, so that we can watch and prepare. Very curious to prepare after seeing your presentation.

  • @flavio225

    @flavio225

    5 ай бұрын

    Where can we download this Dashboard for training ? Please let me know your feed-back

  • @SRINUIMINLOVE
    @SRINUIMINLOVE Жыл бұрын

    Nice work and great presentation..

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thank you...!

  • @omarfarik2217
    @omarfarik22172 жыл бұрын

    My english is poor but I try to follow you. Your conception is Amazing...but tje presentation is fast for me 😁... From Cameroon thank very much

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 жыл бұрын

    Thank you for your kind words!

  • @imrandaud478
    @imrandaud4782 жыл бұрын

    Beautiful

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 жыл бұрын

    Thank you! Cheers!

  • @francishubertovasquez2139
    @francishubertovasquez213913 күн бұрын

    That pivot table data and files segregation into that 4 box at the right side reminds me of the 4 's of the Earth areas.

  • @marcoseduardogonzaleztorre9742
    @marcoseduardogonzaleztorre9742 Жыл бұрын

    tremendo lo que se puede hacer y tan rapido.

  • @realCleanK
    @realCleanK Жыл бұрын

    Thank you!

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Welcome!

  • @hunkysandytube
    @hunkysandytubeАй бұрын

    I thought it is possible in Power-Bi that's great innovation

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Ай бұрын

    Thanks! Indeed! Excel is incredibly capable of creating stunning dashboards with its features and functionality.

  • @apsamila
    @apsamila13 күн бұрын

    Thanks.. bro.. oya vidiyatama heduwa.. Dynamic type dash board ekak hadana heti ... puluwannam daanna..😍

  • @planetsaurus4622
    @planetsaurus4622 Жыл бұрын

    thanks for making this video, it helps me a lot ❤️❤️

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thanks 👍, Happy to hear that 😊

  • @sahiljosan5062
    @sahiljosan5062 Жыл бұрын

    Very helpful video Subscribed 👍

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thanks and welcome

  • @heriheri5985
    @heriheri5985 Жыл бұрын

    Thanks for your sharing, so great n cool! Make me subcribed automatically 👍

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thank you very much 😊

  • @ahmedlotfy8347
    @ahmedlotfy8347 Жыл бұрын

    Perfecto thank you very much

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Most welcome,🙏

  • @jorgecoronadohurtado2274
    @jorgecoronadohurtado2274 Жыл бұрын

    Great video, thank you

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Most welcome!

  • @bvyuyh
    @bvyuyh8 ай бұрын

    Just speechless 😊

  • @LeanExcelSolutions

    @LeanExcelSolutions

    8 ай бұрын

    Thank you 🙏

  • @g.muthukumar
    @g.muthukumar2 жыл бұрын

    Excellent Work Madam

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 жыл бұрын

    👍

  • @othmanashara9382
    @othmanashara93822 жыл бұрын

    Thank you very much for this wonderful work. my request, how can I can make a dynamic dashboard in picture format for example jbg. it shows me the status of 3 months for example. thx

  • @hassanizad7276
    @hassanizad72762 жыл бұрын

    Good morning Leile khanoom, have a technical question: how to make a variable data (extracted by using RTD function) to keep the original value (not update after the first value is obtained) while the rest of the table continues to update?

  • @user-ru5li5ep8l
    @user-ru5li5ep8l9 ай бұрын

    Hi. thank you for this remarkable work. I have a little technical question. how do you get the capital letter in the months column? thank you in advance.

  • @amanvarma8032
    @amanvarma8032 Жыл бұрын

    it all went above the head

  • @BharatKumarNurBasha
    @BharatKumarNurBasha Жыл бұрын

    Thank You

  • @sunhowon375
    @sunhowon375 Жыл бұрын

    Can't believe it is poaaible without VBA. It's awesome!

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Really appreciated, thank you!

  • @bangwhy2449
    @bangwhy244910 ай бұрын

    Thank you

  • @hallowelt55555
    @hallowelt55555 Жыл бұрын

    Awesome!!! What a great design. Just out of curiosity, how did you generate this voice over?

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thank you for your appreciation!! ☺️ I am using 'Speechelo' text-to-speech software to generate voice over

  • @youssef9045
    @youssef9045 Жыл бұрын

    Amazing!!

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thank you!

  • @kartikalestari4866
    @kartikalestari48665 ай бұрын

    Fire🔥👍

  • @gajendrasingh9486
    @gajendrasingh94862 жыл бұрын

    Very helpfulness

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 жыл бұрын

    Thank you

  • @thetrailer8328
    @thetrailer832810 ай бұрын

    thank youu, it is help out to my problem

  • @LeanExcelSolutions

    @LeanExcelSolutions

    10 ай бұрын

    Great

  • @adnanmasood5344
    @adnanmasood53444 ай бұрын

    Great work

  • @LeanExcelSolutions

    @LeanExcelSolutions

    4 ай бұрын

    Thank you 😊

  • @phandongexcel
    @phandongexcel2 ай бұрын

    I like this video ❤❤❤

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 ай бұрын

    Thank you 😊

  • @jamesjai100
    @jamesjai100 Жыл бұрын

    Excellent Info..

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thank you so much😊

  • @Austinlenardvas
    @Austinlenardvas Жыл бұрын

    Thank you.

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Welcome

  • @primeoflight6674
    @primeoflight6674 Жыл бұрын

    Appreciated ❤

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thank you

  • @user-pq4zk2on7i
    @user-pq4zk2on7i4 ай бұрын

    Perfect

  • @LeanExcelSolutions

    @LeanExcelSolutions

    4 ай бұрын

    Thank you

  • @mydocs1795
    @mydocs17952 жыл бұрын

    One of best video

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 жыл бұрын

    Thank you 😊

  • @shahidahmed2190
    @shahidahmed2190 Жыл бұрын

    This video is for who knows already about dashboards, not for the beginners.

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Yes, that's right, I explained it assuming viewers have at least intermediate skills in designing dashboards of this type.

  • @shahidahmed2190

    @shahidahmed2190

    Жыл бұрын

    Any video for the beginners?

  • @annaisatse8958
    @annaisatse895810 ай бұрын

    Hi i t thank you for this video Good job to be continous

  • @LeanExcelSolutions

    @LeanExcelSolutions

    10 ай бұрын

    Thank you!

  • @kazirahim4764
    @kazirahim4764 Жыл бұрын

    Great skills

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thanks

  • @pejuangrupiahku
    @pejuangrupiahku Жыл бұрын

    Good morning sorry to disturb your time permission to ask, can the power bi dashboard be used in visualizing toddler nutrition analysis at posyandu? thanks 🙏🙏🙏

  • @gijeet5374
    @gijeet5374 Жыл бұрын

    Great Job on this DB! Question: why subtract 9 to remove zeros for the product scrollbar?

  • @eunicejoybalansay4319

    @eunicejoybalansay4319

    Жыл бұрын

    sir, could you help me with the dynamic scroll bar? it only shows 10 data if I am scrolling. 😢

  • @lokeshmoolya5569

    @lokeshmoolya5569

    6 ай бұрын

    ​@@eunicejoybalansay4319facing same issue I have checked the video 10 time and work on it still facing the issue if you get it kindly help me too.

  • @tahm76
    @tahm762 жыл бұрын

    This is really amazing, can this be done by using PQ data model ? with less formulas ?

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 жыл бұрын

    Yes, it can be done using Pover Query, but to make it simple I tried to use tables & pivots only

  • @carlossousa8744
    @carlossousa87445 ай бұрын

    EXCELENT

  • @LeanExcelSolutions

    @LeanExcelSolutions

    5 ай бұрын

    Thank you 🙏

  • @rahulrajora2271
    @rahulrajora2271 Жыл бұрын

    Hey this dashboard is mind blowing but i'm not able to get that scroll bar linking with that offset function that how does the values are being changing with every scroll down and the corresponding values are changing simultaneously. i tried plenty of times but it's not showing like there in your tutorial. Could you please help me

  • @patrickminja8515
    @patrickminja8515 Жыл бұрын

    very usefull

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    Thank you 😊

  • @opendream3458
    @opendream3458 Жыл бұрын

    thanks.

  • @LeanExcelSolutions

    @LeanExcelSolutions

    Жыл бұрын

    You're welcome

  • @elhaidizaka7193
    @elhaidizaka719310 ай бұрын

    great thank u

  • @LeanExcelSolutions

    @LeanExcelSolutions

    10 ай бұрын

    Most welcome!

  • @asopok
    @asopok9 ай бұрын

    Interesting video. Thanks a lot, I've learnt enough from this video. Am I permitted to work on this dataset and add to my portfolio? If yet, how do I reference the dataset?

  • @LeanExcelSolutions

    @LeanExcelSolutions

    8 ай бұрын

    Yes, you can The dataset link is in the description.

  • @rohitadlakha2838
    @rohitadlakha28386 ай бұрын

    Fantastic give u 101%

  • @LeanExcelSolutions

    @LeanExcelSolutions

    6 ай бұрын

    Thanks 😊

  • @rohitadlakha2838

    @rohitadlakha2838

    6 ай бұрын

    Do u teach online interactive mode

  • @LeanExcelSolutions

    @LeanExcelSolutions

    6 ай бұрын

    No actually, not yet

  • @kazeemmusbau7202
    @kazeemmusbau72022 жыл бұрын

    Thank you this amazing tutorial, Please i try to download the data file but some columns were missing, columns like date, Quantity in input data sheet

  • @LeanExcelSolutions

    @LeanExcelSolutions

    2 жыл бұрын

    Hi, Thank you for reaching out. I checked it. The file is ok, having all required columns.