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.


5 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. 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
  3. Thanks for Sharing very useful information. Shop Zero Two hoodies

    ReplyDelete
  4. The energy and technology industries are seeing a rise in the use of China Aluminum Foil suppliers. Due to its adaptability and high performance criteria, it finds extensive use in the manufacture of lithium-ion batteries, as well as in the shielding of electronic circuits and building insulation. This flexibility exemplifies the resourcefulness of Chinese aluminum foil producers in catering to modern needs.

    ReplyDelete
Previous Post Next Post