Business organizations have been adopting different strategies to impress upon their customers and attract them towards their products and services. On the other hand, the opinions of the customers gathered through customer feedbacks have been a great source of information for companies to evolve business intelligence to rightly place their products and services to meet the ever-changing customer requirements. In this work, we present a new approach to integrate customers' opinions into the traditional data warehouse model. We have taken Twitter as the data source for this experiment. First, we have built a system which can be used for opinion analysis on a product or a service. The second process is to model the opinion table so obtained as a dimensional table and to integrate it with a central data warehouse schema so that reports can be generated on demand. Furthermore, we have shown how business intelligence can be elicited from online product reviews by using computational intelligence technique like rough set base data analysis.