The current paper presents a comparison study between the Data Vault and the Dimensional Modeling and focuses on their performance in data loading and storage efficiency using the TPC-DS dataset. Data Vault, known for its adaptability and scale, is analyzed against a star schema Dimensional Model, known for its simplicity and query optimization. Through empirical evaluations covering data load speed, storage utilization, query execution, and scalability metrics, the author investigates the strengths and weaknesses of each modeling technique. It leverages real scenarios represented by the TPC-DS dataset, exploring various data volumes, complexities, and schema evolution scenarios. By analyzing the compromises between complexity and performance, the research aims to provide valuable insights for organizations that seek to optimize their data storage strategy. The findings presented in this paper aim to guide researchers and practitioners in choosing a data modeling technique according to their needs.