For analytics and specially for Data Warehousing and Business Intelligence we need a special data model that’s optimized for
Star Schema is easy to use and understand but the dimension tables can get large containing duplicates as the database getting bigger by time and that costs storage
More Complex and a lot of effort to query something out of it but redundancy breaks down so we can optimize storage but who cares !