Management and Use of Data for Transportation Performance Management: Guide for Practitioners (2019) / Chapter Skim
Currently Skimming:
Pages 26-51
The Chapter Skim interface presents what we've algorithmically identified as the most significant single chunk of text within every page in the chapter.
Select key terms on the right to highlight them within pages of the chapter.
From page 26... ...
Reporting
|
From page 27... ...
Introduction • Foundation • Reporting • Insight • Cases Step 3 Store & Manage Data This step includes validating, cleaning, normalizing, aggregating, and integrating data; storing the data in one or more repositories -- either within the agency or "in the cloud"; producing documentation needed for both technical and business users of the data; and managing access to the data -- to both protect it from unauthorized use and to ensure that it is accessible to those who need it. This step also includes activities to design, develop, and manage databases and technical infrastructure for data storage and data integration.
|
From page 28... ...
Introduction • Foundation • Reporting • Insight • Cases Step 3.1 Establish Databases Design databases to support analysis needs. Performance measures rely on a deep archive of data to develop an accurate baseline; understand multi-year, seasonal trends; and establish reasonable targets.
|
From page 29... ...
Introduction • Foundation • Reporting • Insight • Cases data sets, it may provide new and important performance measures insights that neither data set could in isolation. Data storage architectures can be designed to consider both current and future TPM data requirements.
|
From page 30... ...
Introduction • Foundation • Reporting • Insight • Cases agencies can develop simple interfaces that operate across both the traditional relational databases and big data platforms. Agencies should have strategies for both big and small data, including a way to integrate across both types of data.
|
From page 31... ...
Introduction • Foundation • Reporting • Insight • Cases Plan for data security. Implement a sound data back-up strategy that will allow you to restore data in the event of a hardware failure, cyberattack, or inability to physically access facilities.
|
From page 32... ...
Introduction • Foundation • Reporting • Insight • Cases For more information...
|
From page 33... ...
Introduction • Foundation • Reporting • Insight • Cases Step 3.2 Load & Integrate Data Establish repeatable data loading processes. Ad hoc data loading conducted in a rushed manner is a recipe for disaster.
|
From page 34... ...
Introduction • Foundation • Reporting • Insight • Cases For more information...
|
From page 35... ...
Introduction • Foundation • Reporting • Insight • Cases Step 3.3 Assess & Improve Data Quality Data quality assessment. Poor quality data may have significant impacts on calculated performance metrics and therefore impact TPM decisions.
|
From page 36... ...
Introduction • Foundation • Reporting • Insight • Cases not been cleaned or validated, is important for guiding and informing potential users, applications, and data investment decisions. Annotating (not discarding)
|
From page 37... ...
Introduction • Foundation • Reporting • Insight • Cases Capabilities Checklist: Store & Manage Data Basic o Data needed for TPM is stored in databases that are managed and regularly backed-up to provide protection from unauthorized access and corruption. o Back-ups are tested on a regular, established cycle (e.g., monthly)
|
From page 38... ...
Introduction • Foundation • Reporting • Insight • Cases Step 4 Share Data This step includes sharing transportation performance data across business units within an agency, across agencies, or with the general public. This includes but is not limited to transmitting data and reports to meet reporting obligations.
|
From page 39... ...
Introduction • Foundation • Reporting • Insight • Cases Step 4.1 Establish Reporting & Presentation Infrastructure Select and deploy analysis and reporting tools. Data analysis and reporting tools that are available to agency staff are a critical element in making effective use of data.
|
From page 40... ...
Introduction • Foundation • Reporting • Insight • Cases agencies/universities have already paid to develop. This effectively creates a pooled-fund approach to software development and maintenance.
|
From page 41... ...
Introduction • Foundation • Reporting • Insight • Cases productivity of analysts by making the data much easier to analyze. In addition, these tools provide capabilities to agencies that might have previously taken months of effort to produce.
|
From page 42... ...
Introduction • Foundation • Reporting • Insight • Cases For more information...
|
From page 43... ...
Introduction • Foundation • Reporting • Insight • Cases Step 4.2 Establish Data Standards & Formats Take advantage of data standards. There are a number of data standards that can be adopted for agency data sets and/or used when sharing transportation system performance data between agencies (see Table 2)
|
From page 44... ...
Introduction • Foundation • Reporting • Insight • Cases Table 2. Example data standards related to TPM.
|
From page 45... ...
Introduction • Foundation • Reporting • Insight • Cases Select file formats. Certain file formats have advantage over others when it comes to sharing data between agencies.
|
From page 46... ...
Introduction • Foundation • Reporting • Insight • Cases Step 4.3 Publish Data Designate authoritative data sources. Authoritative data sources for performance measure calculation should have been established as part of Step 1.3 -- Identify Analysis and Reporting Requirements.
|
From page 47... ...
Introduction • Foundation • Reporting • Insight • Cases To support system performance management, agencies should strive to share data in near real time and at the highest possible resolution in order to provide the most flexibility and usefulness. For example, the Maryland State Highway Administration (SHA)
|
From page 48... ...
Introduction • Foundation • Reporting • Insight • Cases Sharing data with the public. Public agencies have a responsibility to provide best possible service to their customers: the general traveling public.
|
From page 49... ...
Introduction • Foundation • Reporting • Insight • Cases prevalent in recent years. Not only are agencies benefiting from obtaining new data sets from the private sector, but they are also benefiting from the private-sector value-add to the existing agency data sets.
|
From page 50... ...
Introduction • Foundation • Reporting • Insight • Cases For more information...
|
From page 51... ...
Introduction • Foundation • Reporting • Insight • Cases Capabilities Checklist: Share Data Basic o Employees are aware of key performance data sources within the agency. o There are clear agency policies in place that data should be shared unless the need to protect it is demonstrated.
|
Key Terms
This material may be derived from roughly machine-read images, and so is provided only to facilitate research.
More
information on Chapter Skim is available.