Cleaning and reshaping data with Power Query is one of the best parts of designing and delivering analytical reports with Power BI. This session will look at the importance of query combining.
We will answer the question when it is not a query combination, a step that merges two queries.
This session will demo several scenarios in which Combining queries could be the perfect solution for the optimal tabular model. Some examples are:
Identify entities and attributes.
Respect the star model design.
Protect the fact tables model.
Data quality tasks.
Version control of data.
Management of excluded sets.
VLookUp vs. Aggregates.
Role-Playing Dimensions.