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