Schedule

04:00 PM CT - 05:30 PM CT

Event Registration and Member Services

Hyatt Regency St. Louis at the Arch, Second Floor, Coatroom

07:00 AM CT - 05:00 PM CT

Event Registration and Member Services

Hyatt Regency St. Louis at the Arch, Second Floor, Coatroom

07:30 AM CT - 09:00 AM CT

Networking Breakfast

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom EF

09:00 AM CT - 10:00 AM CT

General Session

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom CD

• Presentation of the Colors and National Anthems
• Event Welcome Remarks – Maj. Ben Jones, Missouri State Highway Patrol
• Opening Remarks – Capt. John Hahn, Colorado State Patrol, CVSA President
• Welcome Remarks for CVSA/FMCSA Data Quality and Systems Training Attendees – Holly Skaar, Idaho State Police, CVSA Information Systems Committee Chair
• Welcome Remarks for CVSA Instructor In-Service Attendees – Lt. Ronald Jenkins, Oklahoma Highway Patrol, CVSA Training Committee Chair
• Closing Remarks – Capt. John Hahn, Colorado State Patrol, CVSA President

10:00 AM CT - 10:30 AM CT

Networking Refreshment Break

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom Foyer

10:30 AM CT - 12:00 PM CT

The Impact of Roadside Inspection Data

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom CD

Presenters: Joe Bowling, Holly Skaar and Keith Kerns

This session will focus on understanding the impact roadside inspection data has on motor carriers, investigative processes and operational policies. The evolution of data violation tables, inspection platforms, and associated SmartLogic or business rules will be reviewed to provide inspectors and those individuals with roles involving data collection with a comprehensive understanding of the past, present and future of roadside inspection data. This journey through the lifecycle of roadside violations will provide attendees with an appreciation for the evolution of roadside inspection data and what’s in store for the future as we work to improve uniformity of the inspection process.

12:00 PM CT - 01:00 PM CT

Networking Lunch (Provided)

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom EF

01:00 PM CT - 02:30 PM CT

New Analysts

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom A

Instructors: Kevin Berry and Beth Deysher

Participants with less than one year of experience are asked to attend this session.

This session will offer new analysts the opportunity to meet with other states and learn about the role an analyst plays within the Data Quality Program. New analysts will learn about State Safety Data Quality (SSDQ) measures, the records process and resources available on the Data Quality Program website. Attendees will learn about the sessions available to them throughout the week and time will be given to ask questions and identify topics of interest.

By the end of this session, participants will:

• Meet and network with other new analysts.
• Understand their role as an analyst within the Data Quality Program.
• Understand the SSDQ measures and records process overview.
• Understand the resources available on the Data Quality Program website.

01:00 PM CT - 02:30 PM CT

Working with SafeSpect API Data Sets in Power BI

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom B

Instructors: Nelson Cañas and Keeley Sadlak

Please have the desktop version of Power BI on your computer for this session.

Power BI allows users to connect to a variety of data sources and customize data visualizations through graphs, charts, maps and scatter plots. With current FMCSA IT modernization, Power BI is one way to work with the SafeSpect API data sets. Using technical demonstration and hands-on, peer-inspired exercises, learn how to load and transform data in Power BI in preparation to build a customized dashboard.

By the end of this session, participants will:

• Load data into Power BI.
• Complete a data transformation.
• Prepare their SafeSpect API data in Power BI.

02:30 PM CT - 03:00 PM CT

Networking Refreshment and Snack Break

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom Foyer

03:00 PM CT - 04:30 PM CT

Identifying and Fixing Problematic Records

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom A

Instructors: Catherine McInnis and Jessica Russell

To focus resources and reduce crashes, the Federal Motor Carrier Safety Administration (FMCSA) relies on states for accurate and complete data on crashes and inspections. Dig deeper into state data using the Records to Research supplemental reports to identify records with incomplete or inaccurate information and learn how to research the accurate information in those problematic records. Through technical instruction and hands-on exercises, learn how to correct non-match records. Time will be available to share ideas about researching driver and vehicle data.

By the end of this session, participants will:

• Use the Records to Research supplemental reports to identify records with problematic data.
• Research information in problematic records and find the accurate information to correct the record.
• Understand the importance of having the correct motor carrier type on a record.

03:00 PM CT - 04:30 PM CT

Power BI Basics for Data Quality Reports

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom B

Instructors: Nelson Cañas and Keeley Sadlak

Participants must attend the Working with SafeSpect API Data Sets in Power BI session before attending this session. Please have the desktop version of Power BI on your computer for this session.

Once users have loaded and transformed their SafeSpect API data in Power BI, the next step is to create metrics and build a dashboard. Learn how to create metrics for the API data set, create a framework design and build visuals within Power BI.

