In Agile development, Storypoints serve as a relative effort of complexity. Work complexity is estimated by comparing it against previous work and ranking the work as more or less complex compared to earlier work with known complexity.
Below is an overview of storypoint estimates on data objects delivered in past PI's to serve as a common baseline understanding of storypoint complexity for different data objects.
| PI | Analysis | Design | Ingestion | Transformation | Test | Storypoints | Justification | |
|---|---|---|---|---|---|---|---|---|
| Q2 | GBU | S | S | S | S | S | 2 | |
| Region | S | S | S | S | S | 2 | ||
| FX Rates | S | M | M | S | M | 5 | ||
| Q3 | Market & End Use | S | S | S | S | S | 2 | |
| Region | S | S | S | S | S | 2 | ||
| Customer | M | M | L | M | S | 13 | ||
| Product | M | M | L | M | S | 8 | ||
| Q4 | Sales History | L | L | L | XL | L | 20 | |
| Sales Forecast | L | L | L | XL | L | 20 | Roughly the same complexity as Sales History. The data itself is less complex, but the business rules on data enrichment are more complex so it roughly balances out. | |
| FX Rate Enhancement | 8 | |||||||
| Customer Extension SpP | 13 | Extending the existing customer data model with new segmentation fields and consolidating into a global view. Quite some unclarity on the requirements and risk that it could be same amount of effort as initial creation. | ||||||
| Product Extension SpP | 8 | |||||||
| Market Extension SpP | 8 | |||||||
| Contract Book | 13 | Less complex compared to Sales History and Sales Forecast as there is very limited transformation required. | ||||||
| Plant Dimension | 5 | |||||||
| CPC Design | 13 |