The expansion of higher education (HE) institutions and their increased emphasis on strategic planning have raised the demand for integrated information systems that can support strategic analysis. A data warehouse (DW) provides decision data for managers in a form that facilitates their access, using business intelligence (BI) tools to enhance their decision making process. However, available DW models and design methods do not address the HE industry’s specific needs. In this paper, we aim to fill this gap by providing a methodological framework that encompasses methods tailored to meet the needs of HE. Also, a prototype has been developed using actual student data to validate the framework. It shows the efficacy of the framework in supporting strategic analysis at universities, leading them to develop effective strategies and policies. The paper further provides guidelines for researchers on the important issues to be considered for designing efficient DWs.