OLAP Cubes | Argos | Evisions
Argos OLAP Cubes

A vital component of today's information access strategies is allowing users to perform analysis that is comprehensive, dynamic, and truly interactive.  With our optional OLAP feature (On-Line Analytic Processing), users can selectively extract data, view it across multiple dimensions, and from multiple different perspectives, to gain greater insights, uncover relationships, and identify key patterns and trends. 

OLAP cubes structure data hierarchically – the way managers think of their departments - but also allows users to rotate that data, changing the relationships to get more detailed insight into performance. This feature also provides advanced capabilities for complex calculations, trend analysis, and sophisticated data modeling.  Once a user has the data in the order and format they desire, they can easily present their data graphically through charting on the fly, or export the data to excel to share with others. Advanced users can also perform statistical analysis with forecasting and longitudinal (year over year) studies.

With Argos these cubes can be built off of ANY data source – you are not dependant on a data warehouse. The OLAP feature can fulfill many reporting needs with a single object and enables end-users to perform ad hoc analysis of data in multiple dimensions, providing the insight and understanding they need for better decision making.


OLAP Module
Employment Application
(click image to enlarge)
 

Filters (A) – parameters offered to the user to exclude unwanted data in the cube. Reduces the amount of data, which allows the underlying database to take advantage of existing indexes to speed the retrieval and aggregation of the data.

Available Dimensions (B) – data categories that can be dragged to either the Column (C) or Row (D) dimension area. Users can also click on the arrow to filter, sort or enable forecasting of the dimension.

Column Dimensions (C) – one or more dimensions selected by the user to be displayed as columns in the cube. Multiple dimensions are nested and clicking the “+” in the work area will expand the columns to display additional dimensions.

Row Dimensions (D) – dimensions selected by the user to be displayed as rows. Like Column Dimensions, multiples can be selected and configured, and viewed by clicking the “+” in the work area.

Measures (E) - calculations made using the selected parameters and dimensions. Users can modify measures or build custom measures by clicking the arrow to retrieve the Measure Manager. Measures can be calculated using value, percents, ranks, running totals, sum, etc. and can be filtered and formatted.

 



Examples
Advancement Gift
(click image to enlarge)
  This is an all encompassing Advancement OLAP cube. There are 12 measures that can be analyzed and the user can choose one or more of them. Some of those measures include the following: Donor Count, Gift Count, Gift Amount, and Pledge Amounts. Those measures can be broken down by one or more of over 20 dimensions. Some of those dimensions are: Pledge Type, Gift Type, Calendar Year, Event, Fiscal Year, Month, Gender, Age, and Ethnicity. This OLAP Cube will also let users filter by Calendar Year or Years, and by Event(s).

 

Employee
(click image to enlarge)
  This is an all encompassing Employee OLAP Cube. There are over 20 measures that can be analyzed and the user can choose one or more of them. Some of those measures include the following: Employee Count, Years of Service, Earnings, Annual Salary, and Leave Benefits. Those measures can be broken down by one or more of over 20 dimensions. Some of those dimensions are: Age Range, Salary Range, Position, Gender, Ethnicity, Tenure, and Employee Status. This OLAP Cube will also let users filter by Calendar Year or Years, Calendar Month or Months, and by Event(s).

 

Financial Aid
(click image to enlarge)
  This is an all encompassing Student Financial Aid OLAP Cube. There are 13 measures that can be analyzed and the user can choose one or more of them. Some of those measures include the following: Student Count, Award Offered, Award Accepted, Award Paid, and Award Averages. Those measures can be broken down by one or more of nearly 30 dimensions. Some of those dimensions are: Campus, College, Department, Program, Major, Aid Period, Age, Gender, Ethnicity, and Enrollment Status. This OLAP Cube will also let users filter by Event(s).

 

Graduation Completion
(click image to enlarge)
  This is an all encompassing Student Graduation OLAP Cube. There are 13 measures that can be analyzed and the user can choose one or more of them. Some of those measures include the following: Student Count, GPA, Degree Awarded Count, Credits Attempted, Credits Earned, and Credits Passed. Those measures can be broken down by one or more of over 25 dimensions. Some of those dimensions are: Academic Period, Event, Age Range, College, Gender, Major, Ethnicity, Residency, and Student Classification. This OLAP Cube will also let users filter by Academic Year or Years, and by Event(s).

 



Info Buttons - Argos

Request More Information on Argos

Request an Argos Demo

Request an Argos Evaluation

View an Argos Webinar

 

Downloads

OLAP CubesClick here to download the Argos OLAP Cube data sheet.