US and Canadian Strong & Violent Tornadoes, 1980-2009

PatrickKerrin — Mon, 08 Jan 2018 17:53:39 GMT

Strong & Violent tornadoes have F3 and greater damage ratings on the original Fujita Scale. A multi-tab visualization suite is provided for US and Canadian Strong & Violent tornadoes, using separate source, non-common datasets.

One tab is dedicated to interactively map the starting locations for individual events, while additional tabs provide interactive seasonal and annual summaries.

DATA SOURCES & DATA PREP

Publically available Environment Canada & US Storm Prediction Center historical tornado datasets are used where years overlap (1980-2009). Both datasets were wrangled to ensure common element type & form, and to add fields that support lookup tables to drive user interactivity and cross-filtering. Various DAX Measures were created to support a range of dynamic calculations.

VISUALIZATIONS

User Slicer, Legend, and Visualization Element mouse selections drive cross-filtering and dynamic calculations on all tabs. Users can also filter by Country.

Tab ‘Map’: Each bubble shows the starting lat/lon location for the event, color coded by F-Scale rating, along with a Monthly Summary. Users can multi-select Months and F Scale ratings for custom analysis.

Users can mouse over/click on any bubble for more event details with tooltips and in the Matrix visualization.

Tab ‘Annual Summary’ dashboard.

Tab ‘Seasonal Summary’ dashboard.

STORIES

The visualizations reveal:

In the USA, high-end events generally peak in spring, with a second, smaller peak often appearing in late fall.

In Canada, high end events peak in summer.

For this dataset we see variability of US events from a monthly, seasonal, and annual perspective, with an even greater annual variability of high-end Canadian tornadoes.

Maps allow the user to investigate deeper into regional events. Multiple month selections support flexible timeframes, while auto-zooming highlights where events occur (users can also zoom manually at anytime to investigate event clusters or regions). These functions allow users to seek/define their own stories.

eyJrIjoiNzNiZjg1NjItMWY0ZS00MTUyLWE2OTctNmY0NDBlY2FiNTMxIiwidCI6ImJlMjM3M2Y5LWQ2M2YtNDAxMC04ZGZmLTcyOTk3NWMxMjMzYiIsImMiOjN9

Re: US and Canadian Strong & Violent Tornadoes, 1980-2009

Anonymous — Fri, 10 Feb 2017 21:55:23 GMT

The Zip file contain a lot of files. However I did not see the PBIX files. How to use those files which in the ZIP

Thank-you

Kenneth

Re: US and Canadian Strong & Violent Tornadoes, 1980-2009

ironryan77 — Thu, 23 Mar 2017 15:55:09 GMT

I love the map (on the first page) and I looked at the PBIX file, but can you provide a PBIVIZ file for the map also so that I can recreate on my report?

topic US and Canadian Strong & Violent Tornadoes, 1980-2009 in Data Stories Gallery

US and Canadian Strong & Violent Tornadoes, 1980-2009

Re: US and Canadian Strong & Violent Tornadoes, 1980-2009

Re: US and Canadian Strong & Violent Tornadoes, 1980-2009