The consultant should confirm that Student Success Hub requires Education Data Architecture (EDA) as an operational requirement. Student Success Hub is a solution that extends EDA to meet the needs of student services and support. Student Success Hub provides features such as Early Alerts, Success Plans, Pathways, and Advising Events. Student Success Hub requires EDA to be installed and configured in the Salesforce environment before installing Student Success Hub.Einstein Bots being enabled prior to installing Student Success Hub, Read, Create and Edit access to Contacts, Accounts, and Cases being required, or Student Success Hub requiring the K-12 Architecture Kit are not operational requirements that the consultant should confirm. References:

https://www.salesforce.org/products/student-success-hub/overview/

https://powerofus.force.com/s/article/SSHub-Installation

The student number is the external ID that the consultant should recommend to match spreadsheet information with the Salesforce Contact record. The external ID is a field that uniquely identifies a record and can beused to match records from different data sources. The student number is a unique identifier for each student that can be used to match the spreadsheet information with the Contact record in Salesforce. The email address, company name, and company phone are not unique identifiers for each student and cannot be used as external IDs. References:

https://help.salesforce.com/s/articleView?id=sf.data_loader_match_record.htm & type=5

https://help.salesforce.com/s/articleView?id=sf.customize_externalid.htm & type=5

Data skew is the likely cause for all of these issues, such as record locking, long search times, and long record save times. Data skew is a condition that occurs when a large number of child records are associated with a single parent record, or when a large number of records are owned by a single user. Data skew can affect performance and functionality, such as locking records, slowing down queries, andincreasing save times. TDTM, insufficient code coverage, and insufficient data storage are not likely causes for all of these issues. References:

https://help.salesforce.com/s/articleView?id=sf.data_skew.htm & type=5

https://developer.salesforce.com/blogs/engineering/2012/04/avoid-account-data-skew-for-peak-performance.html

The consultant should advise to use the Admissions Connect Tableau Accelerator to evaluate historical trends of its applicants and get greater insights on its applications yield and melt for the Admissions office. The Admissions Connect Tableau Accelerator is a tool that provides pre-built dashboards and reports for Admissions Connect users to analyze their data and metrics. The Admissions Connect Tableau Accelerator can help the Admissions office evaluate historical trends of its applicants and get greater insights on its applications yield and melt by using features such as funnel analysis, cohort analysis, or geographic analysis. Leveraging the existing sample reports, creating a custom report type, or using Data Studioto process old data are not ways to evaluate historical trends of its applicants and get greater insights on its applications yield and melt for the Admissions office. References:

https://www.salesforce.org/products/admissions-connect/overview/

https://www.salesforce.org/wp-content/uploads/2021/06/Salesforce.org-Admissions-Connect-Tableau-Accelerator.pdf