POWER BI [PI-300]: You need to reduce the size of a Power BI model that contains two dimension tables named Date and Location, and one fact table named Temperatures. The Temperatures table contains the following fields:

Reading Time (datetime)
DateKey (date)
LocationKey (whole number)
Temp C (decimal)
You have one row for every 5-minute interval for each location. The Temperatures table is related to the Date and Location dimensions by using many-to-one relationships.

You need to reduce the cardinality of the table. The solution must ensure that the dataset supports reports that analyze average temperature by hour and location.

What two actions should you perform? Each correct answer presents part of the solution.

Question

You need to reduce the size of a Power BI model that contains two dimension tables named Date and Location, and one fact table named Temperatures. The Temperatures table contains the following fields:

Reading Time (datetime)
DateKey (date)
LocationKey (whole number)
Temp C (decimal)
You have one row for every 5-minute interval for each location. The Temperatures table is related to the Date and Location dimensions by using many-to-one relationships.

You need to reduce the cardinality of the table. The solution must ensure that the dataset supports reports that analyze average temperature by hour and location.

What two actions should you perform? Each correct answer presents part of the solution.

da-bi · Accepted Answer

Create a column that contains the time values for the start of the hour of the Reading Time value.
This answer is correct.
Use the Group By functionality to aggregate the rows by hour, DateKey, and LocationKey and then create an average Temp C value per row.
This answer is correct.

POWER BI [PI-300]

Create a column that contains the time values for the start of the hour of the Reading Time value. This answer is correct. Use the Group By functionality to aggregate the rows by hour, DateKey, and LocationKey and then create an average Temp C value per row. This answer is correct.

Author