Data warehouses are vital for analyzing vast amounts of data and gaining valuable insights. To effectively 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 effective in creating these warehouses. In a star schema, facts are stored in a