Datamart with Transaction Data

Owned by Jana Volencová (Deactivated)
Jan 28, 2022
1 min read

Below fields are used in Basic Analysis Dashboard:

  • Product ID

  • Product Name

  • Product Group

  • Customer ID

  • Customer Name

  • Customer Class

  • Customer Type

  • Invoice Price

  • Quantity

  • Pricing Date

  • Pricing Date Week

  • Pricing Date Month

  • Pricing Date Quarter

  • Pricing Date Year

  • (Gross) Margin

  • (Gross) Margin Percentage

  • Sales Channel Discount (optional)

  • Promotion Discount (optional)

  • Competitor Discount (optional)

  • Volume Discount (optional)

  • Customer Negotiated Discount (optional)

 

Please keep in mind that only proper data is needed, there is no need to match name/label with POP’s predefined names. Mapping Datamart fields to the dashboard is done in the next step.