Tableau Filters-Detail Tutorial including Context Filter, Cascading Filters, Sql |with Practic Ques
ฝัง
- เผยแพร่เมื่อ 26 ส.ค. 2024
- Detailed #tableautraining on #filters, with Practice Questions Below.
Video Discusses on #contextfilters, #datasource , #cascadingfilter, answer in comment questions. #tableaudeveloper ,#dataanalyst ,#datascience and #sql comparision
This video is a detail overview of different filters in Tableau (includes context filters,context,datasource,extract filters). Just within the dimension and measure filters section - you will see quick filters, different control types, different ways to customize. There is also discussion on how we can do it #sql as well.
Even if you are already familiar with some (or many) of these, I hope you will still find these useful!
1. Create a Data source filter where Year=2019 . Build views on this. Year wise, Region wise sales .(Observe if you are getting values of other years or not)
2. Create a Normal filter where cateogry ='Furniture' and build view as cateogry wise sub cateogry wise sales.
a. Allow User to select only 1 Cateogry at a time.
b. Use Drop down view for filter
3. Display list of Sub cateogry items whose Sales is greater 10000
4. Create a filter on Region field in Sheet 1 and apply it to Multiple Sheets Sheet 2, sheet by creating views with Region,Cateogry and Sales
5. Show cateogry wise sales for Year = 2020 and Month= January.
6. Create 3 sheets
sheet1 = Category wise, sub category wise sales
sheet2 = Category wise, Region wise sales
sheet3 = Category wise, Segment wise sales
==. Create filter for Region at Data source level and consider only "North" and "South"
== Allow the end user to choose the filter Category items from sheet 1.
==. Drop the above 3 sheets in Dashboard and share the filter across all the sheets.
7. Create a view Region, Category and sales. Create a Calculated field as Zone
Zone : CASE [Region]
WHEN 'Central' then 'Zone1'
WHEN 'East' THEN 'Zone2'
ELSE 'Zone3'
END
show Zone and Region as Quick Filter. Change Zone filter type and allow user to select only 1 zone at a time. (Validate if Region filter drop down is working effectively when zone is selected or not). Hint: Cascading Filter
9. Display list of Customer whose sales is less than 2500
10.Display List of Customers whose Name is Starting with "S"
11.Display List of Sub categories which contain "O" in them.
12.Display the sales for Year=2017 and 'Central' Region.
13.Display the list of Customers whose sales is in between 5000 and 50000
14.Display sales for last 3 months of data where year=2019
15.Create two sheets as below
Sheet 1= Create Region wise sales
Sheet 2= Create Region wise, category wise Sales.
Drop the two sheets in Dashboard and allow user to select only 1 Region at a time. View should display data based on the region selected by user.
16.Display top 10 customers based on profit
17.Display bottom 10 customers based on sales
#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
Very helpful video
I am glad to hear 😄
very clear explanation...! sorry I have been allowed by youtube to like this video only once. Rahul Rocks..
nicely explained.
Bro hatsoff for your detailed explanation and the examples you are using are simply understandable... Keep going bro... Thanks alot ❤
Thanks Brother
got some wonderful information and idea about filter thanks a lot
Superb 👌
Thanks for watching. Don't forget to like share and subscribe 😄
I am back on this video again, so clear and precise your teachings thanks.
Welcome back
I am enjoying your videos … thanks I am going to listen to all of them this month ❤…
Thank u sir. Usefull vedio
Tkq Sayali 🤝
This video contains good and clarity matters, Thanks
Thanks Rajasekhar
Very helpful video, on context filters I got clarity now
Glad to hear that from you 😊
its very clearly explained for every filter
Thanks Bro
Very clearly described
Tkq Swati
Thanks for the Explanation. can u provide the videos for calculated fields , LOD functions , dual and combined Axis
Sure I will
LOD i have created alrdy in detail u can watch that
Expecting all type of filter explanation in this video
In detail it has along with sql comparison for better understanding and practice questions in description.
We can use underscore operator to get WARD as ename ex LIKE "_A%"
Please make complete tutorial on Tableau
Sure that is my next plan
Sir please make video about All Action Filters
Sure Khushi
Thank you for the video 😀. In sharing filter could you please explain what is the difference between "All using related data source" and "All using this data source "
Sure Brother
Sir can you make video on Empty Extract and their uses.
select *from EMP where ENAME like '_A%'
Sir can you please tell me how to sort two different measures in asc order like sales and profit should be show in asc order
expecting all type filters
All in one video
can u please increase the video quality, things are not visible
It is automatically adjusted bro.. I tried but it is looking good to me.
@neeraj Clarity is good, try to increase the quality in youtube settings to 1080p
@@nagendrapedipina7832 its fine. it was coming as 360p for me. Never mind.
Arts
Envelopes
Labels
Fasteners
Super