Hello, I need help with making a Data Modeling (Data Warehouse) for my company. I chose the Leaf filter below. I made some tables, but I need help with making them into a data modeling tables by Using a modeling software,

Fact Table:

Fact Table: SalesTransaction

Attributes:

1. TransactionID (unique identifier for each sales transaction)
2. CustomerID (unique identifier for each customer)
3. ProductID (unique identifier for each product)
4. Date (date of the sales transaction)
5. Quantity (number of units sold)
6. UnitPrice (price per unit)
7. TotalPrice (total price of the transaction)
8. Discount (discount applied to the transaction, if any)
9. Revenue (revenue generated from the transaction)
10. Cost (cost associated with the transaction)
11. Profit (profit generated from the transaction)
12. SalesRegionID (unique identifier for each sales region)
13. SalespersonID (unique identifier for each salesperson)
14. PaymentMethod (method used for payment, e.g., cash, credit card)
15. ShippingMethod (method used for shipping, e.g., standard, express)
16. InstallationLocationID (unique identifier for each installation location)
17. InstallationDate (date of product installation)
18. WarrantyID (unique identifier for the warranty associated with the product)
19. LeadSource (source from which the lead/customer was acquired)
20. MarketingCampaignID (unique identifier for the marketing campaign associated with the sale)

Note: The above attributes are examples and may vary based on the specific requirements and nature of the business operations in Leaf Filter Gutter Protection

Dimension Tables:

Date Dimension:

• Date ID (Primary Key)
• Calendar Year
• Calendar Quarter
• Calendar Month
• Calendar Day
• Fiscal Year
• Fiscal Quarter
• Fiscal Month
• ...

Customer Dimension:

• Customer ID (Primary Key)
• Customer Name
• Customer Address
• Customer City
• Customer State
• Customer Country
• Customer Segment
• ...

Product Dimension:

• Product ID (Primary Key)
• Product Name
• Product Category
• Product Subcategory
• Product Brand
• Product Color
• Product Size
• ...

Location Dimension:

• Location ID (Primary Key)
• Location Name
• Location Address
• Location City
• Location State
• Location Country