By the end of this session, participants will:

• Create metrics in Power BI with the SafeSpect API data set.
• Build visuals for creating a dashboard in Power BI.
• Understand how to share a Power BI dashboard with various stakeholders.

07:00 AM CT - 05:00 PM CT

Event Registration and Member Services

Hyatt Regency St. Louis at the Arch, Second Floor, Coatroom

07:00 AM CT - 08:30 AM CT

Networking Breakfast

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom EF

08:30 AM CT - 10:00 AM CT

Crash Definitions

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom B

Instructors: David Hetzel

The Motor Carrier Management Information System (MCMIS) Crash File contains statewide crashes that meet the federal reportable criteria. This session will review the crash collection criteria as well as examples of requests submitted in the “crash-not reportable” category through introductory and in-depth examples.

By the end of this session, participants will:

• Identify crashes sent to SAFETYNET for upload to MCMIS.
• Identify Crash Location, Crash Vehicle and Crash Severity qualifications.

08:30 AM CT - 10:00 AM CT

SafeSpect: Demonstration for Data Quality Analysts / Administrators

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom A

Instructors: FMCSA IT

A demonstration of an inspection and walk-through will allow participants to understand how the various business rules in SafeSpect minimize data entry errors. Data quality is enforced by having a validation check at each step of an inspection, as well as upon submission of the inspection. Participants will learn how the SafeSpect wizard can guide the user through each step of an inspection. SafeSpect also provides the capability for state agency data quality staff to identify issues with common data quality errors found on inspections.

By the end of this session, participants will:

• Understand the capabilities built into SafeSpect that promote data quality.
• Understand how SafeSpect guides the user throughout each step of an inspection.
• Know how to identify common data quality errors found on inspections.

10:00 AM CT - 10:30 AM CT

Networking Refreshment Break

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom Foyer

10:30 AM CT - 12:00 PM CT

SafeSpect: Reporting Capabilities and Search Criteria

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom A

Instructors: FMCSA IT

Learn how to generate reports in SafeSpect, including inspector activity summary reports, data quality reports, repair certification reports and inspection downloads. Participants will also learn how SafeSpect users can leverage light analytics through the inspections download and heavy analytics and business intelligence by leveraging the API integration with states’ reporting solutions. Participants will also learn how to search inspections based on the user’s role within their organization. Search criteria include inspection report number, status, inspector name, inspector radio number, USDOT number, carrier name, VIN, license plate number, CVSA decal number, and driver’s license number.

By the end of this session, participants will:

• Generate various reports in SafeSpect.
• Leverage light and heavy analytics within state reporting solutions.
• Search inspection records based on the user’s role within their organization.

10:30 AM CT - 12:00 PM CT

DataQs Program Overview

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom B

Instructors: Jeremy Crowell and Suzanne Horton

Learn about the DataQs Program and why FMCSA needs accurate data to support its data-driven safety systems. The DataQs website allows users to request and track a review of federal and state data issued by FMCSA believed to be incomplete or incorrect. This session will also provide an overview of the DataQs request process and proposed updates to the DataQs requirements for Motor Carrier Safety Assistance Program (MCSAP) funding.

By the end of this session, participants will:

• Know the importance of the DataQs Program and FMCSA receiving accurate data.
• Understand DataQs and the request process.
• Understand the updates to DataQs requirements for MCSAP funding.

12:00 PM CT - 01:00 PM CT

Networking Lunch (Provided)

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom EF

01:00 PM CT - 02:30 PM CT

Introduction to Pivot Tables

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom A

Instructors: Matt Benson and Zahra Nassirzadeh

Pivot tables are a powerful tool that quickly summarize large amounts of data to support analysis, find trends in data and create reports. Using technical demonstration and hands-on, peer-inspired exercises, learn how to use data in Excel and produce pivot tables.

By the end of this session, participants will:

• Identify when it is appropriate to use a pivot table.
• Create and use a pivot table.

01:00 PM CT - 02:30 PM CT

Reviewing Request for Data Reviews (RDRs)

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom B

Instructors: Jeremy Crowell and Naomi Gilbert

Using hands-on, peer-inspired examples of crash and inspection requests, learn how to consistently review and resolve request for data reviews (RDRs) by following FMCSA guidance and best practices. FMCSA relies on accurate data from states to support its data-driven safety systems.

By the end of this session, participants will:

• Understand a basic overview of DataQs
• Know how to review and resolve RDRs.
• Consistently review and resolve RDRs following FMCSA guidance.

02:30 PM CT - 03:00 PM CT

Networking Refreshment and Snack Break

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom Foyer

