Which metrics appear in multiple reports? These key values should be
calculated once per update cycle and
stored in one place.
Reports can pull values from the central location, solving
Slow Response, and
Identifying key metrics and setting up foundational tables isn't hard,
but some analysis is required. The goal is to
get rid of duplicate code.
Implementing Data Mart ETL for reporting and analysis involves
more than just updating code.
It's a shift in mindset, as well.
If you're just starting out with Data Mart ETL, it's worth
investing time up front to make sure everyone
understands the benefits.
For details, read my post:
Data Mart ETL Basics