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_x table. 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...