Information Technology IT – 17 Data analysis and visualization | e-Consult
17 Data analysis and visualization (1 questions)
Login to see all questions.
Click on a question to view the answer
To identify the top 5 performing product categories, I would follow these steps:
- Data Preparation: Ensure the data is in a tabular format with columns for 'Product Category' and 'Sales Revenue'.
- Pivot Table Creation: Select the entire dataset and create a pivot table. Drag 'Product Category' to the 'Rows' area and 'Sales Revenue' to the 'Values' area. Ensure 'Sales Revenue' is set to 'Sum'.
- Sorting: Sort the pivot table in descending order based on the 'Sum of Sales Revenue' column.
- Filtering: Apply a filter to the pivot table to display only the top 5 rows.
- Chart Creation: Select the data from the pivot table (specifically the 'Product Category' and 'Sum of Sales Revenue' columns). Create a bar chart. The 'Product Category' will be on the X-axis and 'Sum of Sales Revenue' will be on the Y-axis.
Chart Type Justification: A bar chart is appropriate because it allows for a clear visual comparison of the sales revenue across different product categories. The height of each bar directly represents the total sales revenue, making it easy to identify the top performers.