Create a Project Report that will satisfy and answer the following:
1 Based on the above OLTP system, what dimensions can be identified?
2 What are the measures and grain?
3 Create a graphic diagram using either Visio or taking a screen shot
4 Create the SQL statements for the data base schema that will build the dimension and fact tables.
5 Populate the dimension tables with some sample data.
The detailed are in the file.
hi
I am professional data warehouse consultant and do dimension, fact and reporting design and recommend tools i am keen to do this project for you. Please connect with me for further discussion.
regards,
Puneet