U.S. flag An official website of the United States government.
Official websites use .gov

A .gov website belongs to an official government organization in the United States.

Secure .gov websites use HTTPS

A lock ( ) or https:// means you've safely connected to the .gov website. Share sensitive information only on official, secure websites.

i

Enhanced GIS Legacy Database for TDOT Legacy Data Phase III: Power BI Applications

File Language:
English


Select the Download button to view the document
Please click the download button to view the document.

Details

  • Creators:
  • Corporate Creators:
    Vanderbilt University. Department of Civil and Environmental Engineering
  • Corporate Contributors:
  • Subject/TRT Terms:
  • Publication/ Report Number:
    RES2016-23
  • Resource Type:
    Tech Report
  • Geographical Coverage:
    Tennessee;United States
  • Edition:
    Final Report, 03/2020-08/2022
  • Corporate Publisher:
    Tennessee. Department of Transportation
  • Abstract:
    TDOT has embarked on an initiative to develop data analytics and visualization capabilities using the Microsoft Power BI platform to serve the agency’s needs. Critical to the success of this initiative is the ability to identify, develop and serve a range of applications across TDOT’s various divisions, covering a variety of operating modes within the state. However, to date only a few Power BI applications have been developed by agency staff, largely due to the lack of opportunity to design, develop and implement Power BI in ways that leverage information that TDOT obtains and manages. As a result, there are missed opportunities associated with performing both basic and comprehensive data analytics that become possible once TDOT staff become more aware and proficient in the use of Power BI. The objective of this project was to create Power BI applications that enable more informed decision-making by TDOT in providing safe, secure, efficient and environmentally-friendly passenger and freight transport. This was accomplished by working in collaboration with TDOT staff to conceive, develop and implement Power BI applications for various TDOT divisions. An added goal of this research was to help mainstream the use of Power BI across the organization by providing the necessary knowledge, skills and experience to TDOT staff in support of workforce development. This report contains a description of the following Power BI applications that were developed as part of this project. The Tennessee Crash and Safety Analytics Tool (TCAST) can be used to facilitate comprehensive safety analyses for Tennessee roadways. The Tennessee Pavement Analytics Tool (TPAT) enables users to explore the impact of pavement projects on roadway safety for Tennessee roadways.
  • Format:
    PDF
  • Collection(s):
  • Main Document Checksum:
    urn:sha-512:dfbdb64dadeea0708a9e98d429d9fa5af198147a721c4205d2471fa25a7a303e014e30a9c5c8c90b1545665d22c1ce7374fc765632d3da4ea20aa133170d6475
  • Download URL:
  • File Type:
    Filetype[PDF - 17.21 MB ]
PREVIOUS
File Language:
English
ON THIS PAGE
Details
ROSA P serves as an archival repository of USDOT-published products including scientific findings, journal articles, guidelines, recommendations, or other information authored or co-authored by USDOT or funded partners. As a repository, ROSA P retains documents in their original published format to ensure public access to scientific information.
BACK TO TOP