Пікірлер
@NaveenkumarNarravula
@NaveenkumarNarravula Күн бұрын
Thanks Rahul, this one serves as a quick recap for my SQL rounds!
@MamathaMuktham
@MamathaMuktham 2 күн бұрын
Bro please do a video with parameters actions as well
@gauravghosh8002
@gauravghosh8002 2 күн бұрын
Thank you so much for this dynamic calculation of YTD , QTD & MTD sir.
@NareskanthM
@NareskanthM 3 күн бұрын
Just knowing the table scoped LOD can be written using Fixed LOD w/o mentioning the dimensions ! Thanks brother !
@VickyKumar-qp2di
@VickyKumar-qp2di 3 күн бұрын
Very helpful video
@TechiRahul
@TechiRahul 3 күн бұрын
I am glad to hear 😄
@rajatsimele
@rajatsimele 4 күн бұрын
Hi Rahul , mene recently new company join kia tha unhone tableau developer bol k muje job di fir waha or unka khud ka BI tool tha uspe bol rahe kaam kro na uski muje training di na koi KT di bolte kro or or jo company ka CEO usne muje gaaliya di maa bhan ki team k call pr ,muje samj hi nai aaya kya kru itni ghatiya company thi wo saare employee pareshaan h usse pr pese k liye kaam krte h bass
@TechiRahul
@TechiRahul 4 күн бұрын
Toxic culture
@shruthisubramanyam214
@shruthisubramanyam214 5 күн бұрын
CGI question: you have built dashboard based on 2 different datasets sql table and excel joined, user has a requirement to refresh the excel file monthly once but in sql table to be refreshed weekly, these 2 datasets are joined how do you handle this situation Rahul, can you please suggest how we can handle above scenario
@shruthisubramanyam214
@shruthisubramanyam214 5 күн бұрын
CGI question: you have built dashboard based on 2 different datasets sql table and excel joined, user has a requirement to refresh the excel file monthly once but in sql table to be refreshed weekly, these 2 datasets are joined how do you handle this situation Rahul, can you please suggest how we can handle above scenario
@alwayssmiling-c2x
@alwayssmiling-c2x 6 күн бұрын
Thank you Rahul ...this video helped me a alot
@shubhamdhole-gl1jn
@shubhamdhole-gl1jn 7 күн бұрын
Bhai but aajkal reste filter dene ki garaj nahi unneesary sheet create karo action do In server we have option reset ka so kam ho jata 😀
@TechiRahul
@TechiRahul 7 күн бұрын
😄😄😄
@soundaryanl6709
@soundaryanl6709 7 күн бұрын
Hi I have interview in affine company for data Analyst role for powerbi role and sql , excel also. Let me help me to clear the interview
@sabavatsrilatha4709
@sabavatsrilatha4709 7 күн бұрын
1.Please make a video on how to test as a tableau developer if row level security is working fine or not for the users. 2. Make a video on empty extract
@shubhamdhole-gl1jn
@shubhamdhole-gl1jn 7 күн бұрын
On desktop level you can used other user n check is able to see all data or not
@davidmuthukaden287
@davidmuthukaden287 7 күн бұрын
Thank you. Where can I find projects to develop a portfolio.
@pawansinghal585
@pawansinghal585 7 күн бұрын
Hi Rahul, Can you tell how can we handle huge volume of data like 300m in our dashboard and it is getting failed to refresh on server not loading the full data in the extract. Can u tell me how to get rid off this let me know if we can connect over call
@manishlakhera8250
@manishlakhera8250 8 күн бұрын
Yes, pls continue in Hindi
@gauravghosh8002
@gauravghosh8002 8 күн бұрын
Very nice video sir but you missed to explain Question number - 4. Kindly explain that question as well in this video or seperate video for question number - 4
@manojdevareddy8831
@manojdevareddy8831 8 күн бұрын
Just now 3 to 4 pm i gave tableau interview for Logitech. He asked me sequence of a sql query executed. Like select, where, group by, order by. Which will execute first and process.. just sharing it might help others.
@TechiRahul
@TechiRahul 8 күн бұрын
Pl share interview questions as well if possible
@dhananjay6657
@dhananjay6657 7 күн бұрын
SQL Sequence Start like -FROM WHERE GROUP BY HAVING SELECT ORDER BY LIMIT
@yasminjahagirdar3868
@yasminjahagirdar3868 8 күн бұрын
Hi, current year means we are getting 2017 to2020, and order date if we chose in datetrnc we are getting2016 to 2019 what it means? means 1 year difference how could we explain it...
@rashmikarde9554
@rashmikarde9554 8 күн бұрын
❤ 4 th question you forgot to explain. How to achieve this, plz explain.
@TechiRahul
@TechiRahul 8 күн бұрын
I am creating scenario videos of these Wil post it there separately.
@manishpawar3822
@manishpawar3822 8 күн бұрын
​@@TechiRahulwe can create a hyper having all filter values and blend it with each hyper then use filters from filter hyper, please suggest any other way
@TechiRahul
@TechiRahul 8 күн бұрын
Pawar Bhai, u mean url action?
@manishpawar3822
@manishpawar3822 8 күн бұрын
@@TechiRahul when we have multiple dash in single wb using diff ds then we can use above approach. when there is redirection to another dash then we cas use url action, in that case need to use keys to pass instead of actual values
@NaveenkumarNarravula
@NaveenkumarNarravula 9 күн бұрын
Screen not fully visible, neither calculation nor report os fully seen
@purushothamreddy.andine9117
@purushothamreddy.andine9117 9 күн бұрын
Is it freshers interview or experienced person's interview, if so how many years
@TechiRahul
@TechiRahul 9 күн бұрын
It was for experience. Number of yrs I don't remember
@purushothamreddy.andine9117
@purushothamreddy.andine9117 9 күн бұрын
I hope it's for 3.5 to 4.5 . Is it right
@manishsathe8371
@manishsathe8371 9 күн бұрын
Q1. How many days Left in month? ----> DAY(DATEADD('month',1,DATETRUNC('month',TODAY()))-1)-DAY(TODAY()) Q2. Filter Reset? ----> We can go with very simple extension. ( can do with actions as you mentioned) Q4. If I apply filter in one dashboard, that needs to get applied on second dashboard? -----> This can be achieved by Go To URL Action, we need to modify URL and then it's possible on server . Thank You
@jigneshchauhan6370
@jigneshchauhan6370 9 күн бұрын
It is very helpful ❤
@Time_Traveller_Dubai
@Time_Traveller_Dubai 9 күн бұрын
We have another way to Reset all filters by using Extension in Object there is also option Reset all button
@TechiRahul
@TechiRahul 9 күн бұрын
There could be. But what if extensions r not allowed? How will you justify to the client when they ask when it is do able within in Tableau why do you need extension?
@sowmya6471
@sowmya6471 9 күн бұрын
Thanks for sharing this 🙏
@TechiRahul
@TechiRahul 9 күн бұрын
You are welcome 🤝
@girisringeri
@girisringeri 10 күн бұрын
Region made as context filter , now if we are filtering context filter then it will take more time to load & this is a disadvantage. But if we make a copy of that region column as Region 2 then if we are filtering Region 2 , will it effect performance? I don't think so. Region (add to context) Made duplicate of this column Region 2 - this column we are using as filter. Since this is not a context filter, how it will perform?
@kameswararaokusumanchi9046
@kameswararaokusumanchi9046 14 күн бұрын
Do you have Virtusa interview questions
@TechiRahul
@TechiRahul 14 күн бұрын
I think already posted
@swapnilkulkarni3244
@swapnilkulkarni3244 15 күн бұрын
Good video. Just a question here. Does Tableau have windows file share based subscription similar to SSRS. Meaning files getting dropped into a shared folder OR if not any custom library in Tableau which can be access controlled user wise.
@sanjibmohapatra-k1j
@sanjibmohapatra-k1j 17 күн бұрын
In tableau we can use Look up function
@TechiRahul
@TechiRahul 17 күн бұрын
Super
@debuvlogs20
@debuvlogs20 17 күн бұрын
Thank you
@rashidshaikh4042
@rashidshaikh4042 18 күн бұрын
The way u smile as mister x and c
@polenandini3257
@polenandini3257 20 күн бұрын
Hello Rahul, For the 2nd question we can go for the shorter IF SUM([Sales])=WINDOW_MAX(SUM(Sales)) THEN 'Green' ELSEIF SUM([Sales])=WINDOW_MIN(SUM([Sales])) THEN 'Red' ELSE 'Grey' END This way also we can go
@bharathbathini8665
@bharathbathini8665 22 күн бұрын
min Sale {fixed MONTH([Order Date]),[Category]:min( {fixed MONTH([Order Date]),[Category],[Sub-Category]: sum([Sales])})} Max Sales: {fixed month([Order Date]),[Category]: MAX({fixed month([Order Date]),[Category],[Sub-Category]:sum([Sales])})} Flag: if sum([Sales]) = sum([maxsales]) or sum([Sales]) = sum([Min Sales]) then 1 else 0 end
@TechiRahul
@TechiRahul 22 күн бұрын
Kirak
@steveyuan2645
@steveyuan2645 22 күн бұрын
I think you could use table calculation, which will be more faster.
@lazartableau
@lazartableau 22 күн бұрын
Hi Man this is very useful for me.. thanks - post videos like 8 -Aug months 2024
@prashantthakare6071
@prashantthakare6071 23 күн бұрын
IF sum([Sales]) = WINDOW_MAX(SUM([Sales])) THEN 'Max' ELSEIF sum([Sales]) = WINDOW_MIN(SUM([Sales])) THEN 'Min' ELSE 'Other' END Highlight max and min sales of each sub-category
@NaveenT-t2i
@NaveenT-t2i 23 күн бұрын
Hi Rahul, not getting calls on Tableau. When can we expect more calls any idea ?
@florincopaci6821
@florincopaci6821 23 күн бұрын
Hi Rahul Much shorter for the last question: DATEADD('month',1, datetrunc('month',today()) )-1
@TechiRahul
@TechiRahul 23 күн бұрын
@@florincopaci6821 super nice to see alternatives
@shilpadevi4390
@shilpadevi4390 24 күн бұрын
Hi Rahul, just a small confirmation here...the second question was to display the min and Max for each sub category month wise right?...the solution suggested will not consider month as of now Please correct me if I am wrong
@TechiRahul
@TechiRahul 24 күн бұрын
@@shilpadevi4390 yes you have to add month in the view and in calculation as well then it will work. Calculation will remain same however.
@NareskanthM
@NareskanthM 24 күн бұрын
Hi Rahul brother ,,I tried this formula for the first question IF SUM([Sales])= WINDOW_MIN(SUM([Sales])) OR SUM([Sales])=WINDOW_MAX(SUM([Sales])) THEN 1 else 0 with Results calculated at the subcategory level..
@TechiRahul
@TechiRahul 24 күн бұрын
@@NareskanthM nice
@user-ni8ek5nf1v
@user-ni8ek5nf1v 24 күн бұрын
Please create video on Data Blending and Joins
@Time_Traveller_Dubai
@Time_Traveller_Dubai 24 күн бұрын
For top 2 rank(sum(sales),'desc')<=2
@TechiRahul
@TechiRahul 24 күн бұрын
@@Time_Traveller_Dubai nice 🤠
@vidn9869
@vidn9869 24 күн бұрын
please make a interview video for each level of experience, such as freshers to experience and what are the responsibilities each roles will have ? so that we can prepare for interview
@NitishKumar-k6k5k
@NitishKumar-k6k5k 26 күн бұрын
Hi Rahul, Greetings of the day!! Request you to share latest superstore data with 2024
@dhananjay6657
@dhananjay6657 27 күн бұрын
One comman questions asked in Interview - How you connect Tabeleau with Oracle or SQL Server. I am confused with this question single line answered not satisfied. Please suggest how to explain
@kameswararaokusumanchi9046
@kameswararaokusumanchi9046 27 күн бұрын
How many interview rounds in JP Morgan ?
@Gyansagarsangam
@Gyansagarsangam 27 күн бұрын
Hello, Could you please let me know how to gather data of any company which is publicly available? if possible can you make a video on it or suggest any video. thanks in advance.
@sabavatsrilatha4709
@sabavatsrilatha4709 28 күн бұрын
Please make a dedicated video on below topics: 1: tell me the 3 challenges u faced in developing the report and how you solved it. 2: explain the scenario where u worked out of box. 3. Can we use multiple parameters at a time.
@user-gj5ds9wh4r
@user-gj5ds9wh4r 28 күн бұрын
1)Please add summarised video of join and blending. 2) If the question is repeted many videos please make copy of that answer in the video itself .it will easy to revision purpose. Thanks for making tableau videos. We never forget about this channel while attending interviews 🎉❤ Love from Andhra Pradesh ❤
@Sreekanthnaiduu
@Sreekanthnaiduu 28 күн бұрын
Please post SQL questions as well, bcz more than tableau it is becoming difficult to answer SQL related answers. Interview panel is expecting advanced SQL from the candidate. I have a personal experience of getting rejected when it comes to SQL questions😢
@TechiRahul
@TechiRahul 28 күн бұрын
Sure, I will share
@Sreekanthnaiduu
@Sreekanthnaiduu 28 күн бұрын
@@TechiRahul thank you 😊
@homies3136
@homies3136 21 күн бұрын
Same here bro sometimes they don’t even ask you about bi tools speaking from my personal experience
@akhichaudhari5361
@akhichaudhari5361 20 күн бұрын
Exactly, They expect advanced SQL knowledge from BI Developer. even they judge you on basis on sql. I am also getting reject on basis on 1 or 2 sql questions.
@TechiRahul
@TechiRahul 20 күн бұрын
@akhichaudhari5361 next 10 videos on SQL