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.
On this page of the site you can watch the video online Excel: Pivot Table - Temporal Heat Map with a duration of hours minute second in good quality, which was uploaded by the user Grant's Crime Lab 09 November 2020, share the link with friends and acquaintances, this video has already been watched 7,398 times on youtube and it was liked by like viewers. Enjoy your viewing!