The RevRec Canvas
Book 30: Checking customer attributes cover

Home › Reporting and analysis

Book 30 · Alteryx workflows for SAP RAR

Checking customer attributes

The customer channel, major and minor market and country on every POB, checked against the customer master and its sales areas: keys normalized the same way on both sides, every attribute matched, mismatched or not compared with a reason, and a row count that proves nothing was lost or doubled by a join.

  • Reporting and analysis
  • Intermediate
  • 91 pages
  • Tested workflows and sample data
$39Individual license · Team of five $117
Buy this bookTry the free Book 2 sample

What the example shows

559 POB customer attributes checked against the customer master. 15 real mismatches. Second workflow: the same attributes weighted by revenue, the disclosure before and after correction.

What you get

  • The ebook: a 91-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (30_Customer_Attributes.yxmd, 30b_Revenue_by_Attribute.yxmd)
  • Synthetic sample data (4 files) and an answer key, so you can check every number
  • Runs in Alteryx Designer 2023.1 or later; one zip, delivered by email right after payment

Contents

  1. Chapter 1The customer on the POB
  2. Chapter 2The three files
  3. Chapter 3Numbering and normalizing the POB rows
  4. Chapter 4One row per customer
  5. Chapter 5The lookups and the comparison
  6. Chapter 6Four files for four readers
  7. Chapter 7Proving the row count
  8. Chapter 8Reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10Revenue by attribute
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book 30: Checking customer attributes table of contents
Contents
Book 30: Checking customer attributes first page
First page