Routing queries with aggregation tables
The analytics team added MonthlySalesAgg next to Sales in SM_RetailSales so summary visuals scan fewer rows. The image compares the two tables: Sales has one row per order line, with OrderID, CustomerID, ProductID, OrderDate, Region, and Amount. MonthlySalesAgg has one row per month and region, with Month, Region, and TotalAmount. Which report request can MonthlySalesAgg answer on its own?
This exercise is part of the course
Data Ingestion and Semantic Models with Microsoft Fabric
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise