Business intelligence (BI) is a technology-driven process for analyzing data and delivering actionable information that helps executives, managers, and team members make informed business decisions.
Mission
Deliver high-value, quality data, analytics, and reporting, while delivering best practices around change strategy, planning, in conjunction with assuring the highest-level of confidence with exceeding expectations regarding Enrollment, Retention, and Graduation.
Vision
Assist in the decision-making process by ensuring the right information is available when it is needed, while driving the highest quality practices across NSU's technology domain and promoting enterprise-wide deployment and proper implementation throughout NSU.
Goals and Expected Business Value
- Partner with stakeholders on delivering high-value reports.
- Empower business users through training and self-service ability in reporting.
- Ensure reporting is stable and near real time.
- Help provide reports that assist users with data-driven business decisions.
- Help provide intuitive dashboards.
- Deliver timely, high-quality reports.
Meet the BI Team
Darin Admati
Director of BI, QA, RM and CM
Humma Jawwad
IT Business Intelligence Analyst III
Abraham Pineda
Software Engineer
Patricio Torres Gil
Software Engineer
Rogelio Alvarado Torres
Software Engineer
Commonly Used Reports
The following reports are the most commonly used SSRS and PowerBI reports at NSU for the different colleges. Please ensure to utilize these reports based on the following value streams listed below.
Security & Access: These reports can only be viewed on the NSU Network, or when connected to VPN. Access is limited to the intended user; therefore, forwarding the report link will not permit access to another user. If you download, print, or forward portions of any report to an expressly authorized individual within your department, you are responsible for maintaining appropriate data security over the information, including complying with NSU’s Data Security Policies. This responsibility includes ensuring safeguards are strictly maintained such as password protection of downloaded files and that any movement of such data occurs strictly within the NSU network.
*If you encounter an error regarding access to any of the reports, submit a request for access. Please make sure to complete the following security questionnaire when submitting access requests.
Top 10 SSRS Reports
|
Report Name |
Value Stream |
Purpose of Report |
|
Enrollment |
This Report pulls the Student count and credit count by Term and College Code and has a sub report that pulls student data. |
|
|
Retention |
This Report will provide details on the semester benchmark count for continuing students, the returning count, a not registered count, and graduate count based on the continuing student category, based on the student. |
|
|
Registration |
The Registration Report provides data for students over the course a semester, who have enrollment history. The report displays information regarding the student degree program, location, age, academic standing history, enrollment for specified term. |
|
|
Retention |
The BAC Outreach Report a comprehensive review of students belonging to the college by displaying priority 1 and priority 2 program seeking students. The report allows to view students based on status: AS, IS or IG. Based on the evaluation term, users are able to obtain information regarding active holds on the student account, identify degree status, obtain a summary of previously awarded NSU programs, obtain contact information, view academic program information, identify students with rate codes and applied web submission codes, identify a student's citizen status and academic advisor. |
|
|
Student Grades |
status of grades for the class. The report will reflect the number of missing grades, the number of students with I or PR grades, the number of students who have withdrawn and the number of posted grades from the respective section of the course. |
|
|
Recruit |
The Prospect to Enrolled by Term report provides a comparison of the admission funnel based on end of term, same day, last year and the day prior for the fall, winter and summer semesters with regards to performance of the prospect, inquiry, application started (this data is pulled from recruit), application submit, admitted and enrolled (this data is pulled from banner) counts and percentages. Sub reports regarding each of the categories can also be accessed from the main report. |
|
|
Grades |
The Change of Grade report by term allows users to pull a report of any student who has had a change of grade posted to their student account within a designated term. |
|
|
Enrollments |
The accepted by entry term cohort report will display students accepted for a specified semester. The report will display student data such as record status, registration status, application source, academic program, student contact information, admitted GPA, assigned recruiter and advisor. |
|
|
Student Grades |
Student Grade Audits from original to final Grades. |
|
|
Registration |
Active Students, not registered. |
Top 5 PowerBI Reports
|
Report Name |
Value Stream |
Purpose of Report |
|
Enrollment |
Enrollment, Registrations, Credit hours details by Student Primary College. |
|
|
Enrollment |
Enrollment, Registrations, Credit hours details by Course Secondary College. |
|
|
Student |
Recruit and Banner Student Funnel: Prospect to Enrolled. |
|
|
Enrollment |
Enrollment by Term and Weekly comparisons based on Pull/part time, Level, Program, Concentration from current and last Fall. |
|
|
Enrollment |
Enrollment by Term and Weekly comparisons based on Pull/part time, Level, Program, Concentration from current and last Winter. |
This option will allow you to submit a request for report access.
Top 10 SSRS Reports
|
Report Name |
Value Stream |
Purpose of Report |
|
Enrollment |
This Report pulls the Student count and credit count by Term and College Code and has a sub report that pulls student data. |
|
|
Retention |
This Report will provide details on the semester benchmark count for continuing students, the returning count, a not registered count, and graduate count based on the continuing student category, based on the student. |
|
|
Registration |
The Registration Report provides data for students over the course a semester, who have enrollment history. The report displays information regarding the student degree program, location, age, academic standing history, enrollment for specified term. |
|
|
Retention |
The BAC Outreach Report a comprehensive review of students belonging to the college by displaying priority 1 and priority 2 program seeking students. The report allows to view students based on status: AS, IS or IG. Based on the evaluation term, users are able to obtain information regarding active holds on the student account, identify degree status, obtain a summary of previously awarded NSU programs, obtain contact information, view academic program information, identify students with rate codes and applied web submission codes, identify a student's citizen status and academic advisor. |
|
|
Student Grades |
status of grades for the class. The report will reflect the number of missing grades, the number of students with I or PR grades, the number of students who have withdrawn and the number of posted grades from the respective section of the course. |
|
|
Recruit |
The Prospect to Enrolled by Term report provides a comparison of the admission funnel based on end of term, same day, last year and the day prior for the fall, winter and summer semesters with regards to performance of the prospect, inquiry, application started (this data is pulled from recruit), application submit, admitted and enrolled (this data is pulled from banner) counts and percentages. Sub reports regarding each of the categories can also be accessed from the main report. |
|
|
Grades |
The Change of Grade report by term allows users to pull a report of any student who has had a change of grade posted to their student account within a designated term. |
|
|
Enrollments |
The accepted by entry term cohort report will display students accepted for a specified semester. The report will display student data such as record status, registration status, application source, academic program, student contact information, admitted GPA, assigned recruiter and advisor. |
|
|
Student Grades |
Student Grade Audits from original to final Grades. |
|
|
Registration |
Active Students, not registered. |
Top 5 PowerBI Reports
|
Report Name |
Value Stream |
Purpose of Report |
|
Enrollment |
Enrollment, Registrations, Credit hours details by Student Primary College. |
|
|
Enrollment |
Enrollment, Registrations, Credit hours details by Course Secondary College. |
|
|
Student |
Recruit and Banner Student Funnel: Prospect to Enrolled. |
|
|
Enrollment |
Enrollment by Term and Weekly comparisons based on Pull/part time, Level, Program, Concentration from current and last Fall. |
|
|
Enrollment |
Enrollment by Term and Weekly comparisons based on Pull/part time, Level, Program, Concentration from current and last Winter. |
This option will allow you to submit a request for report access.
The following request types are managed and maintained within the Business Intelligence Office's Report queue.
This option will allow you to submit a request to develop a new one-time or recurring report using SQL Reporting Services(SSRS), PowerBI or MSExcel that may be published to SharePoint, Email or requested on-demand.
This option is for submitting a request to investigate an already developed and deployed report because you believe it is not working correctly or you believe it is returning incorrect data.
This option will allow you to submit an enhancement request to enhance a report using SQL Reporting Services(SSRS), PowerBI or MSExcel that may be published to SharePoint, Email or requested on-demand.
This option will allow you to submit a request for report access.
This option will allow you to submit a request to develop a new one-time or recurring report using SQL Reporting Services(SSRS), PowerBI or MSExcel that may be published to SharePoint, Email or requested on-demand.
This option is for submitting a request to investigate an already developed and deployed report because you believe it is not working correctly or you believe it is returning incorrect data.
This option will allow you to submit an enhancement request to enhance a report using SQL Reporting Services(SSRS), PowerBI or MSExcel that may be published to SharePoint, Email or requested on-demand.
This option will allow you to submit a request for report access.
Frequently Asked Questions
The Report Finder tool offers a comprehensive dashboard solution, facilitating users to locate existing data resources efficiently. These resources encompass NSU SQL Server Reporting Services (SSRS) reports and PowerBI dashboards. SSRS reports present tabular reports, while PowerBI dashboards typically display more graphic results. The Report Finder dashboard also introduces functionalities like a data dictionary and an access request feature, streamlining the reporting process and enhancing data accessibility.
SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services) and it is a reporting software that presents formatted reports with tables, graphs, and charts.
Power BI is a robust data visualization tool designed for exploring and understanding data visually. It's a business intelligence tool that tracks Key Performance Indicators (KPIs) and uncovers data insights.
If you require generating and using standard, paginated reports on-premise, for analysis, it is recommended to utilize SSRS. On the other hand, if you require creating and using interactive and analytical reports with rich graphics, Power BI Report Server should be a consideration.
Please access the Report Finder dashboard to search for additional reports and dashboards.
If you require additional report information not displayed in the top 10 reports in this page or in Report Finder, please contact the BI Team.