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