Highway Safety

How to automate advanced crash analysis for all TxDOT Projects.

CRIS Query + Python Code --> Crash Data --> PowerBI --> Crash Analysis

Step1: Always download crash data in standard format (e.g. using Python).

Step2: In PowerBI, swap the file path for new project.

Build new creative things. Any work done in PowerBI will automatically get carried forward to all future projects.

To develop advanced crash analysis:

Step 3: Compare all attributes and cross-attribute with similar facilities statewide to draw meaningful conclusions.

Python code and PowerBI files Provided below. For advanced step 3, please watch YouTube tutorial: Descriptive Safety Analysis Part 3 Dashboards (youtube.com)