Question 1 of 30
A retail company is analyzing its sales data to identify trends over the past year. They have a dataset that includes sales figures, product categories, and dates. The company wants to transform this data to calculate the total sales for each product category on a monthly basis. Which of the following transformations would be most effective in achieving this goal?
Grouping the data by product category and month, then summing the sales figures for each group.
Filtering the dataset to include only the top-selling products and then calculating the average sales per month.
Creating a new column that concatenates product categories with sales figures to visualize the data better.
Sorting the dataset by date and then applying a cumulative sum to the sales figures.

Preparing for Microsoft DA-100 Analyzing Data with Microsoft Power BI? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free