Comment by bkj123

This is where a good analytical (as opposed to operational) data model comes into play. Something less normalized that is intuitive and efficient to use.