Tableau interview Scenario | LOD

Hello Everyone,
In this video we will try to solve #tableauinterviewquestions , #scenario that were asked in #brillio, #kpmg , #kpittech , #parameter, #tableaudeveloper , #dynamicdate, #dynamic #master
1.%ofTotal Using #LOD
2. #Top 5 cities Using States
#min,#max, #tableau,
#defaultdate,
#challenge,
#interviewquestions , #interviewchallenge
#parameterscenario
Tableau Functions Playlist
• Tableau Training - Fun...
#kpmg,
#viralinterview ,
#capgeminiinterview ,
#tableauinterview,
#Tableaudeveloper,
#interviewquestions,
#tableauscenarios,
#sqlinterview,
#tcsinterview,
#creatingforindia
Please like share and subscribe.
#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
tableau lod
sql interview questions and answers
xpressdata
parameters in tableau
filters in tableau
tableau projects

[@user-qr4vs7ct6r]

Excellent bro... U r doing really a great help

[@TechiRahul]

Tksm Bro

[@matinm0611]

Thank you for solving questions shared by me. Solved same way as explained here. 👍

[@keerthanzyan3347]

Thank u for the video ❤️

[@equiwave80]

Hi Rahul,
Thanks for another useful video.
I just wanted to confirm one point regarding the % of Total scenario.
In case we need to calculate the % of Total for any dimension and not fix it to a specific dimension can we solve it like this
Total Sales = {SUM([Sales])} this is the denominator (Table Scoped LOD)
Percentage of Sales = SUM([Sales]) / SUM([Total Sales])
I checked this Percentage of Sales with both Category and Sub-Category separately and it was working fine.
The Table Scoped LOD concept is very useful for many scenarios and I am guessing it is one of your favorites 😉

[@TechiRahul]

☺️☺️☺️☺️

[@keerthanzyan3347]

Was the interview for the experience role👍

[@matinm0611]

Yes

[@vigneshwaranm5836]

Bhai for state wise top 5 sales, we can use quick table calculation rank in sales measure and drop in filter and choose ranges from 1 to 5.

[@TechiRahul]

Kar sakte hai... there r multiple ways for this.

[@zakirhussain4193]

For % of total you can do like this also na
Sum(sales)/{sum(sales)}

[@zakirhussain4193]

Rather fixing at category level if you fix your denominator than you can get % of total for any dimensions easily.. correct me if i am wrong brother

[@TechiRahul]

Thats another way of solving

[@keerthanzyan3347]

Sir has a freshman can we expect difficult question 👍

[@menghao4576]

Sir, can you post a video for people having 4-5 years of gap after graduation and have learnt tableau to get selected for an interview? Please sir, your advice will really help us.

[@KunalKumarSingh-wr1kg]

Hi Rahul can you please explain following questions asked in Tiger Analytics l3 round
1.whenever we publish dashboards or data source in server where it Store?
2.Like I have used share point in Tableau dashboard and it's stored in my local machine how to refresh or schedule it?
3. Which is faster extract or data source filter. Like we have 10 years of data but we want only 4 years of data in this scenario which is faster?