United States Department of Transportation
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.
i
Enhanced GIS Legacy Database for TDOT Legacy Data Phase III: Power BI Applications
-
2022-09-01
[PDF-17.21 MB]
Details:
-
Creators:
-
Corporate Creators:
-
Corporate Contributors:
-
Subject/TRT Terms:
-
Publication/ Report Number:
-
Resource Type:
-
Geographical Coverage:
-
Edition:Final Report, 03/2020-08/2022
-
Corporate Publisher:
-
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:
-
Collection(s):
-
Main Document Checksum:
-
Download URL:
-
File Type:
