interview questions-9

1) Tell me about yourself?

2) are you leading any teams?

3) How you will interact with your customers?

4) What is the critical issue you have faced recently? How did you resolved that?

5) What is the ticket monitoring tool you are using in your company?

6) What is the process to fix a production issue? how you will fix it?

7) What is the advantage of using Tableau for Visualization? Tell me some benefits?

8) Have you lead the teams in the current company?

9) What are all the other technologies you are using for reporting in your organization?

10) What are all the databases you used in your current project?

11) Have you worked on ETL side and what are all you have done in ETL front?

12) Tell me some scenarios when you will work with ETL team and create the tables?

13) What sort of projects you are currently handing? are they all are support/maintenance/Development?

14) are you flexible to work in a support kind of a project?

15) Reason for changing the job?

interview questions-8

1) Tell me about yourself?

2) have you worked on DWH also?

3) What is Star schema and what is Snow Flake Schema?

4) Which Schema are you using it in your company?

5) what is the difference between other reporting tools and Tableau?

6) How is Metadata differed in Tableau and other reporting tools?

7) What is data blending? 

8) what are the filters in Tableau?

9) what is a parameter in tableau? how you will use it?

10) Can you use a group in calculation field?

11) What is meant by sets in tableau?

12) What is the difference between SUM and Windows_Sum ?

13) How to set the user filters?

14) What sort of activities you have performed in Tableau server side?

15) what is the default view in Tableau (desktop/laptopany other)?

16) How you will set the context filter in Tableau Server?

interview questions-7

1) Tell me about yourself?

2) What are the differnet data sources you used in your project?

3) What are the different type of data source connections available in Tableau?

4) What is the difference between TWB and TWBX file types?

5) Can i open TWB and TWBX files in Tableau Reader?

6) What is a filter in tableau?

7) What is the difference between quick filter and context filter? 

8) How many types of actions do we have in Tableau?

9) what is an action filter?

10) what is the difference between Action filter and Context filter?

11) What are groups in Tableau? Can i use groups in a calculated field? or in a filter?

12) What are sets? Can i use it as a filter?

13) What is a heat map in Tableau? 

14) what are parameters, How you will use it in Tableau?

15) what is datablending? what is the primary datasource when you use datablending?

16) i have three tabs in an excel sheet and in this case which technique you will be used? Data blending or Joins?

17) what is the difference between datablending and Joins?

18) what is meant by a site in Tableau server?

19) what kind of challenges you faced while working on the desktop?

20) what is relative date filter?

21) How do you see the time series measures in Tableau?

22) Say i have a country and having many states in it and its sales which chart you will show ?

23) What is bubble chart, Pie chart?

24) how many types of maps are there in Tableau?

25) In DWH, what are the different types of measures available?

26) What is a Star schema, Snow Flake schema?

27) what is web-authoring in tableau server?

28) What does the interactor role wil do ? How will he interact from the server dashboard?

29) What are the differneces between 8.0 and 8.1 version?

30) Say i have a table with column as A and the values as x,y,z and i want to display x as a column in my dash 

    board, how to do that? hint is calculated fields.

31) what kind of activities you did it in server side?

interview questions-6

1) Tell me about yourself?

2) What are the roles and responsibilities in your project?

3) What is the difference betweeen live connection and Extract?

4) What is data blending ? can i do the same with joins?

5) Is it possible to do data blending for the same data source?

6) What is a quick filter, context filter, action filter?

7) what sort of join it will perform in data blending technique?

8) I have a scenario to view the bar chart and a line chart based on the users? how to do that?

9) what are the different actions availbale in tableau?

10) Give me some examples on when do you use what? 

11) How to setup the userr security filter in Tableau?

12) what are the table calculations used in tableau?

13) what are the tasks you have done in Tableau server side?

14) what are the new features available in Tableau 9.0?

15) which version you have used in your project? did you used 9.0 ?

16) what is LOD in tableau?

17) what are the things which you dont like in tableau?

18) how to setup user security filter?

19) tell me an example for parameters in Tableau when you have used?

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])))