Normal or De-normal – Query Editor
Query Editor is about understanding the shape your tables need to take on. It combines elements of Normalisation and De-normalisation. When to do either is a vital skill you need to learn
.
The Fugitive in action – Report Layer
Power BI Data models need to be correctly structured; the most efficient is an old favourite, the Kimble schema or “Star” schema.
Understanding the interaction across both the Query Editor and Report layer of Power BI is vital, well-structured data will result in quicker, more efficient DAX measures and a more interactive result for your viewers. Always be prepared to revisit your model either in Query Editor or in the Report layer as over time it will always need to change and evolve. A static model is likely unused.