a) Divide the dashboard into two planes. The left plane will feature the company logo, interaction controls, and filters for year and region. The right plane will contain 6 dynamic visualizations and 3 Key Performance Indicator (KPI) cards based on selected metrics. o Profit Margin = total profit/ total sales o Return Rate = quantity returned/ quantity ordered please solve the question using Tableau
1) a) Create the parameter with name as View by. Use three values in parameter i.e., Region, Category and Sub-category. If the user selects any value, then show the sum of sales with respect to the value chosen in the parameter as a bar chart. E.g., If the user selects a category, then show category wise sales. Make sure to edit the worksheet title w.r.t. View by value. By using sample superstore dataset
Create a parameter “Metric” that will allow users to select a metric for analysis from options including sales, profit, and no. of orders (# Orders). Visualizations will dynamically adjust based on the selected metric, with titles and tooltips changing accordingly. For instance, if "sales" is chosen, the visualization will display "Sales by Category
Can you please do this question, Show the average sales for each year and each month. Show the overall average sales of all the months using a reference line and highlight those months for which the sales value is more than overall average sales value.
@@interactivesessionwithmona3253 for icon use alt + 30 u will get it if u didn’t get pls google it bcz im some lepton or pc has other methods also for me alt +30 works
can you please make an video on Show the average sales for each year and each month. Show the overall average sales of all the months using a reference line and highlight those months for which the sales value is more than overall average sales value.
i would like to thank you because your videos have helped me a lot to learn Tableau. However, I have used your formula to obtain the current year's sales and I'm not getting it. I am able to retrieve the data for the previous year's sales though.
I want to create two filter country and state there is one condition if user directly go to the state then filter should not be visible ie empty list.there is mandatory to select country first how it's achieve in tableau
Data Combining and Techniques and Filtering From the Netflix Titles dataset, merge tables using Inner Joins and identify the actor/actress with the highest number of appearances in Sports Movies. Provide the name of the actor/actress and the corresponding movie titles they've starred in. ( sir would you pls make a video on this question)
Press Alt + 30 together it will work if It doesn't work for u then u can Google it u will get your answer for some laptop it doesn't work and some it work
could you tell me this question? Analyse the purchasing capacity of customers by creating the bins of sales with bins size as 10. Show the bar chart of count of sales vs bins. The labels outside the bar chart should be shown in this format: 1,398 (13.7%). Note that if any count of sales value is blank/null value then the bar chart should show 0
From the Netflix Titles dataset, merge tables using Inner Joins and identify the actor/actress with the highest number of appearances in Sports Movies. Provide the name of the actor/actress and the corresponding movie titles they've starred in.
Well urmimalaray in my latest video there description i have given the google drive link from there u can get the data whatever i m using to create the video else for this particular video i used the global superstore data witch is available in google also
@@all_about_data_ @all_about_data_ Thanks for your reply. Yes, I got that and I worked on that to create a Dashboard using Excel for my portfolio project. Actually, I have created a presentation in which I used some description of how I used the other two spreadsheets in this file to calculate different fields by using Xlookup. At last in the reference section of my presentation, I generally like to give these links. So can I use your link on that? If you have any reservations about using your drive link then please let me know the original link.
well i did not prefer excel to create dashboard or any kind of visualization but if u want to share something with me u can pin me in Instagram's i will try my best to help whatever i can @@urmimalaray7226
Thank you so much 🩷💯it helped me alot.
THANKS ALOT SIR THIS HELPED US ALOT KEEP GROWING 🤩
Thank You Sir ,your Videos helped me a lot. God Bless you @All about data
Thank u so much
a) Divide the dashboard into two planes. The left plane will feature the company logo, interaction controls, and filters for year and region. The right plane will contain 6 dynamic visualizations and 3 Key Performance Indicator (KPI) cards based on selected metrics.
o Profit Margin = total profit/ total sales
o Return Rate = quantity returned/ quantity ordered
please solve the question using Tableau
For Growth Icon please tell what to Press After *Alt*
1) a) Create the parameter with name as View by. Use three values in parameter i.e., Region, Category and Sub-category. If the user selects any value, then show the sum of sales with respect to the value chosen in the parameter as a bar chart. E.g., If the user selects a category, then show category wise sales. Make sure to edit the worksheet title w.r.t. View by value.
By using sample superstore dataset
I already make video on this topic u can checkout in my channel
Which assignment is this ?
thanks for the sql sessions sir those are also dam helpfull
Nice video
Sir from where to download this Dashboard logo and filter icons ?
Create a parameter “Metric” that will allow users to select a metric for analysis from options including sales, profit, and no. of orders (# Orders). Visualizations will dynamically adjust based on the selected metric, with titles and tooltips changing accordingly. For instance, if "sales" is chosen, the visualization will display "Sales by Category
For growth icon pls tell what to press
thank you sir your video help me a lot
hello sir, your videos are very helpful help me out how to navigate dashboard 1 to dashboard 2 and vice versa
Sir how to show growth icon short cut key are not working
Can you please do this question,
Show the average sales for each year and each month. Show the overall average sales of all the months using a reference line and highlight those months for which the sales value is more than overall average sales value.
Will make asap
check out the link ua-cam.com/video/SL7foPB7eEA/v-deo.htmlsi=UIIm9v6Mj2tw88YB
i have already made video on this topic please checkout the video
Sir how to save icon like hide and show from Ms word document. Please help
Hello sir this is a dashboard very useful but next dashboard questions is detail reports
Yes will make video on that asap
to get growth in triangle shape what to click sir
ua-cam.com/video/pqbOsE4YIvc/v-deo.htmlsi=hg2plQNaETGBCM2a checkout this
Thank YOu sir but u said some formula it was to first unable to hear can u tell me that formula for growth triangle shape
@@interactivesessionwithmona3253 for icon use alt + 30 u will get it if u didn’t get pls google it bcz im some lepton or pc has other methods also for me alt +30 works
Thank you so much sir
hello sir when im clicking on filter show n hide utton its only showing for year data not category n region
May be u don’t assign properly
@@all_about_data_ it's done sir thank you for ur support
whats the code for the greeen color?
Hello sir...can u pls do crowdfunding project dashboard?
Hello Sir, the dashboard and filter logo does not have the same background or they are not transparent as yours can you help me out with that?
remove backgroup of pic
how to remove background@@all_about_data_
Sir when I am putting the Order Date in the Columns in the Monthly trend tab I am still getting the years only in the axis, can you help please
change the masure right click on the year and select month from there it will change it to the month
how did you add ( %) in segement wise sales pie Chart can you tell me ?
i have made separate video on this topic please checkout on my channel
can you please make an video on
Show the average sales for each year and each month. Show the overall average sales of all the months using a reference line and highlight those months for which the sales value is more than overall average sales value.
Will try to make asap
check out the link ua-cam.com/video/SL7foPB7eEA/v-deo.htmlsi=UIIm9v6Mj2tw88YB
Hello can u do crowdfunding project?
sir can you show segment wise donut chart
i would like to thank you because your videos have helped me a lot to learn Tableau. However, I have used your formula to obtain the current year's sales and I'm not getting it. I am able to retrieve the data for the previous year's sales though.
thank u for your feedback
I want to create two filter country and state there is one condition if user directly go to the state then filter should not be visible ie empty list.there is mandatory to select country first how it's achieve in tableau
yes u can do that for that edit your fliter unselect that worksheet or visual with u dont want to show in the filter like i did for new year date
new year calculated field shows invalid.
Data Combining and Techniques and Filtering From the Netflix Titles dataset, merge tables using Inner Joins and identify the actor/actress with the highest number of appearances in Sports Movies. Provide the name of the actor/actress and the corresponding movie titles they've starred in. ( sir would you pls make a video on this question)
Tqsm sir👍🤗
how to create that triangle icon?
I have make video on that topic already u can checkout in my channel
Sir how to add the growth icon I tried but still not getting it
Press Alt + 30 together it will work if It doesn't work for u then u can Google it u will get your answer for some laptop it doesn't work and some it work
could you tell me this question?
Analyse the purchasing capacity of customers by creating the bins of sales with bins size as 10. Show the bar chart of count of sales vs bins. The labels outside the bar chart should be shown in this format: 1,398 (13.7%). Note that if any count of sales value is blank/null value then the bar chart should show 0
i have already make video on this topic u can checkout on my channel
Thank you soo much bro
Can you pls do this question,
Create a table with customer name, first order date and last order date for each customer.
I will try to make video on this topic asap
hii kya aap bata sakte ho k tableau se file Kaise download Kare
From the Netflix Titles dataset, merge tables using Inner Joins and identify the actor/actress with the highest number of appearances in Sports Movies. Provide the name of the actor/actress and the corresponding movie titles they've starred in.
I can not understand how to add growth icon
ua-cam.com/video/pqbOsE4YIvc/v-deo.htmlsi=7YcH2zlAiJU89cMA checkout this u will get it
can you link the data file you are working on in this video
Well urmimalaray in my latest video there description i have given the google drive link from there u can get the data whatever i m using to create the video else for this particular video i used the global superstore data witch is available in google also
@@all_about_data_ @all_about_data_ Thanks for your reply. Yes, I got that and I worked on that to create a Dashboard using Excel for my portfolio project. Actually, I have created a presentation in which I used some description of how I used the other two spreadsheets in this file to calculate different fields by using Xlookup. At last in the reference section of my presentation, I generally like to give these links. So can I use your link on that? If you have any reservations about using your drive link then please let me know the original link.
well i did not prefer excel to create dashboard or any kind of visualization but if u want to share something with me u can pin me in Instagram's i will try my best to help whatever i can @@urmimalaray7226
Thanks
Kindly show the detailed report
Hope by tomorrow we will make the video on it
segment wise total sale pie chart ka ek video bana do
banaya huaa h aap jake check kar lijiye channel par
pie chart select karke segment ko raw filed me and sale ko column me drag karna aapka chart ban jayega
re sir donut chart kaysey banaya hai step by step dikha do
U can checkout in my channel there I have made particular video for donut chart
How to create a yellow logo
yellow logo witch on you talking about if u talking about the dashboard logo then u can download from google and insert in the dashboard