Data warehouses are vital for examining vast amounts of facts and gaining valuable insights. To optimally manage this wealth of data, a well-designed data warehouse is essential. The star schema is a widely used dimensional modeling technique that proves particularly beneficial in creating these warehouses. In a star schema, facts are stored in a