1 / 10

2019 WesternITE Annual Meeting Presented by Yung Koprowski, PE, PTOE, RSP

Crash Analysis Using Business Intelligence (BI) Data Analysis Software. 2019 WesternITE Annual Meeting Presented by Yung Koprowski, PE, PTOE, RSP. Crash Analysis.

jparker
Télécharger la présentation

2019 WesternITE Annual Meeting Presented by Yung Koprowski, PE, PTOE, RSP

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Crash Analysis Using Business Intelligence (BI) Data Analysis Software 2019 WesternITE Annual MeetingPresented by Yung Koprowski, PE, PTOE, RSP

  2. Crash Analysis The main purpose of crash analysis is to improve safety by identifying crash patterns, mitigating crash severity, and reducing the number of crashes by adopting suitable countermeasures. The City of Peoria, Arizona desired a tool that would help staff respond quickly and confidently to requests from management and residents.

  3. Columns of Data Incident – 75 Person – 45 Unit – 66 Arizona Motor Vehicle Crash Data

  4. Existing Crash Data Acquisition Arizona Department of Transportation Crash Records Section compiles and maintain a database of all crashes occurring within the state Incident, Person, and Unit .csv file obtained annually each summer for the previous year of data Number Codes Leading, Inner, and Trailing Spaces, misspelled street names

  5. MAG RTSIMS Tool – Exported Report Crash Analysis Drawbacks Accuracy MAG RTSIMS Tool – Query Exported to Excel Formatting Crash Analysis Tool Vendors Manual Pivot Table Queries in Excel & Charts Antiquated, Complex, $$ Time

  6. Business Intelligence(BI) Software Suite of tools designed to source, sort, consolidate, analyze and present complex data into digestible reports for insights Leverages big data and cloud-computing to simplify complex data analysis Easy to deploy, use and integrate with existing systems Standalone applications or part of an enterprise suite

  7. Building the Power BI Report – Connect, Prep, and Transform the Data Relationships Connected the Excel files for the Incident, Person, and Unit crash data. Created a relationship between Incident, Person, and Unit through the “Incident ID” common to each. Applied over 140 steps to de-code attributes, correct data, and add new sorting columns. Code  Text New Columns

  8. Building the Power BI Report – Create Interactive Report Hundreds of modern data visuals from Microsoft and partners Drag-and-drop canvas Design the report with theming, formatting, and layout tools From Power BI Desktop published to Power BI Service (web)

  9. Yung Koprowski, PE, PTOE, RSP • City Traffic Engineer • City of Peoria • Chris.Lemka@peoriaaz.gov • 623.773.7260 Chris Lemka, PE Principal Y2K Engineering, LLC. ykoprowski@y2keng.com 480.696.1701

More Related