Data warehouse reporting and analytics

Known alias from A-Z: Business intelligence, Enterprise data warehouse, Financial reporting, and Managerial reporting

What is data warehouse reporting & analytics?

DGIT’s enterprise data warehouse transforms raw data into actionable insights that empower researchers, faculty, and staff at UCLA Health Sciences to make empirically sound, strategic decisions.

By collecting, processing, and integrating data from multiple sources and different collection systems, the warehouse helps us create reports that enable collaboration and advancement in institutionally significant areas, from research to finance.

 

 
DGIT’s Enterprise Data Team is developing the data warehouse as we speak. When it’s ready, we’ll provide you with reports and tools aligned with your specific needs.
 
To ask questions about the data warehouse or discuss a specific data project, please create a service request ticket. 
 
 
 
 

We’re happy to provide ad-hoc reports and analytics assistance, but we also plan to offer resources to help departments across UCLA Health Sciences access the data warehouse and create their own customized reports, dashboards, charts, and more.

These resources include:

 

Data warehouse training

We’ll provide the tools users need to get the most out of our data warehouse.

We’ll show you:

  • How to bring data into the warehouse through the ETL process
  • How to develop your own models
  • How to create a data mart

 

Reporting and analytics training

We’ll offer training on analyzing and leveraging the warehouse data.

We’ll show you:

  • How to use the reporting tools
  • How to use the analytics tools
  • Which data marts to access
  • How to make data reports actionable
  • How to present your findings

 

A data catalog

Users will be able to log in and browse available data in a comprehensive catalog.

 
 

Enterprise Data team

Supporting empirical business decisions 

We aim to provide the right information to the right people at the right time.

Our secure data repository enables the modeling, analysis, and reporting our community needs to build optimal business analytics strategies based on meaningful, relevant data. 

Meet the team

 

Service frequently asked questions

What is a data warehouse?

 

A data warehouse is a digital system for storing, organizing, and accessing large amounts of data. Just as a physical warehouse is organized to make merchandise fast and easy to find and ship, a data warehouse is organized to make information fast and easy to find and use.

How will data warehouse reporting and analytics benefit my work?

 

The data warehouse enhances work by providing access to massive amounts of quality data. Our technology brings all UCLA Health Sciences data—even data from different departments and collection systems—into one warehouse, making it possible to create reports that detect trends and patterns across several studies and disciplines.

We manage, update, and support the warehouse and provide our community with data access, reporting, analytics, and training, free of charge.

What kind of reports can I access?

 

Our data warehouse enables a variety of reporting and analytics solutions, including:

  • Data visualizations and models
  • Real-time queries
  • Dashboards
  • Drillable reports
  • Multidimensional analysis
How does the data warehouse work?

 

The data warehouse uses the extract, transform, load (ETL) process to turn raw data from disparate sources into useful formats, such as visualizations, reports, and dashboards.

How the data warehouse works