Data Modelling - Working with data from 5 sources

Hey danielboi ,

from the information you provided my model would contain 4 dimension tables

• period
• customer
• distribution channel
• product

and 3 fact tables

• forecast volume
• actual sales price
• sales budget

I'm wondering why there is a column Product Category in both of the tables Forecast Volume and Sales Budget.

From my understanding based, on the columns names, the column Product Category groups different Product Codes. For this reason I would have created a Product Dimension table that will contain the following columns:

Product Code | Product Category | Actual Cost | Budgeted Cost

Then I would connect to the Product dimension table to the three fact tables, the Product Code column is used to create the relationships.

Hopefully, this provides some ideas helping you to proceed.

If not, provide a screenshot of your datamodel, the model view.
In addition to that consider creating an Excel file with sample data, one sheet for each of your five tables. Upload the Excel file to onedrive or dropbox and share the link. Describe the issues that you are facing based on the sample data you provided.

Regards,

Tom