The consultant should create a custom Report Type with Courses, Course Offerings, and Course Connections to create a report of all alumni who took a course from that faculty member for the Alumni Relations office that is using Salesforce with EDA. A custom Report Type is a type of report that shows information about one or more objects and their fields, filters, and relationships. A custom Report Type with Courses, Course Offerings, and Course Connections can help the Alumni Relations office create a report of all alumni who took a course from that faculty member by showing the relationship between the Contact object and the Course object through the Course Offering object and the Course Connection object. The consultant can add fields and filters to the custom Report Type to show only the alumni who took a course from that faculty member. Using the Course Connections with Contact's Academic Program Report Type, adding a Course Connections cross filter to the Program Enrollments with Contact report, or creating a custom Report Type with Contacts, Accounts, and Affiliations are not ways to create a report of all alumni who took a course from that faculty member for the Alumni Relations office that is using Salesforce with EDA. Reference:
https://help.salesforce.com/s/articleView?id=sf.reports_builder_create_report_type.htm&type=5
https://powerofus.force.com/s/article/EDA-Course-Connections