Excel: Pivot Table - Temporal Heat Map
In crime analysis, it is common to explore the day of week and time of day crime occurs. This video provides a walkthrough of how to create a pivot table and use a color scale to identify peak time of day/day of week. The crime data are from Houston, TX for 2017.