How does this dimensional model map into an actual report?
Now if you look at a report generated from your dimensional modeled data warehouse, it will look like this:
You can tell from the above report that all your dimensions are the row and column headings in the report. The facts are the numeric numbers in the report.
Advantages of Star Schema
Star Schema is very easy to understand, even for non technical business managers
Star Schema provides better performance and smaller query times
Star schema is easily extensible and will handle future changes easily