Enterprise Business Intelligence Solutions

The mission of CUIT’s Enterprise Business Intelligence Solutions (EBIS) team is to support the strategic and operational needs of Columbia University in the City of New York. We provide access to essential University data through the use of industry best practices and innovative solutions. EBIS strives to provide reliable, accurate, timely and secure information from across multiple key University functions such as Finance, Human Resources, Student Administration, Research and beyond. By utilizing cutting edge enterprise-wide technologies, the EBIS team provides services which collect, connect, integrate, transform, analyze and present data in order to facilitate the making of informed decisions and critical business insights.

Databases
  • Azure Gateway (Cloud)
  • Oracle (relational database)
  • SQL Server
Data Integration Tools
  • Business Objects Data Services (BODS) (Extract-Transform-Load, ETL tool)
  • Embarcadero ER/Studio (Data modeling, metadata tool)
  • Oracle and SQL Server utilities
  • SQL Server Analytical Services (SSAS) (Multi-dimensional database, cubes)
  • SQL Server Integration Services (SSIS) (ETL tool)
Reporting, Self-service and Analytical Tools
  • Business Objects Enterprise (Report Delivery platform)
  • Columbia University Data Cookbook
  • Crystal Reports (report creation tool)
  • Focus
  • Infomaker
  • Power BI Analytics (Analytics tool)
  • Web Intelligence, Universe Designer

Our Services

Location

Studebaker Building
615 West 131st Street
New York, NY 10027

For general inquiries, please email us at EBIS@columbia.edu