Log Data, also known as the ‘Factless Fact Table’

I love log data. I did a lot of log analysis early in my career. I see a lot of value added context when you combine parsing log data and allow for rollups and drilldowns.

Obviously, not every database schema can deal with the volume, the structure and the ‘unknowns’. I just think that before moving to a different architecture, try to add some filtering, or change the default report to show less data.