Interview Questions-5

1. Tell me about yourself?
2. What is your roles and responsibilities in this current project?
3. What are the activities you have done while doing mentoring?
4. Did you do any development apart from managing?
5. how many hours you  work on an  average on management vs development?
6. How many workbooks you have developed?
7. How many dashboards you have developed?
8. How many worksheets each dash board contains?
9. How you will fit 6 to 7 sheets in a single dash board?
10. What kind of paper you will use for printing? Have you printed any dashboards?
11. In a tableau server, when i am trying to print the dash board i am getting a blank page..why?
12. what is a filter and what is a parameter?
13. what are sets and groups?
14. can i select multiple parameter values and drag it to the calculation field?
15. what are all the calculation functions you have used in tableau?
16. can i use a group in the calculation fields ?
17. what is the work around if you want add the groups in the calculation fields?
18. what are all the different actions you have it in Tableau and explain?
19. when you have a table and only 1 dimension and ten values, when you apply a quick filter how many values
20. you will get in quick filter?
21. can i insert a dashboard in to an another dashboard?
22. how do you improve the performance of the workbook? 
23. what are the improvements from the end user perspective when you compare it with 8.2 version WRT 9.0 version?
24. what kind of a views you developed in the dashboard? have you used any lines, graphs, charts etc?
25. when you printed your dashboard, you have a large fonts and your customer wants to change it? what you will do here?
26. what color pallet you have used by default?
27. Have you developed any custom colors and how did you do that?
28. Have you developed any custom images and explain how did you do that?
29. what are all the databases you have used in your project?
30. when you use excel, which contains 100 columns and you want only 10 columns ? how do you do that?
31. can i use customSQL here for excel to pull only 10 columns? 
32. we have 2014&2015 data ,now we can restrict 2014 data,in our dashboard we use only 2015 data only ,how can we restrict that 2014 data.
33. .we take some state sales in that we have NULL values ,now how can we delete NULL values in wrksheet ?
34. .we can use buttons in tableau?if yes how?i want 1 button in one dashboard ,we can select that button it will shows related information in dashboard 2....how?
35. I have a table and i want to  create an another table by using the data from the first table. How do you write the query?
36. .I have a table with 2 columns and 100 records, i have the table b with the same data . Now, I have to use both the tables only once in the query and fetch the records. How many queries you can write, ? how many ways you can write the sql queries, and what are all the results you can get from this?
37. Have you worked on Data Analysis rate yourself?
38.  Any questions for me?
39.  difference between sum and windows sum.
40. What is the default colour pallet in tableau? what are all the other color pallets you have used?

Interview Questions -4

1) Tell me about yourself?

2) Which schema will be good for performance wise? Snow Flake Schema

3) Write a query to display top 3 employees by salary?

ELECT  *FROM 

    (

    SELECT *FROM emp 

    ORDER BY Salary desc

    )

WHERE rownum <= 3

ORDER BY Salary ;

4) Write a query to display 3rd highest salary in an emp table?

 

Select TOP 1 Salary as '3rd Lowest Salary' 

from (SELECT DISTINCT TOP 3 Salary from Employee ORDER BY Salary ASC) 

a ORDER BY Salary DESC 

 Select TOP 1 Salary as '3rd Highest Salary' 

from (SELECT DISTINCT TOP 3 Salary from Employee ORDER BY Salary DESC) 

a ORDER BY Salary ASC 

5) Have you worked on Tabcmd? what and all yu have done?

6) how do you refresh an extract from the Tableau server using Tabcmd and what are the different arguments or parameters 

we need to pass to it?

7) what is a filter and what is an action filter? 

8) what is data blending and how do you customize the common field for data blending?

9) I have a dimension called products and i have to display top 5 products and the remaning as others? In a single

 view ..how do you do that?

10) what is adhoc analysis or reporting? 

11) I have a database and i have to setup the environment for my customers who willdo the adhoc analysis? How do you do that?

12) Can i pass the parameters to an URL?

13) How do you setup the User security filters in Tableau?

