Fully Automated Excel dashboard with multiple source files | No VBA used
Вставка
- Опубліковано 4 вер 2024
- #ExcelDashboard #PowerQueryforExcel
In this video, you will learn how to create a fully automated excel dashboard with multiple source files. Source files are excel file and they have multiple worksheets. We have used Power Query to consolidate the data using folder connection. We have made the folder path dynamic connected with the settings sheets.
Subscribe our new UA-cam Channel:
/ @neotechnavigators
Please download the practice file from below given link:
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-m...
For a beginner, you have made this not just interesting but less intimidating and I really appreciate that
One of the best Sci-Fi movies of the year.
Thank you @PK An Excel Expert, you have thought me a lot about Excel and VBA. Thank you for your amazing and useful works sir. God bless
Most welcome
I am not a quick learner. But your smooth and easy teaching took me few hours to learn the dashboard creation with Excel Power Query. So grateful to you.
I am working on a dashboard now. This came at the right time. God bless you
Excellent than others becoz you explain step by step and anyone can understand easily.
just keep doing in such a way.
Thanks for your valuable feedback
Very logical, smooth flowing, easy-to-learn method followed which absolutely helps anyone to understand what is being done and why. Great presentation! Thanks very much!
Such a great, clear lecture! You are my favourite excel guru. Thank you so much!
Wow, thank you!
This is one of the best videos I have ever seen in areas of Excel learning, thanks a million and I wish you all success
Wow, thank you!
Thankyou , great learning for those who love to learn in hindi, every minute of the tutorial is very useful.
Very neatly explained, thanks for uploading. Looking forward to more such videos.
Glad you liked it
Excellent work! Sir you are the best.
Thank you very much!
You make things look very simple. Thanks so much. I just have one short question for you. I’d like to limit the selection in a slicer to one item. For instance, if a user selects one quarter, I want them not to select another one at the same time (the selection of the other items in the slicer should be FALSE). Could you please show this in one of your next videos?
Me too! I get really irritated by having all this stuff in the slicer I don't want.
As always Excel king is back with brand new learning, i never get disappointed while learning through ur channel. Love 4m Mumbai💝
Thanks Santosh for your motivational words.
Very well explained, thanks for such an amazing video. Learned a lot from this video. Power query editor is such a powerful tool in excel.
Thanks for your valuable feedback
The best Excel expert on You tube. Proud on you PK.... Great Job
Thanks for your valuable feedback
Thank you for your Great effort preparing this video no doubt enjoyed with this video very knowledgeable one.
Thanks for your valuable feedback
Sir, you have done great job 🌸🌸🌸🌸🌸🌸🌸🌼🌼🌼🌼🌼.
Thanks a lot 💖💖💖💖
Thanks for your valuable feedback🙏
Thanks alot... This is so beginner friendly, really appreciate it.
Glad it was helpful!
I don't have any word for appreciation what a great explanation & solution. Hats off Bro
Thanks for your effort on making this video for all of us 🙏
Thanks for your valuable feedback
Such a nice way to understand Power Query Excel.. Thanks PK for sharing this knowledge.
Thanks for your valuable feedback
Thanks for the good lecture.
Excellent video. Very well explained. Thank you :)
Most welcome 🙏
I am so glad i opened this video
Thanks for your valuable feedback
I am really very impressed with this dashboard. U have a new fan
Thanks for your valuable feedback
Excellent presentation. Very well explained.
Thanks for your valuable feedback
I will try this tomorrow... I need to create Dashboards for my company.. hopefully this might help 🙏
Best of luck!
@@PKAnExcelExpert Thank you :)
World class ! Great depth , let me know you conduct one to one online classes as well .
Thanks for your valuable feedback. Will start the online classes soon.
Master blaster. Excellent .
Thanks for your valuable feedback🙏
Thanks for the video. Explained really well
Thanks for your valuable feedback
Superb sir
Thanks
Great 👍
Thanks🙏
Hi. Great video. But there are few questions and some of them very interesting. Any way to get the answer to them. It's very nice of you but I do realise that you only reply to compliments not to actual enquiry as easy as they may be. The video is easy to follow many thanks!
Nicely done. Good work in explaining this dashboard.
Glad you enjoyed it
Such a Great video again, thank you so much. Just have one request for one more dashboard in power bi with updated visulization along with case study.
Dear Sir, it is very useful. Thank you so much. May I know if you have a way to pivot columns in each table before combining them? Thank you...
Amazing
Thanks
thank for the tutorial...
Most welcome🙏
Thank you PK, nice explanation
Thanks for your valuable feedback
Thank you for the great turorial!
You're very welcome!
What an amazing tutorial, thanks for sharing! I am subscribing this channel.
Thanks for your valuable feedback and subscription 👍
Vary vary nice video sir
Ek dash board stoc market portfolio ke upper banaye
Thanks for your valuable feedback. I will try to create such dashboard
wow. this is a great one ! I really learned.. Thank you very much.
Thanks for your valuable feedback
Excellent guidance. What will be the arrangement for multiple text files rather than Excel files? as this folder arrangement not working on text files.
I look forward to hearing from you. Such a great work, following you has augmented my excel skill, making much fun. thanks PK, keep up the good work.
Yes
Thank you
You're welcome
Great work thanks a lot for your time sir
Thanks for your valuable feedback
Thank you for the video. It's being an amazing learning session and hands on practice session 🔥🔥
Hi very good explanation.
Am having a doubt when there is no discount in a quater then sparkline bars are not coming correctly in dashboard help me to correct it pls
Very good video. Thanks for sharing.
Thanks for your valuable feedback
So if we make any changes in the sheet or add more details will this reflect on dashboard
Thanks a lot for your nice presentation.
Most welcome
@@PKAnExcelExpert thank so much
Excellent video, exactly what I was looking for! Thank you so much
Thanks for your valuable feedback
Nice Video, very helpful. Thank You Very much
Now dashboard look easy thank you sir
thanks so much, very easy understand
Thanks for your valuable feedback
Very good video..helping in clubbing different files easily.
Plz revert how we can reduce file size.
Ex. Each file size is 2 mb. Having 5 files. Post clubbing file size is almost 10 mb. How we can reduce file size?
For someone this advanced, I can’t believe he didn’t use Format Painter!
Thank you for sharing
Good, informative instructions and helpful
Thanks for your valuable feedback
Amazing video,however I’m facing one challenge the number going on pivot is duplicating and I tried to review everything without succeeding to know error,appreciate your advise
Nice video. Very helpful. thank you :)
Thanks for your valuable feedback
Superb
very useful video and wonderfully explained, but i have some challenges in working on it, as I have 3 different set of sources which are in different format, how to go about, please help
You can watch our Power Query related video to learn about the data transformation:
ua-cam.com/play/PLbDvAYjpWJ7DYKQqZYiATs-8AmK2UUs-3.html
Great Work Mr. PK
Thanks for your valuable feedback
At 15:00 what's the difference between close and load and then right click query and create connection. Or in PQ close and load to and create connection
excellent
Thanks for your valuable feedback
thank you so much for this, it was so helpful, but I got an error when creating the pivot chart that says " problems obtaining data " if you have any suggestions to this problem please comment
Hi, Thank you very much for reading this comment. This tutorial is very very easy to understand and extremely helpful. I have a query and here is my situation. I have an excel file of size more than thirty MB and it can be accessed using the network and it keeps growing in size, every day. More than five users are actively using the file, on most of the day. Some of my users complain that when the file is opening and saving it is slow due to the network being slow. Hence, I need a solution for this. I have two solutions in my mind.
Firstly, create a local file to each remote user and let them add their data and sync with the main file in the network when they close or click a button to update the main file.
Secondly, add data to excel file in the network without fully opening the file.
Do you have any suggestions? Thank you in advance and have a wonderful day.
Thank you very much for sharing this. It look so simple.
You're welcome 😊
Superb and inspired a lot .... Dear Bro
Thanks for your valuable feedback
Well done. Very informative.
Thanks for your valuable feedback
I learned a lot , will try this. Thank you
Very helpful, good job man. Thank you!👍
Thanks for your valuable feedback
superb sir 👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍
Thanks for your valuable feedback
amazing
have data in different sheets and I not good enough to do even similar dashboard
Nice video
Thanks for your valuable feedback
THANK you ❤️
You’re welcome 😊
Really interested
Thanks
This is great, quiet helpful! How do I ensure that my slicers don't show 'blank' ?
Hi PK,
Can I send some data on spreadsheet and transfer it to one of your beautiful dashboard, let me know if you can help me on this.
Thank you
Most welcome
very useful video
Thanks
Top! 👍
Thanks
Awesome tutorial, PK!
Awesome video
Thanks for your valuable feedback
Expert
Thanks
Awesome. Thanks for sharing
Thanks for your valuable feedback
thank you for this great exercise
Thanks for your valuable feedback
Thank you so much for the lovely video . It helped me a lot
namaste sir, mere pass ms office 7 hai... mujhe excel mein ek earth ki image insert karke usko rotate karna hai button ki help se. kya ye possiable hai excel mein ?
very nice video sir. really helpful but sir can I make this dashboard from sharepoint links as well?
Nice video. My sheet showing duplicate values in pivot table. One is according to department that is ok and other one is showing _xlnm._FilterDatabase
Hello, thanks for amazing job. My query is duplicating data, anybody could help? thanks!
thank you.. this is awesome
Thanks for your valuable feedback
You're doing great, Sir.
Thanks for your valuable feedback
Thank you for this video, also could you please clarify me how can I remove duplicates,
I’m having same Error,how did you fix it
PK, what if all your data files are .csv files? What modifications do you need to make to get Excel to read from these files? Also, what do I do if each data file is large? How would I overcome the problem of maxing out the spreadsheet size with so much data? Thanks.
Nice video... Thank you soooooo much!!!!!
Thanks for your valuable feedback
Hi , Thanks but I am not getting slicer to work on two pivot tables , not getting options to link both pivot table , please help