Sounds to me like what you need is a Data Warehouse. If you build one, the methodology will suggest the form in which data should be in to make queries flexible and easy.

There are several sites explaining this analysis, which takes you probably less time than what you will lose trying to figure complex queries on a normal DB. I have long lost the url's but just google 'data warehouse'.