Multi-Source Sales & Budget Performance Analysis

Collected and consolidated sales and budget data from multiple files using Power Query, ensuring data accuracy through thorough cleaning and transformation. Utilized Power Pivot to build data models and perform advanced calculations, including monthly sales to budget ratios for each product across 2019 and 2020. Generated key performance indicators such as Achievement, Variance, and Variance Percentage to measure and compare product performance over time. Created interactive pivot tables and charts to visualize trends, enabling clear insights for decision-making.