Data Analyst Resources

Access CU Data and Training Tools

Enterprise Business Intelligence Solutions EBIS

Databases

• Azure Gateway (Cloud)
• Oracle (relational database)
• SQL Server

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

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)

Systems

• Student Admin Data Store (SDS)
• Financial Data Store (FDS)
• Human Resources Data Store (HRDS)
• Research Data Store (RDS)
• Integrated Data Store (IDS)
• Historical Data Store (HDS)

Student Desktop Reporting

Data Self Service Reporting