The Microsoft Excel Dashboard Masterclass - Don't Miss It Part-1
Вставка
- Опубліковано 11 жов 2024
- Step into the World of Microsoft Excel Excellence: Your Ultimate Dashboard Masterclass Awaits!"
Download the Dataset here: drive.google.c...
Join our Excel Dashboard course: www.udemy.com/...
Our other courses here: pfieuz-schruag...
If you need me to create your Dashboard send WhatsApp Message to: +234 810 6090 365 Business only.
In this video, you'll embark on a journey through the Adventure Works sales data, where we dive deep into the power of Excel. Learn how to transform raw data into actionable insights like a pro.
What You'll Discover:
📊 Power Query Magic: Unleash the potential of Power Query to clean, shape, and transform your data effortlessly.
📈 Power Pivot Relationships: Master the art of building relationships to create dynamic dashboards that update in real-time.
📊 DAX Formulas: Demystify Data Analysis Expressions (DAX) and supercharge your calculations and measures.
🔍 Excel Functions: Harness the full potential of Excel functions to add logical insights to your dashboards.
📊 Visual Storytelling: Create captivating visuals that make your data-driven story crystal clear.
Whether you're a data enthusiast, analyst, or business professional, this Masterclass will equip you with the skills to craft stunning and informative Excel dashboards.
Don't miss this opportunity to become an Excel Dashboard Master! Subscribe, hit the notification bell, and share this video with fellow data aficionados. Let's dive into the world of data-driven insights together.
Ready to revolutionize your data analysis game? Join us now!
Love it! Especially since it also covers the Data Model and Power Pivot which is important to learn and not only know how to do Dashboards without knowing the enormous possibilities that the Data Model and the Power Pivot can provide.
👍
This was very clear and so well-explained and proved a great example! Tysm for uploading😊❤
Nice having you.
Astonishing content Man! Thanks to share your knowledge with us 💯💯 Thanks for the subtitles too. 🥳 Thumbs Up from Brazil !
Thanks.
Hi Ismaila
I really appreciate your efforts. That's what I am looking for. well explained and step by step tutorial that will take you to the next level. Thank you for offering such fruitful content.
keep it up
Thank you
sir, you are wonderful. I learn much much from here.. good luck sir
Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj
This was awesome, thank you. I really enjoyed this tutorial
Thanks.
Awesome Job! Easy to follow
This is great looking forward to part 2 video thank you
Will be ready tomorrow 👌
wow amazing
Thanks
this is my first time learning power query and power pivot didn't know that it did this which is I thing easier than x or v lookup
Love it, you are really good at this. Please how much time do you spend creating one dashboard?
It depends. I use 1 to 2 days sometimes in one week
How do I connect with you for mentorship please. This is great
so the most clear..please add subtitle too
I will
HURRRRRAAAAAAAYYYYY!!! A new VIDEO!!!
As-salaamu alaikum, I really like your tutorials, always very insightful and your use of colors for the visualisation is top-notch, would try it of course, it is giving me ideas on what I planned on doing with a report from where I work, I want to redesign it. How many parts does this have, well done Sir.
Thank you. The video has 4 parts.
Waiting for part 2
Will be ready tomorrow 💝
Good one as always, bro.💯🙏
Thank you. More to come.
Hello Data With Decision! Very cool dashboard! May I know the size of the canvas you used? 🥰
Just fit it to your screen we have different screen sizes
Hello please I don't have the power pivot on my excel 2016 I have even watched some UA-cam videos to enable power pivot but I still haven't found a breakthrough
When I went to add INS it wasn't bringing the option of power pivot it was bringing for power map
Is in your addin
Better still, I will urge you to update your Excel the latest version.
There are many benefits as a data analyst if you have the current version starting from Excel 2019, 2021 and more recent version 2023.
In the Excel toolbar, click on file and go to more. Select options. In General, click "add pivot power and 3D map" and press ok
Useful
Hello sir,I created the dashboard by following you and I embedded the link in the novypro portfolio as a project ,in novypro website it is not allowing to be interactive dashboard if I click slicers it's not updating and showing massage.the massage( this work book contains external data connections or bi features that are not support.)how to overcome it.
Can i do this project with excel 2016 please i don't want to encounter any major problems along the line
Yes, you can.
Please how because is not loading well and I cant see the query part@@datalab365
I want to add this project to my portfolio with some tweaking , do i have your permission ?
💯%, you can.
Beautiful
Pls i couldnt get the query on my excel table. When i clicked on connection, only connection came up and not like yours that has "connection query", Pls help. Thanks
Is there, just patiently look for it
@@datalab365 i will keep on trying,i got frustrated yesterday and stopped
Hello!
Please how do you get all those image icons?
@@chiagoziemndubuisi7962 Google flaticon you will see several icons there.
You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj
Thanks for this, very informative, all this fucked tables
🙀
in calculating the total revenue why not (UnitPrice-CostPrice)*OrderQuantity?
I'm a dummy forgot that revenue doesn't account for the deduction of expenses
Can anyone tell what are used here ?
I know only excel right now so wanted to confirm whether everything done here involves use of Excel only
Is just Excel.
You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj
May I ask where you got the moving icons.
Go-to flaticon.com
how can i do this on a mac :((((
Get a Windows PC.
Use virtual machine
I can't add a custom format. I've checked it several times, and it seems correct, but it still doesn't work.
Same problem bro 1:04:14
Download link not working..
Can you send me the direct downloading link?
Is working. Kindly click on the Google Drive link 🔗 in the description box.
When part two ?
Should be ready tomorrow 💝🙏
how get this course?
www.udemy.com/course/advanced-microsoft-interactive-and-dynamic-excel-dashboard/
I am sure the content is great, but the heavy accent makes it almost impossible to follow. Sorry, can't follow.
No issues. I am proud of my Nigerian accent.