VizWiz

Launch, grow, and unlock your career in data
Showing posts with label shapefile. Show all posts

May 4, 2023

Tableau Techniques for Top Notch Spatial Analytics

No comments
Looking to level up your data visualization skills? Enjoy this live stream from the April 2023 Analytics Tableau User Group (TUG) where I dive deep into spatial data analysis in Tableau!

In this session, I will walk you through the process of importing and visualizing spatial data in Tableau. You'll learn how to use advanced mapping techniques to create powerful and visually stunning visualizations that tell compelling stories with your data.

I cover everything from basic mapping to advanced geospatial analysis, so whether you're a seasoned pro or just getting started with Tableau, you'll walk away with a wealth of knowledge and practical tips you can apply to your own data analysis projects.

Don't miss this opportunity to learn from me and take your data visualization skills to the next level. Watch now and start unlocking the power of spatial data analysis in Tableau!

Download the workbook and data sources to follow along.


MEMBERSHIP PROGRAM

Join my exclusive membership program for data analytics and visualization professionals. The membership program provides unparalleled access to tutorials and templates, curated content, an online community, webinars, expert guest speakers and live training with me.

My program is the best platform to learn, grow, unlock your potential, and succeed in your career.

Sign up or express your interest @ andykriebel.com

July 24, 2017

Visualizing 909 Weeks of the U.S. Drought Monitor

1 comment
Intentional practice is the ONLY way to become a master of something. For me, as I'm learning new Tableau features or wanting to improve my Alteryx skills, I look for opportunities to learn.

This weekend I wanted to learn how to combine 909 shapefiles into a single shapefile with the goal being to create a motion map of the US drought. As of this writing, Tableau doesn't have a way to union shapefiles, so this was a chance to practice Alteryx.

Here's a video of the motion map, followed by details of how I created it.



I started by going to the Drought Monitor website and downloading the weekly shapefiles for each year. These all comes down as zip files, which when you unzip show other zip files that need to be unzipped. That part is simple. Now, how do I go about combining them into a single shapefile?

This is where Alteryx is super handy. Notice how simple my workflow is. Damn Alteryx makes this work easy!

Six tools to combine 909 shapefiles! Amazing! Now that I have a single shapefile, all I need to do in Tableau is:

  1. Filter to a single date
  2. Double-click the Geometry field
  3. Add the Intensity field to the Color shelf
  4. Zoom to the continental US
  5. Change the background map to a custom Mapbox map I created that only shows the state borders

Boom! That's it! Super simple! Caution: This may be super slow to render.


I also thought it would be cool to see every week at the same, meaning 909 maps in a single view. I had to hack the Tableau workbook XML to make the dashboard 8000 pixels wide and the view is super slow to render, so you've been warned if you click on the image below.