This project focuses on understanding, cleaning, transferring, analyzing, and presenting financial data using Microsoft Excel.

1. Data Architecture The project follows a Star Schema structure, as evidenced by the tabs at the bottom of the workbook: FactSales: The core table containing transactional data (sales, profit, costs). Dimension Tables (DimSegment, DimCountry, DimDiscountBand): These tables provide descriptive attributes to filter and group the sales data. 2. Key Visual Components The dashboard on "Sheet2" is designed for interactive analysis: Pivot Table (Top Left): Summarizes the raw data, showing Sum of Profit and Sum of Target indexed by row labels (likely product or country IDs). Clustered Column Chart with Data Table: * Orange bars: Represent actual profit. Blue bars: Represent target profit. This allows for an immediate visual comparison of where the business is meeting or missing its goals. Slicers (CountryKey & ProductKey): These interactive buttons allow users to filter the entire dashboard by specific countries or products with a single click. 3. Project Objectives The primary goal of this project is Performance Monitoring. Specifically: Variance Analysis: Identifying which products or regions are underperforming relative to their targets. Profitability Insights: Seeing the total scale of profit (the Grand Total shows a value of approximately 1.23 billion). Interactive Reporting: Moving away from static tables to a dynamic environment where a manager can drill down into specific segments.