Skip to main content
Featured group

Tableau Virtual Public Sector

User Group board | Tableau virtual Public Sector

while working on school task , could't clean data it shows data on html form , how can we clean it so it shows data in a normal form ?how to clean data  in tableau ?

9 answers
  1. Feb 7, 2024, 7:43 AM

    Hi @Naoufel Am​ , Cleaning the Data can be performed in Tableau Prep and then you can import the Tableau Prep file to Tableau Desktop. You can use Tableau Prep in the license of Tableau Desktop only. To download, install and use Tableau Prep, please refer to the below links:

     

    Regards,

    Garvit

0/9000

⭐️ Tableau Community Forums Moving to Trailblazer Community ⭐️

Exciting news - we're moving to a new Neighborhood in Trailblazer Community on November 15, 2025.

  • Create your Trailblazer account before November 7th to ensure your historical content moves with you
  • Check out the FAQs and Walkthrough Guide for more details
0/9000

US Public Sector Tableau User Group | Mar-5-2024

RSVP here

0/9000

Take a look at USEReady Accelerator Pixel Perfect Report.

Pixel Perfect can help solve the ‘Last Mile’ Reporting need in Tableau. It can support:

  • One Click Print ready reports in Tableau
  • Make reports available in popular export output formats like pdf, ppt, excel, csv, doc and html etc.
  • Paginated Reports with Page Numbers, Page Breaks & repeatable headers 
  • Flat Reports with no limitation to the number of rows or columns

Watch its 2 minutes video https://www.youtube.com/watch?v=A0qBnPiXHHs

To experience the workflow please visit our Tableau Server

Username: PPR_Explorer

Password: PPR@Useready#321

www.youtube.com

0/9000
2 answers
  1. Jan 5, 2023, 1:35 AM

    Hi Matthew,

    Looks like we missed your post somehow; apologies! I downloaded some example GIS .shp files from the HUD COC (Continuum of Care) site here. It appears that they're broken up into individual polygons, so for California there are forty-four (44) separate files. Fortunately, in Tableau, so long as they're identical in data structure/format, we can UNION those files together. So no problem there.

     

    The other part is more tricky and you'll need zip codes that are mapped to a lat/long value. You can get a set of them from here (just attribute the site for use): https://simplemaps.com/data/us-zips

     

    So in the example (attached), I joined the US zips (by MAKEPOINT() calculation) and the GEOMETRY from the two files and did a full outer join using the older join method, not the newer Relationships model:

    Hi Matthew,Looks like we missed your post somehow; apologies! I downloaded some example GIS .shp files from the HUD COC (Continuum of Care) site here.Then go to Worksheet 1 and drag over Geometry from the .shp file. Then create same MAKEPOINT() calc again for the zip code points. Drag that over to the canvas/view. You'll see a new Map Marks drop zone highlight up in the upper left corner of the map. Just drop that calc on that drop zone and the zip codes should populate automatically with a circle for each point (lat/lon). Thereafter we can use the new INTERSECTS function to help determine if the zip codes fall within a particular HUD COC or not. Simple boolean function:

     

    Intersects?

    INTERSECTS([Geometry],[Zip Code Point])

    And, we end up with a nice map of zip code points that fall within the boundaries of the HUD COC:

    ScreenThat could've also been a spatial buffer as well:

    ScreenSo, a variety of things. Hope the attached helps point the way. Best, Don

0/9000

📚 Whitepaper | Putting Data to Work for the Public Sector

The appetite for data has tremendously increased and data insights are becoming the norm. The ability to make strategic decisions backed by data has never been more important. Learn how Tableau empowers public sector employees and management to see and understand mission-critical data when it is needed most.

  • Enterprise analytics: not just for data scientists
  • Building public trust through data
  • Connecting the enterprise
  • Building a data culture
0/9000