Data dashboards

Brief word on use of data dashboards

Dashboards are often very helpful tools for analysts to explore large datasets, test hypotheses and view trends or patterns. They can also help us automate and reproduce repetitive tasks, save time that can be reallocated to more meaningful work and help manage frequent ad hoc time-limited requests/demands more easily. Quite often, however, when they are created to be unleashed across an entire organisation, they require more thought. Considered below are a few possible challenges that may arise when creating dashboard content:

Solutions? Two of the best opportunities for analysts (I think) are ensuring that you are working closely with the end-user and understand their needs (not always possible, in which case be clear about limits and deficiencies when delivering something that has been produced in response to a rigid or prescribed scope); and make yourself available to teach-end users how to navigate, understand and leverage your product to meet their needs. 

For strengths and opportunities, recommend a skim of the article Is Your Company Too Dumb To Be Data-Driven?

Exploring use of force data (Powerbi)

Example UoF dashboard which allows exploration of police use of force outcomes (force presented, force used, subject injured, officer injured) in relation to contextual factors (location, reason for force, impact factors, subject conduct, subject gender and ethnicity). The Microsoft PowerBI template for this dashboard can be downloaded from the following link (filesize:67MB).

homicide map explorer (tableau)

Experimental visual created to view homicide point data alongside demographic and socio-economic variables aggregated to small neighbourhood geographies. Main use would be to test assumptions regarding homicide correlates and view geographic patterns, using the map as a heuristic tool. Dashboard and underlying data can be downloaded here (filesize:804KB).