Graphical presentations of data analysis that give users an at-a-glance understanding of key trends and metrics. These usually take the form of multiple reports and charts on a single web page or series of web pages.
The Data WarehouseA repository of a group or organization's electronically stored data, typically designed to facilitate reporting and analysis.
DimensionsThe natural groupings for measurements such as: Years, Months, Product Categories, Sales Regions, etc. For example, one might want to know the monthly sales by product.
ETL EngineETL stands for Extract, Transform, and Load. The ETL Engine moves the source data to the Data Warehouse, sometimes performing calculations or “transformations” on the way.
HierarchiesInherent in dimensions is the notion of hierarchy. Consider Time for example. There are many units of Time that one can be used to measure sales. One could look at yearly sales, quarterly sales, monthly sales, weekly sales, daily sales or even hourly sales. It is convenient, therefore, to think of all of these units as levels in a hierarchy of Time.
Integrated OLAP (On-Line Analytical Processing) EngineThe solution stage that analyzes data across multiple dimensions, allowing users to ask complex business questions and get rapid answers.
Interactive ReportsInteractive reports enable users to customize the presentation data. Interactive features include the abilities to sort, apply filters, define computations, create charts and select columns and rows. Interactive reports can also enable users to control file formats.