03:00 PM CT - 04:30 PM CT

DataQs Adjudicated Citations

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom B

Instructors: David Hetzel and Deb Bax

This session will provide direction for state DataQs analysts regarding the processing of DataQs Request for Data Reviews (RDRs) after the adjudication of a citation with an associated violation included on a driver or vehicle inspection. This session will use actual RDRs as introductory and complex examples.

By the end of the session, participants will:

• Understand the adjudicated citation policy and procedures.
• Distinguish between punitive and non-punitive costs.
• Identify and document the appropriate SAFETYNET/SafeSpect state citation result codes.

03:00 PM CT - 04:30 PM CT

Building Dashboards in Excel

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom A

Instructors: Matt Benson and Zahra Nassirzadeh

Excel is a versatile tool that offers many features to create dashboards. Using technical demonstration and hands-on, peer-inspired exercises, learn how to use Excel to create a simple dashboard to support analysis and track program activity.

By the end of this session, participants will:

• Create and use a pivot chart.
• Create and use slicers.
• Build a basic dashboard in Excel.

07:00 AM CT - 03:30 PM CT

Event Registration and Member Services

Hyatt Regency St. Louis at the Arch, Second Floor, Coatroom

07:00 AM CT - 08:30 AM CT

Networking Breakfast

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom EF

08:30 AM CT - 10:00 AM CT

Working with SafeSpect API Data Sets in Power BI

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom B

Instructors: Nelson Cañas and Keeley Sadlak

Please have the desktop version of Power BI on your computer for this session.

Power BI allows users to connect to a variety of data sources and customize data visualizations through graphs, charts, maps, and scatter plots. With the current FMCSA IT modernization, Power BI is one way to work with the SafeSpect API data sets. Using technical demonstration and hands-on peer-inspired exercises, learn how to load and transform data in Power BI in preparation to build a customized dashboard.

By the end of this session, participants will:

• Load data into Power BI.
• Complete a data transformation and prepare their SafeSpect API data in Power BI.

08:30 AM CT - 10:00 AM CT

FMCSA IT Session

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom A

Instructors: FMCSA IT

10:00 AM CT - 10:30 AM CT

Networking Refreshment Break

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom Foyer

10:30 AM CT - 12:00 PM CT

Power BI Basics for Data Quality Reports

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom B

Instructors: Nelson Cañas and Keeley Sadlak

Participants must attend the Working with SafeSpect API Data Sets in Power BI session before attending this session.

Once users have loaded and transformed their SafeSpect API data in Power BI, the next step is to create metrics and build a dashboard. Learn how to create metrics for the API data set, create a framework design, and build visuals within Power BI.

By the end of this session, participants will:

• Create metrics and a framework design in Power BI with the SafeSpect API data set.
• Build visuals for creating a dashboard in Power BI.
• Understand how to share a Power BI dashboard with various stakeholders.

10:30 AM CT - 12:00 PM CT

A&I Online

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom A

Instructors: Theresa Lagos and Elizbeth Deysher

Learn how to use the data sources and reports in FMCSA’s Analysis & Information (A&I) Online website to track commercial motor vehicle program activities and improve data quality.
By the end of this session, participants will:

• Know where to find data reports to support grant-reporting requirements.
• Understand how the reports available can answer questions from motor carriers, drivers and management.

12:00 PM CT - 01:00 PM CT

Networking Lunch (Provided)

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom EF

01:00 PM CT - 02:30 PM CT

System Demonstrations: A&I and the Data Quality Program

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom A

Instructors: Volpe Team and FMCSA IT

Participants will have the opportunity to sit in on 10-minute small-group demonstrations and conversations. Participants may choose which tables to attend and in which order. This room will include:

• Driver Information Resource (DIR) Demo
• Analysis and Information (A&I) Dashboards Demo
• Data Quality Website Conversations
• FMCSA Data Quality Program Conversations

01:00 PM CT - 02:30 PM CT

System Demonstrations: DataQs and FMCSA IT

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom B

Instructors: Volpe Team and FMCSA IT

Participants will have the opportunity to sit in on 10 minute small-group demonstrations and conversations. Participants may choose which tables to attend and in which order. This room will include:

• Power BI Demo
• SafeSpect Demo
• Transportation DataHub Demo
• FMCSA IT Conversations
• DataQs Program Conversations
• Adjudicated Citations and Crash Definitions Conversations

02:30 PM CT - 03:00 PM CT

Networking Refreshment and Snack Break

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom Foyer

03:00 PM CT - 04:30 PM CT

Closing Session: Conference Wrap-up and Open Forum

Hyatt Regency St. Louis at the Arch, Second Floor, Regency Ballroom CD