CofC Logo

Reporting Solutions

About Reporting Tools

The College is developing a robust Business Intelligence environment to fulfill the needs of the end-users on-campus and within the community, including the suite of Cognos BI studios, along with other appropriate applications. Reports are produced using one of the tools the College offers and provided through the collaborative efforts of Information Technology (IT), Institutional Research and Planning (IRP) and other College departments such as the Registrar's Office and Business Affairs.

Data Warehouse

The College's current administrative data lives in a transaction (or operational) database called Banner.  Since reporting from a transactional database can unnecessarily affect the performance of the system, the College has implemented a Data Warehouse called the Operational Data Store (ODS). It is a stand alone system, so that querying and reporting from it will have no impact on Campus ERP, Banner. Data is updated two times daily: nightly beginning at 1:00 AM so that each morning the data reflected in reports matches the data that was input into Banner since the last refresh completed, and refreshed again mid-day beginning at noon. All Cognos reports utilize data from either Banner or DegreeWorks, the College's degree audit application and academic advisement tool.

Cognos

Cognos is IBM's business intelligence and performance management software suite. The College utilizes Cognos to enable faculty and staff without technical knowledge to extract college data, analyze it, and assemble reports. Cognos capabilities include operational reporting, analysis, dashboarding, and scorecards delivered through a web-based platform.

This powerful business intelligence tool is primarily used for reporting data from our ERP, Banner, but can also be integrated with other databases. Features of the tool allow the College users to do data analysis, discover trends, and distribute reports in different formats such as Excel. The user can feel confident that the data is in a secure, user-friendly environment. Training and documentation are available to College faculty and staff on the Business Intelligence website.

Contacts:

For problems: Please use the Additional Documentation page within the BI website. If you cannot find a solution there, please contact CognosHelp@cofc.edu.

For trouble logging on please contact Helpdesk.

Exisiting Report access:

  • Cognos or the ODS: Business Intelligence Team, CognosHelp@cofc.edu
  • To request access, go to the My Forms tab in MyCharleston.

Data Stewards:

  • Finance: Sam Jones, Dawn Willan
  • Student: Mary Bergstrom
  • Financial Aid: Don Griggs
  • Admissions: Darin Junck
  • Employee: Dee Cole, Sam Jones
Lower Banner 2