Calculate the AREA of your polygons in Tableau and then create charts to compare the sizes.

Sdílet
Vložit
  • čas přidán 3. 08. 2024
  • Using the AREA function in calculations enables you to build charts based on the total surface area of the polygons in your spatial files. This opens up new analytical opportunities and different ways to view and analyse your spatial data. I walk through a few examples with three different spatial sources.
    💾 Data sources
    OS Data Hub: bit.ly/3M7kWBg (select the ESRI Shapefile format)
    Historic England: bit.ly/3so4eWD (Parks and Gardens polygons)
    Natural Earth: bit.ly/3IlCmrI (Land polygons)
    📃 Please refer to the usage and licensing guidance on each site before using these sources.
    Open Government License: bit.ly/3BU1bZx
    Natural Earth terms of use (public domain): bit.ly/35wcvyC
    📊 Visualisations
    London Population Density visualisation: tabsoft.co/3sonAel
    Sample uses of the Area function: tabsoft.co/3hdY5pm
    #30DayMapChallenge: 30daymapchallenge.com/
    📑 Blog post
    Area Function: datavis.blog/2021/06/29/table...
    🔗 Social Media Links
    Blog: datavis.blog ➝ Tableau tips and tutorials
    Twitter: / datavisblog
    Portfolio: public.tableau.com/app/profil...
    LinkedIn: / marcreiduk
    ▶ Subscribe for the latest tips and tutorials: bit.ly/TableauTutorials
    📌 Chapters
    00:00 - Intro
    00:43 - Spatial Data Sources
    00:52 - Connect to data - London Districts
    01:52 - Create AREA calculation
    02:11 - AREA Units - miles, km, metres, feet
    02:42 - Create bar chart with area measure
    04:26 - Create a dashboard including a highlight action
    05:35 - Connect to data - England parks and gardens
    06:15 - Create AREA calculation using ACRES
    06:58 - Create AREA calculation using HECTARES
    07:16 - Importance of polygon accuracy with the area function
    08:30 - Example created for #30DayMapChallenge

Komentáře • 6

  • @DataFam
    @DataFam Před 2 lety +2

    Thx Marc 👍

  • @ahmkamruzzaman5400
    @ahmkamruzzaman5400 Před 2 lety +2

    Good Viz. Is it possible to create a map and bar chart dashboard of drought prone region of a country or vegetation or forest areas of a country. Could you please make a video on it.

    • @MarcReid
      @MarcReid  Před 2 lety +1

      If you have the drought data for those regions and the relevant shape files it should be possible. It's not something I plan to make a video right now but if you download the workbook I used (link in description) you should be able to copy the same approach. Hope it helps!

    • @ahmkamruzzaman5400
      @ahmkamruzzaman5400 Před 2 lety

      @@MarcReid Thanks a lot. Do you know any source of drought spatial data at country lavel? Thank you once again for your great viz.

    • @MarcReid
      @MarcReid  Před 2 lety

      No I don't, sorry. Google is the way to go.