Business Data Self-service Reporting
Also known as business analytics
CUIT's EBIS team facilitates and provides administrators at Columbia's schools and departments with the tools needed for self-service access to select sets of data standard dashboards and analytics. Secure data access is also provided.
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).
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
- Tuition Exemption
- Alternative Loan
- Annual Grade Report
- SFS & FDS reconciliation
- HR Reports
- Labor Relations
- InfoEd Proposals & Awards (Under construction)
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).