class: center, middle, inverse, title-slide .title[ # ISA 401: Business Intelligence & Data Visualization ] .subtitle[ ## 19: Charts Used for Spatial and Spatiotemporal Data ] .author[ ###
Fadel M. Megahed, PhD
Professor of Information Systems and Business Analytics
Farmer School of Business
Miami University
@FadelMegahed
fmegahed
fmegahed@miamioh.edu
Automated Scheduler for Office Hours
] .date[ ### Fall 2024 ] --- # Learning Objectives for Today's Class - Explain the different types of spatial plots - Select suitable spatial graphs for different scenarios - Understand how spatiotemporal plots can help in storytelling (what makes BI special) --- class: inverse, center, middle # Spatial Plots --- # Choropleth Maps Maps where areas are **shaded, colored, or patterned** relative to a data attribute value. <div class="figure" style="text-align: center"> <img src="data:image/png;base64,#../../figures/ch1.png" alt="Charles Dupin's Illiteracy in France Choropleth, created in 1826" width="40%" height="40%" /> <p class="caption">Charles Dupin's Illiteracy in France Choropleth, created in 1826</p> </div> --- count: false # Choropleth Maps Maps where areas are **shaded, colored, or patterned** relative to a data attribute value. <div class="figure" style="text-align: center">
<p class="caption">Population Density in U.S.</p> </div> --- # Cartograms A cartogram is a map in which **areas are scaled and distorted relative to a data attribute value** <div class="figure" style="text-align: center"> <img src="data:image/png;base64,#../../figures/cart1.png" alt="The First Cartogram – Emile Levasseur, 1868" width="40%" height="40%" /> <p class="caption">The First Cartogram – Emile Levasseur, 1868</p> </div> --- count: false # Cartograms A cartogram is a map in which **areas are scaled and distorted relative to a data attribute value** <div class="figure" style="text-align: center"> <img src="data:image/png;base64,#../../figures/cart2.png" alt="The NYT's U.S. House Election Results 2018" width="50%" height="50%" /> <p class="caption">The NYT's U.S. House Election Results 2018</p> </div> --- # Proportional Symbols Map <div class="figure" style="text-align: center"> <img src="data:image/png;base64,#../../figures/prop1.png" alt="The NYT's U.S. Coverage of the Bush Vs Kerry Presidential Elections" width="70%" height="70%" /> <p class="caption">The NYT's U.S. Coverage of the Bush Vs Kerry Presidential Elections</p> </div> --- count: false # Proportional Symbols Map <div class="figure" style="text-align: center"> <img src="data:image/png;base64,#../../figures/prop4.png" alt="The NYT's U.S. Coverage of 2009 Super Bowl" width="63%" height="63%" /> <p class="caption">The NYT's U.S. Coverage of 2009 Super Bowl</p> </div> --- class: inverse, center, middle # Spatiotemporal Maps --- # Spatiotemporal Maps <div class="figure" style="text-align: center"> <img src="data:image/png;base64,#../../figures/crash_anim.gif" alt="A visualization of car crashes in the Cincinnati metro area" /> <p class="caption">A visualization of car crashes in the Cincinnati metro area</p> </div> --- count: false # Spatiotemporal Maps <div class="figure" style="text-align: center"> <img src="data:image/png;base64,#../../figures/animatedVaccineMap.gif" alt="COVID vaccination rates per county as reported by the CDC" width="70%" height="70%" /> <p class="caption">COVID vaccination rates per county as reported by the CDC</p> </div> --- class: inverse, center, middle # Software Demo --- # Exploring the Cincy Crashes Dataset Let us use Tableau to explore the [cincy_2023_crashes.csv](https://miamioh.instructure.com/courses/223961/files/33509089?module_item_id=5501604), where we will create the following: - A calculated field titled `unique_count` - A plot of the total number of unique crashes per day - A table of number of unique crashes by week day - A table of number of unique crashes by week day - An animated symbols map --- # Bonus: A Calendar Plot in PowerBI Let us use
inside Power BI to create this based on [cincy_daily_crashes.csv](https://miamioh.instructure.com/courses/223961/files/33509210?module_item_id=5501623). <img src="data:image/png;base64,#19_spatial_and_spatiotemporal_charts_files/figure-html/calendR-1.png" style="display: block; margin: auto;" /> --- class: inverse, center, middle # Recap --- # Summary of Main Points - Explain the different types of spatial plots - Select suitable spatial graphs for different scenarios - Understand how spatiotemporal plots can help in storytelling (what makes BI special)