What are the tools available for accessing data?
The UCSB Data Warehouse is a central repository of institutional data that includes information from several transaction systems. Power BI, EZ Access, and Hyperion Desktop are tools for reporting, analytics, and business intelligence (BI). With Power BI and EZ Access, users can run standard reports with sort and filter features; with Hyperion Desktop and Power BI users can customize queries and reports. All of the tools listed here utilize information stored in the Data Warehouse.
Account and Access | Data Warehouse | EZ Access | Hyperion Desktop | Power BI |
Direct Access to Tables/Views | Y | N | Y | Y |
Standardized Reports | Y | Y | N | Y |
Customize Queries/Ad Hoc Reports | N | N | Y | Y |
Export to Excel | N | Y | Y | Y |
Export to PDF | N | Y | N | N |
Login Method | Hyperion, SQL | Single Sign-on | Hyperion | Power BI |
Password Management | Self-Service | Identity | Self-Service | Identity |
Type of Tool | Data Repository | Reporting | Reporting | Business Intelligence |