Question

A data analyst is building a Power BI data model for sales reporting. They have one large table of individual sales transactions and several smaller tables describing products, customers, dates, and store locations. To follow analytics best practices and optimize query performance, how should the analyst structure this data model?

Accepted Answer

Design a star schema with the sales transactions as a fact table surrounded by product, customer, date, and store dimension tables

Answer

Combine all tables into a single flat table so no relationships are needed

Answer

Keep every table completely isolated with no relationships and use separate reports for each

Answer

Store all tables in DirectQuery mode to avoid building any data model at all