Tableau Interview Scenarios

Hello Everyone,
In this video we will try to solve #tableauinterviewquestions , #Interviewscenarios of #deloitte , #userready, #important
#tableauinterviewplaylist,
#ai
#besthacks,
#bestinterviewtips ,
#interviewpreparation,
#bestchannel,
#interviewtips,
#interviewpreparation ,
#projects
#percentoftotal
#secondmaxsal,
#secondmaxorder,
#dont_forget_to_like_and_subscribe
#tableau
#powerbi,
#powerbiinterviewquestions,
#powerbiinterviews,
#tableauinterviewquestions
#tableauscenarios
#tableauinterviewexperience.
#tableauinterview,
#Tableaudeveloper,
#tcsinterview,
#interviewquestions,
#viralinterview,
#sqlinterview,
#tableauinterviewquestions ,
#assignment_answer_2021
#projects
#Tableau
#DataVisualization
#DataAnalysis
#BusinessIntelligence
#TableauInterviews
#TableauTips
#DataAnalytics
#DataViz
#TableauExperts
#DataInterviews
#TableauTutorial
#BIInterviews
#TableauDashboard
#TableauDeveloper
#DataDevelopment
#DataProgramming
#TableauTutorial
#TableauTraining
#xpressurdata
#tableau
#tableaututorial
#tableaudeveloper
tableau interview
tableau training
tableau desktop specialist exam
tableau interview questions & answers
tableau interview experience
tableau interview questions
tableau developer interview questions
tableau interview questions in telugu
tableau interview questions in hind
tableau desktop specialist
tableau certification
tableau desktop specialist exam questions
lod in tableau
tableau server tutorial
tableau server
interview questions and answers
data analyst
data analyst interview
tableau interview experience
tableau interview questions in telugu
tableau scenario based interview questions
tableau interview questions in english
how to handle fake experience
tableau interview experience questions
tableau lod
sql interview questions and answers

[@lanvinsgivenchy5421]

Thanks a lot !

[@user-kp6jh6gi5z]

Hey rahul thankyou so much for posting such type of questions..a part from LOD we can also give first n last sale by using index() like if INDEX()=1 THEN min([Order Date]) END and last sales date can be identified by last()..ryt?

[@vee109r]

Thanks for such informative in function

[@TechiRahul]

Thanks Veer. Am glad they are helping u

[@vasistakumar5874]

​@@TechiRahul,Rahul are you providing tableau training

[@TechiRahul]

Yes I am

[@vasistakumar5874]

@@TechiRahul Rahul could you please provide us your contact details or email

[@vasistakumar5874]

​@@TechiRahulCould you please provide us your contact details e-mail or number

[@user-zk9um4gb2p]

[Order Date]={FIXED YEAR([Order Date]): MIN([Order Date])}
or
[Order Date]={FIXED YEAR([Order Date]): MAX([Order Date])}

[@user-qj9pj9by7e]

{ FIXED [Order Date (Years)] : MIN([Order Date]) } = [Order Date] OR
{ FIXED [Order Date (Years)] : MAX([Order Date]) } = [Order Date]

[@user-oy4pz7pk9f]

hi..also i want know calculation formula for month wise 1st & last day sale on every year

[@TechiRahul]

IF ( ORDER DATE= {FIXED YEAR (ORDER DATE), MONTH (ORDER DATE): MIN(ORDER DATE)}
OR
( ORDER DATE= {FIXED YEAR (ORDER DATE), MONTH (ORDER DATE): MAX(ORDER DATE)} Then 1 else 0 End. Take the field n drop it on filter shelf and choose 1 u should get only min n max for each year and month provided you have view at year and month level.

[@user-oy4pz7pk9f]

hello, it was very helpful,thank u... also i want know calculation formula for month wise 1st & last day sale on every year

[@TechiRahul]

We can achieve using LOD function.

[@vigneshwaranm5836]

Each year First Sales:
SUM(
IF [Order Date] =
{ FIXED (YEAR([Order Date])): MIN([Order Date])}
THEN [Sales]
END)
Each year Last Sales :
SUM(
IF [Order Date] =
{ FIXED (YEAR([Order Date])): MAX([Order Date])}
THEN [Sales]
END)

[@TechiRahul]

Nice bro keep it up 💪

[@vigneshwaranm5836]

@@TechiRahul Thank you bro. Am learning from your videos, Thanks for the great help and for your time.

[@kinchalsharma3424]

{ FIXED YEAR([Order Date]) : MIN([Order Date]) } = [Order Date] OR
{ FIXED YEAR([Order Date]) : MAX([Order Date]) } = [Order Date]

[@vigneshwaranm5836]

current week till date / previous week sales
IF
[New Orderdate] < TODAY()
AND
DATEDIFF('week',[New Orderdate],TODAY()) in (0,1)
THEN [Sales]
END

[@TechiRahul]

Nice 🤠

[@vigneshwaranm5836]

@@TechiRahul Thank you bro.