Data warehouse design from social media for opinion analysis: the case of Facebook and Twitter

In the recent years, the number of social media, such as Facebook, LinkedIn, Tumblr have been increasing regularly, have become ideal platforms for a large number of users at lower costs. However, social media helped companies get known by a wider public and collect the relevant information's about customers, their needs and their expectations. Therefore, several decision makers have worked on these media to get extra information about companies and customers. Moreover, the explosive growth of the amount of data makes their analysis and usage difficult. Therefore, the collection, analysis and the storage of these data in a data warehouse are extremely necessary. Thus, data warehouse modeling from social media should take into account aspects of social media. This paper proposes an approach for data warehouse construction from social media. Precisely, it deals with the conceptual modeling from social media, especially Facebook and Twitter. The proposed model can predict the success of the products prospects and improve the existing products.