Interactive Insights: Excel Dashboard Techniques. How to create Excel Dashboard
Вставка
- Опубліковано 4 кві 2024
- Unlock the full potential of Excel with our latest tutorial on 'Interactive Insights: Excel Dashboard Techniques for Real-Time Data'.
Download Dataset here:drive.google.com/file/d/1ymmN...
Get full Dashboard here: www.udemy.com/course/advanced...
✔ If you need me to create your Dashboard send WhatsApp Message to: +234 810 6090 365 Business only.
✔ Follow me on Facebook for more content: profile.php?...
✔ Follow me on WhatsApp Channel: whatsapp.com/channel/0029VaDU...
✔ Our other courses here: pfieuz-schruagh-hydroiaff.yol...
In this in-depth video, we’ll guide you through the process of transforming raw data into dynamic, real-time dashboards that provide actionable insights at a glance.Dive into advanced Excel features that allow you to create a dashboard that not only tracks key performance indicators (KPIs) but also engages with vivid visualizations tailored to your business needs.
We start by dissecting customer analysis to show you how to display profits by gender and age, offering you the tools to segment your audience and refine your marketing strategies effectively.Then, we take a deep dive into profitability trends. Learn how to utilize Excel's powerful charting and trend analysis features to uncover hidden patterns in your data, revealing insights into sales effectiveness and seasonality that can drive your business decisions.
Our session doesn't stop at static numbers; we introduce interactive elements that make your dashboards responsive and insightful. Understand the nuances of tracking profitability by weekdays and the significance of this data in operational planning and optimization.Additionally, we cover product analysis in a way that highlights not only the top-performing items but also sheds light on return and refund rates-crucial for inventory management and financial forecasting.Join us as we explore techniques to compare store performances and dissect month-by-month sales data for a comprehensive understanding of your financial standing. Plus, get expert tips on presenting this data in a way that’s both understandable and engaging to stakeholders.
By the end of this tutorial, you’ll have a blueprint for building interactive dashboards that bring your Excel data to life, enabling you to make informed decisions swiftly and confidently. So, whether you’re a data analyst, business owner, or Excel enthusiast, get ready to elevate your data game with 'Interactive Insights: Excel Dashboard Techniques for Real-Time Data'!"
If anyone struggles with the fact that total target remains same for all rows at 1:10:46:
Reestablish the relationship between the monthly store target table and the sales person table.
This time, you would have to connect the two tables using the Store ID column in the monthly store target table and the Sales Person ID column, instead of the store name column in the sales person table.
Bravo. I've worked in the industry 20 years and this my friend is excellent work. Your knowledge of custom formatting is outstanding.
Thank you
like the design so nice... excited to watch your tips and tricks in this video... thank you for sharing
amazing!! thank you
GREAT....EFFORTS.........INSHALLAH YOU BECOME....THE GREAT INSTRUCTOR
Thank you
Astonishing content Man 💯💯💯 Thanks to share your knowledge with us 🔥🔥
Thanks 🙏
Thank you so much
I think this is very nice project. I did not see this project yet, but I will see and I think I can include this project in my portfolio. Thank you so much for your hard work.
Sure
Will you include this project in your portfolio? You didn't do it!!
Outstanding 🙏
🙏
love it!!!
🙏
I leik ❤❤
Vessoni, o fofoquinha da fiel!
Amazing video. This is what I am searching 😊
Thank you
keep doing the great work.
🙏
BRAVO!!!!!
Please upload part 2, waiting for this one
Sure, I will soon.
Great videos, thank you! It is very difficult to understand you, it my help to find someone to interpret for you or AI of course. But overall great dashboards!
😂😡😭
Hello brother, i just came across your channel just now. May I ask if there is a part 2 for Maven Airlines Analysis you did a year ago? I can't seem to find it in your channel. Thanks.
Bravo Bravo Bravo👍👍❤❤, I Doff my cap for you
Thank you.
Can you please create a video on Excel bucket list of salary
Category wise
That's really great and to go in deep to explain each and everything is greatly appreciated. Would you mind if I follow and create this to include it in my portfolio.
You can use it anywhere.
Age locale issue -" Go to the column(date) . on the data type(left corner) click, go to "using locale" choose the date format as "English(USA)"
the formula used for formatting the arrow and the percentage looks complex, but this does thesame thing
=IF((R14-S14)/S14 > 0, "⬆", "⬇") & TEXT((R14-S14)/S14, "+0.0%;-0.0%")
Awesome content. Im became fan of your content. Appreciate your hard work and dedication. I have a question...how do you get dadhboard design ideas?
As a data analyst, I work on data every day, creating dashboards/Reports so coming up with design seems natural.
@@datalab365got you! Please keep iploading the valuable content. Thank you!
Tbh. the dashboard design ideas is the most challenging part for me.
Fala Diogão, Augusto melo todo mês tá aprontando uma hein, empréstimo da Arena, reunião com Andres, pelo amor de Deus
there is something missing at 1:37:53 , when you stopped recording and came back after making the Total revenue connected with the month slicer ?? plz get us the missed point here ! ,, thanks for you efforts 😉
Bro pls us add number format formular you used to format the KPI in the comments 🙏
Excellent work done! If I want the dates in my Date Table to start from January 1 and end at December 31, how do I achieve this?
Create a month number and use the month number to sort the month in power Pivot.
That's all.
The following DAX formula is invalid:
SUMX(facts,RELATED(products_table[Sales Price])*facts[Quantity Sold])
why i am getting this errors, in all the DAX measures???
This video is very interesting and educative. However, you didn't show how you calculated "Qty Returned" and " Total Qty Sold". Please, can show how to calculate them 🙏
@@Adesola_Analyst I did. Please, watch the first video
Yes, he has done those calculation.
Well Done.. could you show us a Star Schema for football please
K
Great Lecture Sir,
Actually , my excel version is 2016 so it's not shown all options like when you add new column for month name or name of day shown only numbers , is it right ?
It has all the options, just check patiently
Can i use this for strategic dashboard, i mean by changing the content
Yes
Bravo this is real time project?
Yes.
@@datalab365 thanks brother 👍
How do u connect "Filter by Month" with the "Total Revenue, Total Target & Variance and some other stuff "? 1:40:10 min.
What is your question ⁉️ make it clear.
Hi, this is a nice job you have done here with excel. However, When i load the fact_table, the date column shows as a text data type. I have tried all i could to transform it but i am not succeeding. When i try to change data type with locale, my laptop hangs. Any help from anyone please?
I hope not late but i can help, go to the column(date) . on the data type(left corner) click, go to "using locale" choose the date format as "English(USA)" - cheers
Hii.. this project is good but I'm facing issues at last in Variance it is same colour using conditional formatting
Re watch it carefully
Can you please share the dataset you used
Is in the description box
Hi, can we send this dashboard to outlook and the reciever can open and navigate with the dashboard?
I have done it before
Do you do custom dashboards for businesses?
Yes
@@datalab365 Ok, I assume the whatsapp number is the best way to get in touch with you?
@@datalab365 I assume the whatsapp number is the best to get in touch with you?
How can I create a Microsoft account so I can use zebra bi
The same way you create Gmail. Sign up for Outlook or just search on Google for sign up for Microsoft account.
Just create one. Is easy.
Ismila ,
If I want to buy one of your courses about dashboards on excel
Which one you prefer
-Interactive Microsoft Excel Dashboard for Data Analyst 2023
Or
-Advanced Microsoft Interactive and Dynamic Excel Dashboard
Buy the one I have it's link on the description of this video
@@datalab365
Ok I will buy it with ( Interactive Microsoft Excel Dashboard for Data Analyst 2023 that is 28 hours and you made about 10 dashboards)
I think both together will be great
I will buy the course you mentioned with
(Interactive Microsoft Excel Dashboard for Data Analyst 2023 which is 28 hours and 10 dashboards)
I think the both together will be great
@nourreldeenmohamed367 How did you like the courses? I'm also interested. Would love to know your experience.
Good morning.
I tried uploading the downloaded excel file in power query, and my date column is text character, I tried converting it to data and I couldn't.
Please is there anyway I could do that? I am stuck.
Thank you.
Close it and start all over again.
Make sure you open the data in Excel first and convert the date column to date then close and load it to Power Query.
I wish it helps.
I can't add new column to calculate the age of the customer on power query, the date is showing as parse how can i fix this please.
Make sure you convert your date column to date data type
@@datalab365 Please I had the same problem, then I tried converting to date data type and it gave me so many errors on a lot of the date of birth entries. How do I fix these errors please?
Is there an alternative to zebra ?
Yes, use charts. One chart for revenue and targets and the other for variance.
Just do revenue - Target and have your variance.
Just be creative.
I just started watching this promising lesson, noticed when i select the date of birth column, the age option under date is greyed out. then i figured the date of birth column wasn't formatted as date data type. I tried converting it but it's giving so many errors for date entries. only few converted correctly. please help.
just figured it out. thank you. changed locale to English USA
Okay, thank you.
unable to connect date and order date , order date in fact table to order date in date table
Why? Make sure your two dates from the two tables are using date data type.
If the data type is wrong from either of the tables it will give you errors.
Try it again.🙏
The data I downloaded in the date column in customers_table, its type is ABC but when I chage its type to date it gives an error. I have tried multiple times but it always gives an error. Any idea how can I fix this issue?
Change the region. Your region Date format doesn't match the one on the dataset.
@datalab365 Thank you so much. It worked.
How to install and login wit our personal email
Our Microsoft account.
When I try to duplicate column at the very start at 4:34 mins the Date of Birth column doesn't allow me to select Age through the add column section and therefore, I am unbale to move forward :/
Convert your date column to date data type. It will work. You can as well use Transform.
I get the same problem, after I changed data type to Date, many columns appears "Error", although most of the can be converted successfully.
@@milomalaysia7034 right click on the date of birth column, click on change type, then using locale, change data type to date and Locale to English (United states) then ok
Hello I'm facing an issue while working with dates. It showing me blank whenever I'm putting total revenue against Month any help in this regard?
Relationship issues.
Make sure there is relationship between your FactTable and the date table
@@datalab365 Hi thanks for the assistance. However I followed the exact same steps as in the video. But still got an error.
i can't bring up for age, i tried like there but can't. Why?
I hope not late but i can help, go to the column(date) . on the data type(left corner) click, go to "using locale" choose the date format as "English(USA)"
@@master573v3 Thank You
I am getting error for month slicer it is not showing target for another months just showing for january
Same issue I am encountering, have you been able to resolve it?
I was able to solve this issue, after a long try..
Make sure the Date format in the monthly target is in English USA... i.e Day/Month/Year...
Format it before Querying it.
@@andruleoladotun9403 I experienced the same issue aswell, let me try this Date format to my column.
Guys help
@@andruleoladotun9403try your method but not working
This is not a fully dashboard video
Is 3 parts. I have uploaded them all.
Why do you have all your dashboards where data has to be loaded in power query/power pivot? You can’t still have simpler ones
Also your dashboards doesn’t look like tutorials that explain what your dashboards are for…you just do demo like you a working demo
@@arindambhattacharya7848 Really? 😱😂
@@datalab365 absolutely..please introduce with business concepts and explain what you are doing..a work instruction based demo can be found anywhere
Thanks for your effort but may i ask u for the reason i found huge blank for total reveneu with store name 4,818,877
I don't know. Reload the dataset and start all over you might fix it that way.
@@datalab365 Thanks for qick response
@@datalab365 In fact, the problem is with the Fact table. When I download the file, the file does not complete the data in the preview has been truncated due size limts
How can i fixed this problem
You might want to take a look at your data model again.
Reestablish the relationship between the monthly store target table and the sales person table.
This time, you would have to connect the two tables using the Store ID column in the monthly store target table and the Sales Person ID column, instead of the store name column in the sales person table.
@@inemesitumoh8544 The data model has limition Row 1000 How i Can remove it