- Which two ways can be used to reduce the number of rows in a data set?
- Which visualization should you use to display the total profit value in a sales data?
Which two ways can be used to reduce the number of rows in a data set?
Remove unnecessary rows
It can be achieved by loading filtered rowsets into model tables for two different reasons: to filter by entity or by time. Removing rows is referred to as horizontal filtering. Filtering by entity involves loading a subset of source data into the model.
Which visualization should you use to display the total profit value in a sales data?
Area charts emphasize the magnitude of change over time, and can be used to draw attention to the total value across a trend. For example, data that represents profit over time can be plotted in an area chart to emphasize the total profit.