Modularization is becoming a more recognized strategy for manufacturing companies in order to stay competitive when customers are requiring more customized products at commodity prizes and with lead times as of-the-shelf products. When manufacturing companies decide to make a transition from an overall non-modular to a modular approach, one of the main considerations is the technical task of converting a portfolio of non-or-semi modular products and manufacturing systems into a number of modular architectures. Because products and manufacturing systems may have been developed over time and in different locations in the organization, information is rarely collected in one place and in a format which makes is suitable for analysis. Therefore, the purpose of this research is to present an overall approach for collecting, modelling and analyzing data in order to create an decision support system (DSS) to be used when answering some of the questions that will arise in the technical transformation process. This includes both the identification of data, the ETL process and the modelling of these data in order to perform advanced analytics. Finally some examples from a case company will be presented.