A lot of time, I hear discussions about which reporting tool is
the easiest to use for certain special tasks. Most of the time, I
just ignore these “threads” because it’s not my cup of tea as a
developer of ETL solutions.
However, it has to be said, often the solution to complex
reporting requirements is to be found in ETL.
When you find yourself struggling with complex reports that need
any of the following:
- compare different records
- aggregate beyond simple sums and averages.
- report on a non-existing records (report 0 sales, etc)
- …
Well, in those cases you need ETL.
Let’s take for example the case of the reporting on non-existing sales: how can you report that there has been 0 sales for a certain product during a certain week? Well, you can create an aggregate table in your ETL that contains the following:
- Dimensions
- …