John McPherson of ResultSet presented a session focused on extracting and manipulating data from Unanet AE into Excel using API endpoints. He walked through setting up API calls and authentication, demonstrated configuring and testing API calls in Excel using Power Query, and reviewed data transformation and refresh capabilities.

Courtney Drews presented on the topic of Queries. This session covers the process of building and using queries. Courtney demonstrated various aspects of query building, including filtering, sorting, and using the data dictionary.