You have a Power BI Desktop model loaded from a flat table named SalesExtract. You need to refactor the model into a star schema with DimProduct, DimCustomer, DimDate, and FactSales. Arrange the required steps in the correct order.
Drag the options into the answer area in the correct order.
AVAILABLE OPTIONS
Create active relationships from each dimension key to the matching fact key, using one-to-many cardinality and Single cross-filter direction
Merge the dimension attributes back into the sales fact query before creating visuals
Create dimension queries by extracting distinct Product, Customer, and Date attributes from SalesExtract
Define a unique key in each dimension and keep the matching key columns in the sales fact query
ANSWER AREA
Drag options here