example is that the storage requirements are lower since the snowflake schema eliminates many duplicate values from the dimensions themselves. SELECT B.Brand, G.Country, SUM(F.Units_Sold) FROM Fact_Sales F INNER JOIN Dim_Date D ON F.Date_Id = D.Id INNER JOIN Dim_Store S ON F.Store_Id = S.Id INNER JOIN Dim_Geography G ON S.Geography_Id = G.Id INNER JOIN Dim_Product P ON F.Product_Id = P.Id INNER JOIN Dim_Brand B ON P.Brand_Id = B.Id INNER JOIN Dim_Product_Category C ON P.Product_Category_Id = C.Id WHERE D.Year = 1997 AND C.Product_Category = 'tv' GROUP BY B.Brand, G.Country See also Star schema Data warehouse Online analytical processing (OLAP) References Bibliography External links "Why is the Snowflake Schema a Good Data Warehouse Design?" by Mark Levene and George Loizou Reverse Snowflake Joins Data warehousing Articles with example SQL code Online analytical processing