Business Data Self-service Reporting

Tools for self-service reporting, standard dashboards, and analytics

Also known as business analytics

CUIT's EBIS team facilitates and provides administrators at Columbia's schools and departments ​with ​t​h​​e tools needed for self-service access to select sets of data standard dashboards and analytics. ​Secure data access is also provided.

Supported Tools

Power BI is data visualization software that makes it easy to create beautiful and interactive maps, charts, and infographics. It is also an agile business analytics tool to create visual dashboards of University data to quickly discover data trends and how they may impact your organization. Power BI enables you to import data, perform visual analysis using intuitive dashboards, and securely share insights and data stories with your team, other departments, or to the world via your website.

To utilize, you must first have access to the data stores within the University Data Store (UDS) (or your own departmental databases) that you would like to analyze, and then email EBIS@columbia.edu for expanded access to Power BI (a limited data version is available for free on the Power BI website).

Image of sample Power BI dashboard
Image of sample Power BI dashboard

Allows users to drag and drop fields from, various “data universes” to build custom reports to support their needs. Data Universes available for self-service reporting:

  • Student 360 (student data pulled from various systems)
  • Financial Aid
  • Alumni
  • Registrar
  • Tuition Exemption
  • Alternative Loan
  • Annual Grade Report
  • SFS & FDS reconciliation
  • eCar
  • ePro-Spend
  • eCard
  • HR Reports
  • Labor Relations
  • InfoEd Proposals & Awards (Under construction)
  • BIS
  • PIS
  • FAS
WEBI sample list
WEBI sample list

Report delivery

The specific delivery time is dependent on the database that supports each set of reports:

  • Financial reports are dependent on the Financial Data Store (FDS), which is available from 8:00am - 12:00am (midnight).

  • Human Resources reports are available from 8:00am - 12:00am (midnight).

  • Student Administrative and Registrar reports are available from 7:00am - 12:00am (midnight).

FAQ

For data security purposes, you must have approved access to the data stores on which you would like a report.