14) what is a data source? Have you ever sseen a datasource in tableau server?

15) what are all the different steps you will take to improve the performance?

16) how do you improve the performance of calculation fields?

17) can i use parameters on  a secondary source (data blending) columns?

18) when you publishing the workbook..do you need to sign on to Tableau server?

Calculate the number of days in a year formula

DATEPART(‘dayofyear’,DATE(“12/31/”+DATENAME(‘year’,[Order Date])))

Interview Questions -3

1) Tell me about yourself?

2) How did you learned tableau? who gave the training?

3) How many dashboards you have created so far? what is your team size? 25 is your share or the entire teams share?

4) What is TDX file?

5) What is the size of the data extracts you used in your project?

6) what are the different sources you used in your project?

7) say suppose i am using a live connection and how you will refresh the data?

8) How frequently you will refresh your extracts? do you have any data extracts like daily , weekly , monthly?

9) i conencted the source with a live conenction and how tableau will refresh the data when ever updates happened at the database level?

10) have you used sets? explain with a scenario?

11) what the different functions available in quick table calculations?

12) what is a context filter? what are the advantages and disadvantages of using context filter?

13) what is a parameter and tell me where and all you can use it ? asked multiple scenarios/example when you will use parameters?

14) what is an action filter? 

15) what is an user filter? where do you implement the user filters?

16) what is the advantage of quick filters?

17) Explain how you will create the waterfall chart, including the calculations or formulas you use to achieve it?

18) what is content chart? 

19) what are all the different type of actions you have it in Tableau? explain each one of it?

20) I have a dashboard and my user when clicked on something it should navigate to another view? how do you do that?

21) what si network chart in tableau? do we have any other types of charts in tableau which were not available in Show me?

22) when you use excel, sql, db2, access which one will give better performance while extracting?

23) what is data blending? what are the limitations we have if we use data blending? 

24) what is the difffernce between data blending and the table joins? why do we go for data blending?

25) what is a path shell?

26) what is a page in tableau?

27) how do you publish your workbook to the server? who will do that?

28) do you invovle in publishing the workbooks in the server and share it with your customer using a web link?

Average of Last Day, Week, Month, quarter formula

Past day:

zn(LOOKUP(AVG(IF [Date] >= ([End Date] -1) then [Sales] END),0))

Past month:

zn(LOOKUP(AVG(IF [Date] >= ([End Date] -30) then [Sales] END),0))

Past Week:

zn(LOOKUP(AVG(IF [Date] >= ([End Date] -7) then [Sales] END),0))

90 days avg:

IF [Date] >= ([End Date] -90) then [Sales] END

End date is a parameter and Date is coming from the source like Order date in Sample Superstore.

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?

Interview questions-1

1. Tell me about yourself briefly ? an the project which you are currently working on Tableau ?
2. What is the size of the data extracts do you have in your project?
3. How many rows for 3.5 gb data extract means ..it will be huge right? 
4. I have a geographic field, sum(sales), I need to display the comparision between current year and previous year, And i ahve a filter on
5. quarter from 2014 Q1 thru 2015 Q1? How would you achieve it?
6. If i filter the data for 2014 q1 thru 2015 q1 then how you will display the data for all previous years?
7. When you use a calculated field, how tableau knows internally it has to compare with previous years sales? what is the tableau background process that 
8. happens in this scenario?
9. How do you create a calculated field to compare the current year with previous year? What function you use to do it?
10. Can i have a dynamic values in parameters? 
11. I have a dashboard with 5 views in it and when i select the dropdown list and select one view it should display that view alone. How to do that?
12. When you will use ATTR function?
13. I have a region . discounts and product heirarchies ..which one you will choose to have a context filter?
14. Say i have used two context filters and how Tableau knows that it will create first one yuo choosed and based on that the second context filter to act?
15. Have you worked on the server side?
16. Do you have any questions for me?
17. how do you check the performance of the dashboard?what you will do to improve the performance?
18. what are the different functions available while creating a calculated field?