If I create my reports in 8.3 can I open in 9.0.0 version? for some reason not able to open the reports..Fix

1. Identify the Workbook which contains the Old connection 2. Identify the Data Source which needs to be edited within the Workbook 3. Save the Data Source to an .XML file (.twbs) on a local file system 4. Open the .twbs file in a Notepad or Notepad++ 5. Create an Excel spreadsheet with the original table names, column names and the corresponding new table and column names 6. Need to search the file for the “Old tables” names listed in the .twbs a. Note down the line numbers or save the output in to an excel or ascii file b. Edit the old columns names also in the entire file c. Edit the join criteria with the right join condition (inner as opposed to full outer) 7. Upon completion of the changes, search for any old values if any 8. Open the .twbs in tableau desktop and ensure that there are no errors 9. Now open the workbook and replace the old datasource with new one.

Interview Questions-11

1) tell me about yourself? we go through your experience?

2) What are the reports yo have generated so far, tell me about the reports you generated in your project?

3) Have you created the rompts?  parameters?

4) Quick filter vs Context filter

5) Duplicates only records ..i need to get usng calculated fields

6) dwh ..dimensions, facts

7) foriegn key where it will be defined?

8) what is primary key and foreign key?

9) what is the difference between right outer join and union all?

10) What is union and what are all the type of joins ?

11) What is a surrogate key?

12) what is measures and dimensions?

interview questions-10

1)      Tell me about yourself? and your roles and responsibilities in the project?

2)      Why do you want to use many data sources in your project?

3)      What is data modelling?

4)      What is Star Schema?

5)      What kind of schema you will be using in your project?

6)      What are all the different data sources you used in your project?

7)      How many ways you can connect to your data sources?

8)      How you will refresh the extracts?

9)      What batch scripts you written to refresh the extracts?

10)   What is data blending?

11)   How many dimensions/measures  you can add as rows  or columns by default?

12)   What are all different actions you have it in Tableau?

13)   How to select top 5 rows?

14)   How to do to select top 5 rows  with filter condition?

15)   How you will do it with filters?

16)   Can I apply the sets as filter in multiple worksheets?

17)   How do you improve the performance of your report? What you will do to fix it?

18)   What are all the actions available and how to use them?

19)   Have  you written customSQL ? How do you use customSQL queries?

20)   Any questions for me?

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

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?