Question

In your Power BI report, you have the Sales table that has the following column. The Sales table contains one million records per month. You want to minimize the data model size and count sales by date and store. How can you meet the two goals?

(a) Use separate tables for each month
(b) Combine date and store columns for a composite key
(c) Create summarized tables for date and store sales
(d) Use data compression techniques for the entire table

Answer 1

To minimize the data model size and count sales by date and store in Power BI, the best approach would be to create summarized tables for date and store sales.

Step-by-step explanation:

To minimize the data model size and count sales by date and store in Power BI, the best approach would be to use option (c) Create summarized tables for date and store sales.

This involves creating separate tables that summarize the sales data by date and store, rather than using separate tables for each month or combining the date and store columns for a composite key.

By creating summarized tables, you can aggregate the sales data and reduce the number of records, resulting in a smaller data model size and faster performance.