Student Analytics

Architecture

The design of Student Analytics is based on a four-layer architecture.

• Source Layer:

  The CampusNexus Student and/or CampusNexus CRM databases serve as the data sources throughout Student Analytics; all day-to-day changes made to the databases (insert, update, and delete operations) are tracked and the changes are fetched by the Extract Load Transform (ELT) process.

• Data Warehouse Layer:

  The ETL process uses the SQL Server Integration Services (SSIS) platform and SSIS Catalog framework for data extraction and for updating the dimension and fact tables.

• Semantic Layer:

  Student Analytics has a semantic tabular model deployed on the SQL Server Analysis Services (SSAS) platform and is configured to process and contain the data from the data warehouse. This semantic model consists of dimensions and facts from the data warehouse (data access) and various measures applied across the facts (business logic and queries), facilitating data analysis from various perspectives.

• Data Visualization Layer:

  The data visualization layer leverages Microsoft Power BI, enabling users to connect to the semantic model (as a dataset) and create rich visualizations which can be organized on a canvas to build Reports or pinned to build Dashboards and shared across the enterprise.

For more information, refer to Student Analytics Help.

Supported Databases

Student Analytics version 4.x and later supports subsets of data from the CampusNexus Student and/or CampusNexus CRM databases.

• For CampusNexus Student versions 20.0 through 21.0, Student Analytics is limited to data associated with the Academics, Admissions, Career Services, Financial Aid, and Student Account modules.

• For CampusNexus CRM versions 13.x, Student Analytics is limited to the Campaign module consisting of Campaign Mail, URL Click, and Campaign SMS statistics only. Also, Analytics for CampusNexus CRM is further limited to Contact and Lead based campaigns.