Convert OLTP database to OLAP Datawarehouse
First in this case I suggest you to adopt a star schema. the  transaction_data table obviously will be you reference to construct your fact table because it contains 'measures' like quantity,sales_value and other numeric attributes , the fact table also will contain substitution-keys of dimensions tables like Time, Product, Customer,demographic, etc.