Interview questions-2

1) Explain the difficult scenario which you faced reccently and how you solved it?

2) say we have big bazar in Karnataka and htey have many stores in bangalore. I want to display my view with state, city, store number, monthly sales, order date.

ho will you do that? you have to choose only the three variables in your shelfs.

3) How do you create the year calculated field without heirarchy field?

4) How long you worked in tableau admin side?

5) how do you improve the performance of the report for the same example,lets say ihave 25 mn records? that has 10 yrs of data .

6) if i put context filtes on state level we can filter some values. What if the user wants to dynamically keyin the values and choose the state

   your approach should improve the performance.

7) If you use sets and then filters again you will have the performance issue only right?

8) Once you finish the dashboard how you will place it in the sharepoint or ocs website?

9) What are the dashboards you have created so farand can you tell me what are all the views you used in it?

10) have you written custom sql's ?

11) I want to display the viw in such a way that current year , quarte, month of eachyear with the previous year? how do you do that?

    how do you do that graphically? 

12) what is a dual axis ? 

13) how the context filter work in tableau?

14) how do you use the lookup function in the calculated field.

15) have you created the heirarchies?

16) i have a scenario like lot of duplicates are there in the table and it dont have any referential integrity , unique key, nothing

    i want to remove all the duplicates using the delete statement as an sql? How do you do that? write it in an SQL prompt?

17) have you worked on single sign on?

18) how do you control the access of the user to see only certain reports he is authorized to. Where you will set that details and how you will do it?

19) tell me some workarounds you have done in Tableau?