Tuesday, 14 April 2015

How to create Donut chart in Tableau.?

Here's how I would create a Donut chart in Tableau using a single worksheet. The final product looks like this:
Step 1: Create a two-slice pie chart. This example uses actual sales and sales left to hit the goal.


Step 2: Drag the Number of Records measure to the Rows shelf and change the aggregation to an average. Repeat this a second time and then right-click on the second pill and choose "Dual Axis". Finally, remember to synchronize the axes.




Step 3: Double click on the left axis to bring up the Edit Axis window. Uncheck Include Zero.




Step 4: Do a bit of formatting: (1) Remove Zero line, (2) Remove Row & Column dividers, (3) Hide the headers




Step 5: On the secondary axis, remove Measure Names from color and Measure Values from Angle. Click the Color shelf and choose white. Adjust the size of the pie down slightly to reveal the donut.







Step 6: Add Region to the Columns shelf and then hide the headers.




Step 7: On the first pie chart on the Marks card, add Region to the Label shelf, set the alignment to the top and make the font bigger.




Step 8: On the second pie chart on the Marks card, add a % to goal measure to the Label shelf and customize the font.




Step 9: Sort Region by the % to goal metric in descending order.



Sunday, 8 February 2015

Tableau Interview Questions


  1. What are the Security Levels?
  2. What is the Data modeling?
  3. How to display to 5 and last 5 in same view?
  4. What are the different  types of connecting data?
  5. What is mean by rightback?
  6. What is the difference between discrete and continuous?
  7. What is the crasstab?
  8. What is mean by interactive dashboard?
  9. What are the limitations of tableau public?
  10. How to reduce complexity of calculated fields?
  11. What to do if we do not have latitude and longitude of a location?
  12. What type of data connections you used?

Tableau interview questions

1.  What is the difference between filter and parameter?
2.  What are the different types of Actions?
3.  What is architecture of tableau?
4.  What are the different security levels?
5.  What is data modelling?
6.  How to display lable of a country in map when it selected?
7.  There are is map and quick filters if we select one country in map it should get selected in quick filter. how to do same?
8.  How to display top 5 and last 5 in same view?
9.  Can we use parameters in filters?
10. What kind of reports you prepare?
11. What are diffrent types of connecting data?
12. How to refresh data extracts?
13. what is rightback?
14. If we connect live will it refresh automatically or do we need to refresh manually?
15. What is difference between discrete and continuous?
16. What is crasstab?
17. What do you mean by interactive dashboards?
18. What is dashboard life cycle?
19. What are the limitations of tableau public?
20. What is difference between tableau public and desktop?
21. What are different products of tableau?
22. what is the use of tableau reader?
23. How to reduce complexity of calculated field?
24. What kind of functions you used?
25. What to do if we don't have latitude and longitude of a location?
26. What type of data connections you used?