Mapping of Reports to Star Schema
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