What the example shows
533 sales lines studied for 14 product groups and channels. Three SSP updates, one new SSP and three groups that need an estimate. A second workflow compares the study with last year's and checks that last year's approved SSPs reached the SSP table.
What you get
- The ebook: an 85-page PDF that walks through the workflow tool by tool
- 2 tested Alteryx workflows (45_SSP_Study.yxmd, 45b_SSP_Refresh.yxmd)
- Synthetic sample data (8 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
- Chapter 1Where does the SSP come from?
- Chapter 2The data and what is hidden in it
- Chapter 3The price population
- Chapter 4The median, computed explicitly
- Chapter 5The band and the study
- Chapter 6The update file, the exceptions and the controls
- Chapter 7Reading the result
- Chapter 8Moving it to your system
- Chapter 9The annual refresh
- Chapter 10Exercises
- Appendix ATool-by-tool settings
- Appendix BOutput field dictionary
- Appendix CAnswer key
Look inside


