Problem
Your task is to first identify an existing report. A scanned paper report, a spreadsheet, something you make up and mockup yourself, or source from the web--any of these are acceptable.
Your deliverable is a copy of the report, along with answers to the following questions:
A. Who is (or seems to be) the intended audience for this report?
B. How will the report user benefit from the information in the report? For example, what decisions might be made differently based on the data in the report.
C. Create dimensional model and describe the dimensions, fact tables and measures based on the data used in the report. You can use a tool like Microsoft Visio, or Microsoft Word to create the dimensional model diagram, or simply draw it in a paper and scan the image. Ensure your diagram complies to a star schema structure.
D. How might you extend the report to make it more useful?