Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise