Friday, 11 December 2015

Interview questions -12

1. Different phases considered while building the dashboard ?
2. Challenges faced while building the dashboard ?
3. How do you determine the timeline when you get any request to build a dashboard and justify
4. What are the criteria one should consider to build an efficient dashboard ?

Saturday, 28 November 2015

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?

Friday, 27 November 2015

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?