Building reports in an agile way
In this section, we will decompose in stories a feature to build a report in a very general way that you can use for any report and, pretty much, for any other result deliverable in a data mart.
The “F1 – building a customer current position report” feature can be split into stories of these five types:
- S1 – designing a light data model for the data mart to power the F1 report.
- S2 – designing a light data model for the REF layer to power the data mart for the F1 report.
- S3.x – developing with dbt models the pipeline for the
DIM_x / FACT_x / REF_xtable. This is not one story but a story for each table in the data mart, plus each necessary support table in the REF layer. We will discuss more details later. - S4 – an acceptance test of the data produced in the data mart.
- S5 – development and verification of the report in the BI application.
These five types of stories...
