Data Warehouse Glossary

 

OLAP Cube:

An OLAP (online analytical processing) cube is a method for storing data in a multidimensional form. It is optimized for storing data for reporting. OLAP cubes are designed using business logic and understanding. OLAP cubes are often pre-summarized across dimensions to drastically improve query time over relational databases.

Analysis Services server

Analysis Services is the server the runs the UGA Reporting Portal. It is primarily associated with the production of traditional" paginated reports. UGA Data Warehouse also uses the reporting server to display Power BI reports, KPIs, and allows access to the OLAP cubes.

Archive Data

Archive Data is data that has been moved from the legacy source system "as is" for the main purpose of safely retaining a final copy of source data as it existed prior to the mainframe decommissioning. In most cases it is not in a suitable format for, nor intended to be used in develop reports

Reportable Data

Reportable data is data that has been moved from the legacy source system with the purpose of being used in historical reporting.  Like "non-legacy" data, this type of data is typically validated and may be reformatted, summarized, restructured, and/or enriched with data from other sources for use in historical/trend reports, interactive dashboards, ad hoc reporting queries, and visualizations.

Transactional Data

Transactional data ...

Historical/Official Data

Historical data about the University of Georgia, such as the data available through FACTS, reflect past activities such as instruction during a recently completed academic term, research activity over the prior year, financial transactions over the prior fiscal year. These data are not subject to continued change, are considered official, and have typically been reported to external agencies and other reporting outlets.

Operational Data

Current or operational data, such as the data available in the data warehouse, are constantly changing as UGA conducts its business across missions. For example, students enroll, add, and drop classes; faculty obtain grants, publish research results, conduct outreach activities, and report course grades; administrative staff handle financial transactions, space assignments, and personnel decisions. These data and reports are not considered official, and you may see fluctuations in numbers reported on a daily basis.

SSRS, SSIS, SSAS

power BI?

report builder?