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?

Previous Year YTD formula

if [Order Date] <= [date]-365
and DATEPART('year',DATEADD('month',12,[Order Date])) = DATEPART('year',DATEADD('month',12,[date]-365))
then [Sales]
end

Date is the parameter here..

Option 2:

sum(if year([Order Date]) = year([date])-1 and 

[Order Date] <= dateadd('year',-1,[date]) then [Sales] END)

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 ?