Please see lecture notes for dimensional modeling here.
The pivot table example spreadsheet can be downloaded here.
Also there is a dataset I generated from database of Amazon (indirectly of course):
from amazon.com (run scripts to get a dimensional csv file)
and to this for analysis.
Then we can use our statistical and mathematical knowledge to analyze the dataset as we want (e.g., cluster analysis, regression analysis, etc.)