$2.$ Create Pivot Tables $(30$ points @$10$ points each$)$:

$$ Pivot Table $1$: Answer the following questions using pivot tables:

$$ What is the total sales revenue for each product?

$$ What is the average sales revenue per product?

$$ How do sales vary by product over time? Create a line chart to visualize this.

$$ Pivot Table $2$: Explore customer demographics:

$$ What is the distribution of customer ages?

$$ How does sales revenue vary by customer gender?

$$ How does sales revenue vary by customer location?