Let's improve the Tabular Model by Combining queries
2022TL; DR
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 demo several scenarios in which combining queries could be the perfect solution for the optimal tabular model.
Session Details
Cleaning and reshaping data with Power Query is one of the best parts of designing and delivering analytical reports with Power BI. This "full of demo" session will demonstrate several scenarios in which Combining queries could be the perfect solution for the optimal tabular model.
Some examples about what will be covered using Combining queries in this How's style session are the following:
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 and
Role-Playing Dimensions