Skills & Resources

Expertise &
Knowledge Hub

15+ years of higher education technology experience — distilled into shareable resources, SQL examples, and guides for Banner, Degree Works, and Argos practitioners.

Core Technical Skills

01 / ERP

Banner ERP

Ellucian Banner system administration, configuration, and data management. Deep experience with the student, financial aid, and registration modules.

Student RecordsRegistrationSGRADVREllucian
02 / Degree Audit

Degree Works

Advanced scribe language programming, audit block configuration, and CPoS advising integration. Adviser training and institutional rollout experience.

Scribe LanguageAudit DesignCPoSAdviser Training
03 / Reporting

Argos Reporting

Full-lifecycle Argos report development including DataBlocks, reports, and dashboards. Expert-level configuration for institutional reporting needs.

ArgosDataBlocksDashboardsEvisions
04 / Database

Oracle SQL

Complex query construction, joins, subqueries, analytical functions, and stored procedures within Banner's Oracle environment. Toad for Oracle power user.

OraclePL/SQLToadAnalytical Functions
05 / BI

PowerBI

Dashboard design and data modeling connecting Banner Oracle data to modern BI visualization. DAX measures, data transformation, and institutional reporting.

PowerBIDAXData ModelingVisualization
06 / Community

BUG-MI Leadership

President-Elect and Webmaster for the Banner User Group of Michigan. Conference planning, professional development, and knowledge-sharing across Michigan institutions.

BUG-MIConference PlanningWebmasterLeadership

Downloads &
Reference Guides

A collection of SQL queries, Argos templates, and training documents built from real-world Banner and Degree Works work. Use these as starting points — adapt them to your institution's needs.

Oracle SQL

Active Student Enrollment by Term

Returns all actively enrolled students for a given term with their program, level, and credit hour load. A solid foundation for enrollment reporting.

EnrollmentSFRSTCRSGBSTDN
Placeholder — add .sql file to download
Oracle SQL

Adviser Caseload by Department

Pulls all adviser assignments from SGRADVR with student counts grouped by adviser and department. Useful for caseload balancing and reporting.

AdvisingSGRADVRCaseload
Placeholder — add .sql file to download
Oracle SQL

Degree Completions by Program & Term

Identifies students who have been awarded a degree within a given term range, joined with their program and college information for completion reporting.

GraduationSHRDGMRCompletions
Placeholder — add .sql file to download
📁
More queries coming soon

Additional Banner SQL examples for registration, financial aid, and student success reporting will be added here. Have a query you'd like to see? Get in touch.

Argos Template

Enrollment Snapshot DataBlock

A reusable Argos DataBlock foundation for enrollment reporting. Includes term-based filtering, level breakdowns, and headcount vs. credit hour views.

DataBlockEnrollmentArgos
Coming Soon
Argos Template

Adviser Assignment Report

Argos report layout for adviser caseload management. Designed for Registrar offices needing a quick-print advising roster by department or college.

ReportAdvisingArgos
Coming Soon
Argos Template

Graduation Audit Dashboard

Dashboard-style Argos layout for tracking graduation applications, audit statuses, and awarded degrees across colleges and departments.

DashboardGraduationArgos
Coming Soon
📊
Argos resources in progress

Exportable Argos DataBlock configurations and report templates will be added here. These will include setup notes and Banner table references.

Training Guide

Degree Works for Academic Advisers

A comprehensive quick-reference guide for academic advisers navigating Degree Works audits, overrides, and what-if scenarios. Designed for new advisers or annual refresher training.

Degree WorksAdvisingGuide
↓ Download PDF
Training Guide

CPoS Advising Quick Reference

Step-by-step reference for Course Program of Study (CPoS) advising workflows in Degree Works and Banner. Covers common scenarios, exceptions, and escalation paths.

CPoSBannerReference
↓ Download PDF
Training Guide

Banner Registration Processes

An overview of Banner registration table relationships, common SFASTCA/SFRSTCR processes, and troubleshooting guidance for Registrar staff.

BannerRegistrationReference
Coming Soon
📄
Upload your own documents here

Replace the placeholder download links above with your actual PDF files uploaded to your Netlify deployment. Simply place PDFs in your site folder and update the href attributes.

Banner ERP Degree Works Argos Reporting Oracle SQL PowerBI BUG-MI Higher Ed Technology Banner ERP Degree Works Argos Reporting Oracle SQL PowerBI BUG-MI Higher Ed Technology