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:00 AM CT - 08:30 AM CT

Networking Breakfast

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

08:30 AM CT - 10:00 AM CT

General Session

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

• Event Welcome Remarks
• Welcome Remarks for CVSA/FMCSA Data Quality and Systems Training Attendees
• Welcome Remarks for Inspector In-Service Attendees
• Welcome Remarks from Federal Motor Carrier Safety Administration
• Closing Remarks

10:00 AM CT - 10:30 AM CT

Networking Refreshment Break

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

10:30 AM CT - 12:00 PM CT

General Session: Violation Code Table Updates

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

12:00 PM CT - 01:00 PM CT

Networking Lunch (Provided)

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

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 years’ 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 an overview of the State Safety Data Quality (SSDQ) Measures and the records process and receive an introduction to resources available on the Data Quality website. Attendees will learn about the sessions available to them over the course of the week and time will be given for new analysts to ask questions and identify topics of interest.

By the end of this session, participants will:

• Meet with other new analysts and network among other States.
• 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 website.

01:00 PM CT - 02:30 PM CT

Loading 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

Power BI allows users to connect to a variety of data sources and customize data visualizations through graphs, charts, maps, and scatter plots. The first step in creating a dashboard is learning how to load and transform API data in Power BI. 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 API data in Power BI in preparation to build a customized dashboard.

By the end of this session, participants will:

• Load SafeSpect API data into Power BI.
• Clean and transform 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 D

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, 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 these problematic records. Through technical instruction and hands-on exercises, learn how to correct non-match records. Time will be available for States 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 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 Loading 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.

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 D

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 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 both introductory and more in-depth examples.

By the end of this session, participants will:

• Identify crashes sent to SAFETYNET for upload to MCMIS
• Identify Crash Location qualification
• Identify Crash Vehicle qualification
• Identify Crash Severity qualification

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 SafeSpect can guide the user through each step of an inspection through the SafeSpect wizard. 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 D

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

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 State’s reporting solutions. Participants will also learn how to search inspections based on the user’s role within their organization. Search criteria include INSP Report Number, Status, Inspector Name, Inspector Radio #, DOT #, Carrier Name, VIN, License Plate #, CVSA Decal #, and Driver License #.

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 is an FMCSA system that 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 MCSAP funding.

By the end of this session, participants will:

• Understand the importance of the DataQs Program and FMCSA receiving accurate data.
• Understand an overview of 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 D

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, or 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 both crash and inspection requests, learn how to consistently review and resolve 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 and 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 D

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 both 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: Nelson Cañas and Matt Benson

Excel is a versatile tool that offers many features and benefits for creating 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 D

08:30 AM CT - 10:00 AM CT

Loading 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

Power BI allows users to connect to a variety of data sources and customize data visualizations through graphs, charts, maps, and scatter plots. The first step in creating a dashboard is learning how to load and transform API data in Power BI. 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 API data in Power BI in preparation to build a customized dashboard.

By the end of this session, participants will:

• Load SafeSpect API data into Power BI.
• Clean and transform SafeSpect API data in Power BI

08:30 AM CT - 10:00 AM CT

FMCSA Portal, OCs, and Account Management/Cybersecurity

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

Instructors: FMCSA IT

The FMCSA Portal is the focal point for how most of FMCSA’s systems are accessed. This session is geared for participants to be able to request roles and access, and to navigate through the Portal. Organization coordinators are also encouraged to attend for refresher training. This course will also provide training on relevant cybersecurity and privacy-issue related to accessing FMCSA systems.

By the end of this session, participants will:

• Understand how to create accounts and request access to FMCSA system.
• Understand how to navigate to FMCSA’s connected systems.
• For organization coordinators, how to manage their users’ accounts, including the Account Validation Survey.
• For organization coordinators, get answers to questions on account management.

10:00 AM CT - 10:30 AM CT

Networking Refreshment Break

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

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 Loading 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 Maren Saly

Learn how to use the data sources and reports in FMCSA’s Analysis & Information (A&I) Online website to track CMV 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 carriers, drivers, or management

12:00 PM CT - 01:00 PM CT

Networking Lunch (Provided)

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

01:00 PM CT - 02:30 PM CT

System Demos

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

Instructors: Volpe Team and FMCSA IT

Over the course of this session, participants will have the opportunity to sit in on short 10–15-minute small group demonstrations of various FMCSA systems and other tools available to support your Data Quality work. Participants may choose which mini demos to attend and in which order. Experts will also be available for one-on-one conversations.

Systems demonstrated may include:

• Driver Information Resource (DIR)
• MCSAP Performance Dashboard
• Grants Activity Dashboard
• Power BI
• SAFETYNET
• DataQs Dashboard
• Others TBD

01:00 PM CT - 02:30 PM CT

System Demos

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

Instructors: Volpe Team and FMCSA IT

Over the course of this session, participants will have the opportunity to sit in on short 10–15-minute small group demonstrations of various FMCSA systems and other tools available to support your Data Quality work. Participants may choose which mini demos to attend and in which order. Experts will also be available for one-on-one conversations.

Systems demonstrated may include:

• Driver Information Resource (DIR)
• MCSAP Performance Dashboard
• Grants Activity Dashboard
• Power BI
• SAFETYNET
• DataQs Dashboard
• Others TBD

02:30 PM CT - 03:00 PM CT

Networking Refreshment and Snack Break

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

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 C