Excel Power Pivot Project Assignment: Sales Data Analysis

Project Overview:

You are tasked with analyzing sales data using Excel Power Pivot to derive meaningful insights and create a comprehensive report. This assignment will involve loading data into Power Pivot, creating relationships, and generating various DAX (Data Analysis Expressions) measures to analyze the sales performance.

Objective:

1. Load and relate multiple tables in Power Pivot.
2. Create calculated columns and measures using DAX.
3. Develop a variety of pivot tables and charts to visualize the sales data.
4. Generate a report summarizing the key insights.