About Data Explorer

The Data Explorer is an interactive data dictionary that enables you to navigate, browse, and search for tables, fields, and their associated metadata in Analytics. Use the Data Explorer to understand what your data means and find its relevance. For example, when creating a Power BI report, you can use the Data Explorer to identify the correct tables and fields to include in your report. 

• Required User Permissions

• View a Table

• View a Field

You can use the Data Explorer to browse or search for tables in Analytics. It allows you to view the metadata for Analytics tables, including their packages and descriptions.

1. Navigate to the Company level Analytics tool. 

2. Click the Data Explorer tab.

3. Click Analytics to expand it. 

4. Click the public folder to see the list of available tables.
   The main pane will update to list all tables in the Analytics database.
   

   Note

   You can view the following details for each table:

   • Name. The name of the table in the Analytics database.

   • Package. The Procore toolset or product package associated with the table's data.

   • Description. An explanation of the table's data, purpose, or utility.

5. (Optional) Click the Package drop-down list above the table list to filter tables by a specific package.

You can use the Data Explorer to browse or search for fields across any table in Analytics. It allows you to view the metadata for Analytics fields, including their data types, descriptions, data origins, and mappings. 

1. Navigate to the Company level Analytics tool. 

2. Click the Data Explorer tab.

3. Click Analytics to expand it. 

4. Click the public folder to see the list of available tables.

5. Click on a specific [Table Name]. For example, action_plan_completed_receiver.
   The main pane will update to list all fields within that table.
   

   Note

   You can view the following details for each field:

   • Analytics Name. The name of the field in the Analytics database.

   • Procore UI & 360 Name. The name of the field in the Procore user interface and the 360 Reporting tool.

   • Data Type. The format of the data stored in the field (e.g., LONG, TIMESTAMP, STRING). 

   • Description. An explanation of the field's data, purpose, or utility.

   • Procore API Name. The name of the field in the Procore API ecosystem.

   • Data Origin. The source location from which the field data is extracted.

6. (Optional) Click the Data Type drop-down list above the field list to filter fields by a specific data type.