Data Warehousing
Definition of Terms

Data Analysis:
  • Make informed decisions by analyzing your school's data
  • Explore data from different angles and gain new insights
  • Find faster answers to Education-delivery questions

Cube:
  • A collection of related data on which you can perform analysis
  • The LEAP data resides in a cube
Dimension:
  • A grouping of data that defines something you're analyzing
Examples:
  • LEP
  • Building
  • Regular or Special Ed.
  • Mobility
  • Gender
Measure:
  • Performance indicators of the data that you are analyzing

Examples:

  • Score on a test

  • Number of days absent

  • Number of students exempted from a test

  • Amount of budget spent on each program

  • Percentage of students requiring special services

Multidimensional Analysis:
  • Analyzing school performance across different dimensions

Examples:

  • Percentage of students at each performance level on the ELA-4 for each income group

  • Percentage of Special Ed. students at each performance level of the ELA by level of integration

  • Percentage of students by integration level exempted from each ELA test

Levels and Categories:
  • Data is organized into dimensions and stored in a hierarchy of levels
  • A category is a data item that exists in a level


These pages ©1996-2005 Mid-Hudson Regional Information Center, .
All rights reserved.