Crime Reports

/Tag: Crime Reports

Visualize Baltimore Crime Reports with Power BI

Use Power BI to Visualize Baltimore Crime Reports Using Power BI to Visualize Baltimore Crime Reports With Power BI you can take raw data and quickly transform it into easy to use visualizations.  For this example, I will be using data from the Baltimore police crime reports public dataset that has data points back to 1963.  However, most of the data really starts in 2014.  I wanted to see what I could build from the dataset and spent a few hours pulling together the data and then building reports that enable me to see various trends about Baltimore crime reports. Here is a sample of the Baltimore Crime Reports available for download.  As you can see it is difficult to spot trends and outliers in this format.  If you are looking to visualize your crime report [...]

By |2020-05-17T12:00:14-05:00January 5th, 2020|Business Intelligence, Power BI|2 Comments

Using Power BI to Visualize Houston Crime Stats

Houston Crime Data The city of Houston provides high level details on crime statistics via Excel files on the police website.  These statistics are stored in monthly files available via Excel or Access.  In order to better understand the crime data I created a single Excel file that stored the data from August 2016 to December 2016.  The data is formatted as shown.  I wanted to see what type of information I could learn by using Power BI to Visualize the data. Using Power BI to Visualize the Data Connect to the data in Power BI directly to the Excel file.  To explore summary information build simple data grids that expose the total number of records grouped by hour and date totalling 53,614 offenses.   You should expect to see 24 values for the Hour column and only records from August to December 2016.  By reviewing the data, the hour data [...]

By |2020-05-17T10:42:17-05:00March 27th, 2017|Power BI|Comments Off on Using Power BI to Visualize Houston Crime Stats