Worksheet: Data Querying 101

  • Date: September 26, 2025

So you have all this data, but how do you find what you need from it? Data querying refers to the ability to search for specific types of data within your database. Good data querying begins with collecting the information you need from the beginning and asking the right type of questions. Data is a key component of understanding how your agency is performing and how close you are to your goals. With this in mind, N-CATT created this worksheet to help agencies think through data querying from what data they need from a vendor during pre-procurement to how to ask the right questions of their data. This helps agencies start collecting the right data from the beginning.

N-CATT develops worksheets to help transit operators think through important considerations for various technologies. The goal of each worksheet is to help you start organizing your thoughts around the topic to lead to more informed decision-making. While the considerations we prompt you with on the worksheet are a starting point, there are likely additional important details to consider that we couldn’t fit. No technology is one-size-fits-all, and so we encourage you to answer the questions as you see fit, add your own ideas, and improvise the worksheet to make it best suit your needs. This is just a starting point for a big project.

 

We encourage you to reach out with any questions about this worksheet or any questions this worksheet prompts that you need additional information about. Also, please provide any feedback you have on how to make these better! You can reach us at helpdesk@n-catt.org.

 

Click here to download the worksheet.

Topics