Tableau : Extract Data and Filter - How to create filter and Visualise stats in Tableau

Extracts are saved subsets of data that we can use to improve performance - we can reduce the total amount of data by using filters and configuring other limits.

How to create Extract in Tableau(Desktop version) :-
1.  Right click on Data source listed under Data tab and select Extract Data
2.  Select default or modify config for selecting specific  set of records and click Extract.

How to use a filter for all Worksheet?
Right click on Filter -> "Apply to Worksheets" ->  Select "All using this datasource"
Now this filter will be available for all worksheet throughout if data source is used on the working area.

Filter data source and visualise in Tableau 
1. Download data source - Unemployment Statistics
2. Open Tableau and Import excel as data source. Create extract as suggested above. On creating extract by default it will be used.
3. Drag Unemployed field from Measures section to rows shelf and drag Period from Dimensions to Columns shelf. By default, Line chart will be created in Working area.Change line chart to Area chart.
4. Drag Age from Dimensions to Filter area and select at least one age range. Right click on filter created and select Show Filter. Drag Age filter below Marks area.

5. Drag Age in Label and Color pallet and select different age range from filter and observe Area chart. Below area chart created with three age range.


6 Comments

  1. The blog you have shared is incredibly helpful. The tips you have shared related to web development is really informative. Thanks for sharing this blog!
    Hire Phonegap Developer
    Hire Cake Php Developer
    Hire Dedicated Developers
    Dedicated Magento Developer
    Hire Cake Php Programmer

    ReplyDelete
  2. I am impressed by the information that you have on this blog. It shows how well you understand this subject.
    data analytics course
    data science course
    big data course
    big data course
    360DigiTMG

    ReplyDelete
  3. Two full thumbs up for this magneficent article of yours. I've really enjoyed reading this article today and I think this might be one of the best article that I've read yet. Please, keep this work going on in the same quality.
    data science course in malaysia
    data science certification
    data science course malaysia
    data science malaysia
    data scientist course malaysia

    ReplyDelete
  4. Thanks for Sharing very useful information. Shop Zero Two hoodies

    ReplyDelete
  5. I really appreciate your information which you shared with us. If anyone who want to create his/her career in python So Contact Here-+91-9311002620 Or Visit our website https://www.htsindia.com/Courses/python/python-training-institute-in-south-delhi

    ReplyDelete
Previous Post Next Post