Build the ULTIMATE Excel Dashboard from Scratch
Vložit
- čas přidán 26. 06. 2024
- Build an interactive Excel dashboard from scratch using pivot tables.
📊 Get 25% OFF Financial Edge courses using code KENJI25: bit.ly/3weTzPo
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/62e6c1...
In this video we'll create this interactive sales dashboard for adidas on Excel that's going to dynamically update based on the filters on the side which will allow us to select specific years, regions, products and more.
First, we'll go over the dataset and create pivot tables to show us the relevant data.
Second, we'll create the right charts and visuals for the dashboard.
Then, we'll begin the design of the actual dashboard from scratch.
And lasty we'll put everything together by dynamically linking the visuals and making them an interactive dashboard.
LEARN:
📊 Get 25% OFF Financial Edge Using Code KENJI25: bit.ly/3PvjJUV
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑💻 LinkedIn - / careerprinciples
GEAR:
📹 My Favorite Books & Gear: kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Pivot Table Analysis & Charts
6:52 - Designing the Dashboard
11:31 - Table format & Sparklines
16:19 - Making the Dashboard Dynamic
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
📊 Get 25% OFF Financial Edge courses using code KENJI25: bit.ly/3weTzPo
YES
sir, may I request a tutorial video of personal income dashboard that can be interactive?
I am enjoying the journey with you 🥰🥰
But the excel file isn't downloading do you have another way to download it
Please how do I get the data set
"Formal education will make you a living; self-education will make you a fortune." - Jim Rohn, This quote helped me to grow and hope it helps you too, a fellow creator,,,,
❤ love it
Are u sure sirr???
Dear Kenji, I just can't stop thanking you for the value you have added in my life through your amazing excel knowledge. God bless you and thank you so much once again. love from India.
Your videos are ALWAYS top notch... thanks a million sir for adding values to our lives
Man this is very useful, I cant thank you enough for every knowledge I obtained by listening to your lessons.
I know you’re the Obi-Wan Kenobi of explaining everything finance but I wanted to say I am proud of your progress and quick growth. Been following for a time long before 100k. Keep up the good work.
WOW I just built a dashboard for my work using excel following this Tutorial. I am a python Fan but not having to deal with environment settings and deployment issues this approach is amazing. thank you for sharing the Knowledge.
This is something useful
I can see many uses of it in the daily reports I create, this can up the notch a lot more than regular pivot data copied and pasted on emails
Thanks Kenji 👍
Glad it was helpful!
production value 100%. Loved this!!
I like the simplicity of your style very interesting, No unnecessary force or pressure.
Awesome boss! That's something I've been expecting from you and now you have finally done it. Take love 💖
Hope you enjoyed it!
this was the first video I have watched of yours, full of value. Appreciated
after watching tons of tutorial on dashboard, this was the most professional and cool looking. Thanks
What a nice dashboad! Thank you very much I learned a lot from this video Kenji!
Thanks Kenji. I believe I can go ahead to build my dashboard now
Also, your videos are clean...video and sound
Thanks Kenji for such an amazing video. I thought we could only create dashboards in Power bi and tableau
You make it look so easy. Whew. Thanks for this Kenji
I have been watching many of your videos and you are very clear at explaining. I am really thankful for your content
I really appreciate your video and that you give us an example to work on while we are viewing the video. My example came out pretty good thanks to your instructions. My only critique is to add how to customize the slicers, since you went past that part. I was trying to make one to match yours and it left me with the question on how I can make one.
Love your tutorials, excellent work
One of the best video of dashboard so far thanks !
You are the one I was looking for. Thank you!
Very present presenter. Get's right to it. Makes it look easy. Well done!
Really great!!! Extremily efficient!! Thank you!!
I have always wondered how dope professional dashboards are built in excel. After watching this video, I stopped wondering 😎. Thank you ❤️
Great stuff. Thanks for doing this. I am learning a lot.
Beautiful and simple explaination to create a interactive dashboard
Thank you so much kenji ... You are not just handsome but so helpful in making our lives better and easy... You are so cute... 💗💗💗😍😍😍
I duff my heart for you. You are VERRRYYYYYY GOOD!
This video was great! You got straight to the point! I love what I am able to do. I start a new data job next week and can't wait to demonstrate these new skills.
Awesome to hear best of luck!
Wew, congratulation for your new position. May I ask how we can land a data job? I am struggling to get one, my main field is in healthcare since I am also a Physician, thank you
@@romelciptoadi4200 I started by getting a Google Data Analytics Professional Certificate. After completing the course through Coursera, it took me a little under 5 months to get a data job.
@@dawnfelton8596 Same for me .. took me 4months after getting the Google data Analytics certificate to get a data analyst position
Great Video. Thanks a lot for your knowledge sharing!
Kool! That's exactly what I've been looking for. Thanks.
Thank you, really great content, delivered at a excellent pace, voice tone and language :)
Excellent video and walk-through tutorial.
Such a brilliant work 👏
Thanks Kenji for the sharing! Very insightful and impactful. May God bless your career. From Indonesia. Wait for another video...
This is really great content, learning how to use excel through your videos!
Great to hear!
Thank you! This=is has been extremely helpful!
Awesome, Kenji!
A good way to recap some concepts, expand knowledge and showcase our XP. All thanks to you and your efforts.
Thanks a million!
Please were you able to use the data
@@oluwasogoabbey4269 at first I wasn’t. But I downloaded the dataset from Kaggle , worked my way out, and followed along with the video 🙂
I do enjoy your videos. I am starting to build better excel skills and this tutorial is awesome.
Your are indeed a life saver. Job well done bro
Thank you.. this was very instructive
Thank you for this great tutorial.
Thank you so much Kenji
This is really helpful and well detailed ..kudos
This is quality dude, you make it look super easy!
Thank you Diego!
Thank you so much sir.. A very big help.. God bless you sir abundantly.
Wow makes it super easy and straight forward !
Great to hear!
Your awesome im going to try this over the weekend
Thank you so much for taking the time and showing how to do this! Thanks!
Thank you for supporting! 😁
Very well explained thanks❤
super super awesome. Thank you
Amazing, beautiful dashboard. My inspiration chanel. 👍
Best video of my life literally thumps up K👍🏽👍🏽👍🏽
A real great video .. Thanks so much for your kindness
It's an awesome video. Thank you.
Amazing. Thanks!
You r the best dashboard Sifu on the planet .. thank you
Thanks for inspiration, looks really good!
Thanks for watching!
Thank you for such a nice video!
Such an amazing video you made. Thank you
Thank you for watching!
Ur a legend Kenji
Amazing video thank for presentation
finally something worth the time.
Excellent thanks
Thanks for your videos Kenji.
Glad you like them!
Thanks Kenji, this helps me a lot.
Glad to hear it!
Thank you 🎉
You're the BEST!
Awesome.
Btw I would like to share my experience in the last step - report connections: I met an issue 'Report Connections Slicer Not Showing All Pivot Tables' because in the sheet Sales Trend I chose data as in the video, but I filled 'table1' for the 3 rest tables as I named the data as table 1. When I fill the data in the same way in 4 tables, it works
Such a good video Kenji!
Thank you!
What a lovely session, brother. Beautiful. Pls do one HR dashboard .
Well done keep it up 🤝👌🏾👌🏾
thank you for sharing , its very helpful for my presentation and cost data analysis :-)❤❤❤😊😊😊
I am so glad that I came across your channel❤❤
Love to hear it!
Great work on this video! 😀
Thanks Grace!
Thank you so much, I learnt a lot from you.
Glad to hear that!
Thanks Kenji for making this tutorial.However By the help of your tutorial,I have learnt to make Dashboard.
Thank you, sir
Thanks !!!
Love you sir ❤
Thank you so much for your dedicate video above. Seem I'm no longer need Power BI anymore while I have excel to perform visual as well as Power Bi can did
amazing!!!
Hi kenji. Thanks for the awesome video. Super helpful. Looking forward to more videos and content. Side note: I am trying to build a dashboard as part of my academic project and plan to use this data. For the project, I would need to provide references to the origin of the data. Are you able to pls provide a bit of context on the data source? Pls and thank you!
Nice. Thnx
That Report Connections is a Powerful Tool That i am going to implement at work.
thank you
I'm your new subscriber, thanks a lot for providing me very insightful video. I totally love it. It means a lot for me. Keep up the good work!
Welcome aboard!
Thank youuu!
thanks 😍😍😍
Awesome video
this video best thank you!
Great video 😃👍🏼,
Perfect!
Thank you so much
Thanks for watching Mateo!
its really helpul,, Thanks
Awesome to hear that!
Niccceee! 💯🙏🏾
Hey Kenji enjoyed your previous video when you shared facts about yourself. Congrats for 100k subs and many more to come. If possible could you make a video on mergers and acquisitions and concept of synergy.
Thank you! I don't think that's a topic I'll be covering soon as I don't know it too well sorry
@@KenjiExplains no problem mate , if you can do interview related videos for different profiles apart from your insightful excel videos it would be great.
Great Video sir .
Thanks 👍
I will use it 100%!!
Great to hear!