Microsoft Power BI Data Analyst Certification (PL-300) Practice Test

To reshape a table with monthly sales data into a single sales amount column, the appropriate transformation is to select the Country column and then select Unpivot Other Columns. This process involves taking the monthly sales data that is likely spread across multiple columns—each representing a different month's sales—and converting those columns into rows.

By using the Unpivot function on the other columns while keeping the Country column fixed, you effectively consolidate the sales data into two columns: one for the month (which would become the new column heading) and the other for the sales figures. This structured approach aligns with the goal of simplifying data analysis, enabling easier aggregation and insight generation by allowing the sales figures to be more easily manipulated and visualized as needed.

The Unpivot Other Columns transformation is particularly useful when you have categorical data (like Country) you want to retain while transforming quantitative data from a wide format (many columns) to a long format (fewer columns). This format is often more suitable for analysis in tools like Power BI, where the emphasis is on visualizing trends over time or across groups.