Welcome to the Simplilearn Community

Want to join the rest of our members? Sign up right away!

Sign Up

Tableau|Nov 16- Dec 7 | Deepak

Sapna Bhosale

New Member
Not able to play tableau_desktop_10_qualified_associate_batch_14_nov_16-17-18-19-20-23-24-25-26-27-30_dec_1-2-3-4-7_2020-20201116_1446-1_1605553809 (3) .arf file?
What software do we need to play the recording?
 

Hitesh H S

Well-Known Member
Staff member
Simplilearn Support
Not able to play tableau_desktop_10_qualified_associate_batch_14_nov_16-17-18-19-20-23-24-25-26-27-30_dec_1-2-3-4-7_2020-20201116_1446-1_1605553809 (3) .arf file?
What software do we need to play the recording?
Hi Sapna,

Kindly install the below player to play the recordings. Please download .ARF format file and install it on your system.
https://www.webex.com/video-recording.html

I hope this helps you.

Happy Learning !!!
 

bhavana_16

Well-Known Member
Staff member
Not able to play tableau_desktop_10_qualified_associate_batch_14_nov_16-17-18-19-20-23-24-25-26-27-30_dec_1-2-3-4-7_2020-20201116_1446-1_1605553809 (3) .arf file?
What software do we need to play the recording?

kindly try uninstalling the nbr2 player and reinstalling it. Incase the issue is not resolved I would request you to raise a ticket so that we can a closer look and be able to assist you
 
m.lokesh.kumar6364
m.lokesh.kumar6364

My Project Sir-M Lokesh Kumar
 

touchstone.in

Well-Known Member
Hi Deepak, I am resending my request here as there is no reply.
Pls check my Tableau project https://public.tableau.com/profile/ramesh.zaidi.rozan#!/vizhome/Proj2V2/Sheet2?publish=yes
Thank you and looking forward for your comments.


you have not added the reference distribution after adding here is the final solution -
https://public.tableau.com/profile/deepaak#!/vizhome/Project-2-ModelAnswerWithDashboard/Dashboard1

Here is your corrected solution -

Proj2V2 - deepaak | Tableau Public
 
Last edited:
Please anyone to help me on how to get the above and below target in the project, because when I create the calculated field it gives me error. Thank you.
 

Saudamini Muley

Active Member
Simplilearn Support
Alumni
Dear Madam/ Sir
I am saudamini muley from PG DA Cohort 4 and class from Tableau Training,( 21/11/2020-13/12/2020) I want to ask a favour on the (Project 2 - Sales Performance ) and Please solve my query in each Question with hints.
1. Create a bullet chart with Category and Segment dimensions and Sales measures. :
-Draw the Bullet chart from my side as plz check it , its correct or not .
- I add some calculation field as name ( AGG(if Calculation ) to show a Above and below .
- How to replace the Null value in the Bullet chart .
2. Blend the data with the Saved Sample - Sales Target data set to bring in the Sales Target measure.
3. Add the year of sales to the view to identify trends and outliers. :
- draw the line chart and show the Trend line and also change the mark type as circle .
- How to Handle and direct the outliners in this chart
- show as fllowing steps -
  • First place Order Date dimension in column shelf, then place profit in row shelf. Change the time to represent continuous month. Duplicate the profit column in row shelf. We will get two Line charts representing the sales for each month of the year. For the second chart type, change the chart type to circle. Change the chart to dual axis chart, by right clicking the y-axis and selecting dual axis. Never forget to synchronize the axis of dual axis chart, otherwise the chart will look weird.
    • Next step is to highlight the outliers. To do that, first we have to calculate the average of profit using window functions.
    • Next step is, we need upper band and lower band to identify the outliers. Any circles that are above the upper band and below the lower band will be considered as outliers.
      • For calculating the upper limit, use window standard deviation (window_stdev) function.
      • Any circle that lies above this calculated field are outliers, similarly we must calculate our lower limits using window_stdev function. Any points that appear below this lower limit are outliers.( gave some hints on it )
        • Next step is, by using this Upper and Lower calculated field, we should create our reference band. We should use this upper and lower in views, for that drop them in details shelf as shown below,
        Right click on profit axis and select add reference line. Select reference band , this band starts from lower and end at upper.
      • Every circle within this reference band are normal distributions for our profits. All the circles that lie outside this reference band are outliers which we must bisect it.
        • Next step is we must highlight our outliers. To highlight our outliers, we should create a Boolean calculated field.
  • I gave the folder for this .
Regards
Saudamini Muley
 

Attachments

  • Sales Performance Analysis 2 - 10-12-2020.zip
    389.6 KB · Views: 10

Support Simplilearn(4685)

Moderator
Staff member
Alumni
Please anyone to help me on how to get the above and below target in the project, because when I create the calculated field it gives me error. Thank you.
Hi Portia,

Please find the below solution
IF SUM ([Sales]) > SUM([Sales Target (Sales_Target)].[Sales Target (Sales Target)])
THEN "Above Target"
ELSE "Below Target"
END

I hope this helps you.

Happy Learning !!!
 
Top