Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
11-21-2023 15:16 PM
In crafting this dashboard, my primary objective was to present viewers with a comprehensive overview of shooting incidents in the United States since 1982, pinpointing their locations. Beyond this geographical emphasis, I aimed to address immediate queries that may arise, such as the total number of incidents, the presence of casualties, and the extent of injuries sustained. Additionally, I delved into the crucial aspect of the shooter's racial background, aiming to discern patterns or trends in these incidents. Striking a balance between providing substantial information and avoiding overwhelming the user, I ensured that the dashboard serves as a valuable tool, bridging the gap between raw data and actionable insights. The intention was to create a platform where users could effortlessly glean information that would be challenging to extract through manual data manipulation in tools like Excel.
I have crafted two primary visualizations within my dashboard. The first focal point is a dynamic map, where I represent the cumulative number of fatalities in each state using bubbles. The size of each bubble is indicative of the death toll, and a sophisticated color-coded scheme reflects the race of the shooter. Given the complexity of multiple incidents in each state, attributed to different shooters of varied races, I've ingeniously designed the bubbles to take the form of pie charts. Each segment of the pie precisely illustrates the total fatalities resulting from incidents involving individuals of a specific race. Hovering over each pie slice reveals comprehensive details, including the state, race of the shooter, fatalities, the count of injured individuals, and the overall number of victims.
Complementing this intricate map, the second visualization manifests as a straightforward yet impactful bar graph. This graph succinctly portrays the total count of unique shooting incidents per state. On hovering over a bar graph, tooltip shows the exact numbers.
Moreover, to enhance user interaction and analytical flexibility, I've incorporated a Year filter. This feature empowers users to selectively choose a specific year range, dynamically refreshing data in both visualizations and enabling a nuanced exploration of the evolving patterns and trends in shooting incidents over time.
eyJrIjoiYTYxOTQyMDUtYWU5Ni00NWNhLTljN2UtODU5MjI5YzE2OWVkIiwidCI6ImVlMmQ2ZDcyLTk1MzUtNDI0Mi1hMDc3LWFjZjE4NTc4MmY5YiIsImMiOjF9