Prepared 15 November 2026 · Sailors Academy · AI-assisted drafting. Original practice guidance; no named trainer review claimed.
Create a coherent synthetic dataset
Define what one row represents: an order line, transaction or inventory movement. Give records consistent product and date keys. Include a controlled return, missing field or duplicate for a cleaning exercise.
Keep the sample explicitly synthetic. A hypothetical hosiery shop is a useful local context, not evidence of a real business engagement or commercial improvement.
Model and reconcile before presenting
Check totals in a simple reference calculation before building measures. Review joins and relationships so one row does not multiply unexpectedly. Document how returns and date filters affect results.
Microsoft’s learning material separates data transformation, modelling and visualization. In your project, keep evidence for each stage instead of treating the final page as the whole analysis.
Bring your goals and build a practical plan
Bring your starting skills, a project question and any college requirements. Agree useful practice, realistic milestones and the work you will demonstrate.
Discuss your next step →
Make the demonstration explain a decision
Choose a few questions the dashboard can answer and show the filter context. Use readable labels, appropriate units and accessible comparisons. Explain missing data and any metric that cannot be supported.
For a hypothetical stock report, distinguish stock on hand from sales during a period. Do not compare unmatched windows or claim the dashboard increased sales without measured business evidence.
Try the original practice checklist
This is a planning exercise to complete yourself, not a claimed student result. Record your inputs, expected result, observations and corrections.
- Define the row grain and data dictionary.
- Calculate reference totals before modelling.
- Introduce a duplicate and show how you find or handle it.
- Explain one filtered metric, one limitation and the reconciliation trail.
Primary sources and further reading
Use the original documentation for current tool capabilities and requirements. These sources do not endorse the academy or establish classroom access.
A useful next step
Keep the task and your questions. Compare the relevant learning path, its prerequisites and a realistic training scope before enrolling.

