tableu assignments
Budget: ₹600 – ₹601 INR
4) Create new order date (e.g. if current year is 2023 then make sure new order date should have 2023) and show below columns in the text table.
• Year
• Quarter
• Month
• SUM(Sales)
• YTD Sales
• QTD Sales
• MTD Sales
7) Create a pie chart showing Top 50 customers Vs Other customers with respect to sum of sales shown in below image.
12) 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 012) 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
18) Create a dashboard on Superstore Analytics as shown in below figures. The formatting / labelling / spacing / alignment should be the same as used in the charts. Read this completely.
Notes:
• The worksheet titles, KPI titles represent which dimensions/measures are required in respective places.
• Make sure to use New Order Date in place of existing Order Date dimension for doing any date calculations or adding the Year filter on top.
• Add appropriate tooltips everywhere.
• Add the Year(New Order Date), Region and Category filters on top. All filters must be in multiple values dropdown mode. These filters should be applied to all the worksheets used in dashboard 1 and dashboard 2. Make sure Year filter should not be applied to current year sales, previous year sales and YoY growth % as these values are for current year and previous year. Make sure to apply filters on table in dashboard 2.
• Initially filters are in hidden state. If you click on show filters icon the filters need to open. When you click on hide filters icon the filters should hide back.
• Apply filter actions keeping bar chart, donut chart and Top 5 bar chart as source and all the worksheets as target.
• Make sure to show top 5 products w.r.t. sum of sales every time irrespective of any filter action values you select or any dropdown filter values you select.
• On the click of Detail Report tab, the dashboard 2 should open and on the click of Sales Analytics tab, dashboard 1 should open. Use appropriate tooltips.
• You can find the dashboard logo and filters logo attached below.
19) Use Netflix dataset and find out country wise shows and total cost for each country. Show the stacked bar chart for the same as shown in below image.
• Year
• Quarter
• Month
• SUM(Sales)
• YTD Sales
• QTD Sales
• MTD Sales
7) Create a pie chart showing Top 50 customers Vs Other customers with respect to sum of sales shown in below image.
12) 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 012) 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
18) Create a dashboard on Superstore Analytics as shown in below figures. The formatting / labelling / spacing / alignment should be the same as used in the charts. Read this completely.
Notes:
• The worksheet titles, KPI titles represent which dimensions/measures are required in respective places.
• Make sure to use New Order Date in place of existing Order Date dimension for doing any date calculations or adding the Year filter on top.
• Add appropriate tooltips everywhere.
• Add the Year(New Order Date), Region and Category filters on top. All filters must be in multiple values dropdown mode. These filters should be applied to all the worksheets used in dashboard 1 and dashboard 2. Make sure Year filter should not be applied to current year sales, previous year sales and YoY growth % as these values are for current year and previous year. Make sure to apply filters on table in dashboard 2.
• Initially filters are in hidden state. If you click on show filters icon the filters need to open. When you click on hide filters icon the filters should hide back.
• Apply filter actions keeping bar chart, donut chart and Top 5 bar chart as source and all the worksheets as target.
• Make sure to show top 5 products w.r.t. sum of sales every time irrespective of any filter action values you select or any dropdown filter values you select.
• On the click of Detail Report tab, the dashboard 2 should open and on the click of Sales Analytics tab, dashboard 1 should open. Use appropriate tooltips.
• You can find the dashboard logo and filters logo attached below.
19) Use Netflix dataset and find out country wise shows and total cost for each country. Show the stacked bar chart for the same as shown in below image.