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