Alder Transit wants regional order reporting from one reusable derived table. The analytics engineer must expose a monthly view, build the regional SQL aggregation, distinguish regional rows from order counts and hand a saved dashboard to operations. The browser rebuilds the local table for each run; it does not schedule a warehouse job. Retain the definitions so another analyst can explain the grain of every displayed column.
Alder Transit wants regional order reporting from one reusable derived table. The analytics engineer must expose a monthly view, build the regional SQL aggregation, distinguish regional rows from order counts and hand a saved dashboard to operations. The browser rebuilds the local table for each run; it does not schedule a warehouse job. Retain the definitions so another analyst can explain the grain of every displayed column.
Use the field picker and the generated result together. The warehouse contains repeated customer keys, orders with several items and missing values. Those rows make a plausible-looking total insufficient evidence. Run the requested definition, inspect its grain, and use the feedback to locate the mismatch. Every dataset here is fictional.
Group order revenue by sales channel.