M. D. Metadata Solutions. Introduction to Dimensional Analysis Session 2. 5/20/2005. Dan McCreary President Dan McCreary & Associates firstname.lastname@example.org (952) 931-9198. Agenda. General introduction to Data Dictionaries that drive Business Intelligence (BI) concepts and terminology
Source: Ralph Kimball
Publishing, Change, DataGap Analysis, New DataGathered
Insights, Conclusions andFindings
Monthly Green Bar Reports
Highly Responsive to "What If" Scenarios
Degree ofEnd User Control
few parameters, few filters
People are very good at recognizing and sorting things by their properties.
Note: NO OVERLAP!
Statisticians call this type of "categorical data" and it requires the categories to be non-overlapping.
What happens with a small percentage of data does not quite fit into a discrete category?
A measure is any property that you can perform math on (sums, averages).
Measures tend to have
data types of integers and
floating point numbers.
Note that categorical data can not beadded together. But we can count thefrequencies of items with a category!
Note that there is no reference to "Has Curves" in the prior table. "HasCurves" is a property of the shape value domain because it can be "inferred"from the shape of the object.
Some categorical definitions use "exclusionary" language.Note that "Has Curves" also must have a precise definition in the data dictionary.
Note that "Has curves" does not need to be in the central fact table.It is a property of the shape!
We have now added a 3rd dimension – "Dash Style"
A filter will exclude all objects with a specified property.
For example we can exclude all shapes with a property of "Circle"
This example filter removes all scores EXCEPT the valid scores.
This filter removes all scores EXCEPT the assessments Scale Scoreusing the Test Score Type dimension.
Integers or floats
that you can perform
Measures can be easily be added to the fact table without changing any of the dimensions.
Filter Dropped Here
Measures Dropped Here
Row and Column Dropped Here
The measure is the count of records in the cube.
The Column Dimension is the "Fiscal Year"
There are around
The Row Dimension is the "Test Name".
sum of all the expendituresin the category (Expenditures
On girls athletics for the fiscalyear 1991)
School Incident Data
District Financial Reporting
School and District Status
School Food and Nutrition
Student Disciplinary Reporting
Student Safety Reporting
District Technology Planning