Featured Project: Sales Performance & Profitability Analysis

A detailed look at a project where I used Excel, PivotTables, and VBA to analyze sales data and automate reporting.

Objective

  • Analyze regional sales performance, profit margins, and automate repetitive reporting using Excel VBA.

Approach

  • Built PivotTables and PivotCharts to analyze sales by region and category.
  • Created KPIs for revenue, profit, discounts, and preparation times.
  • Developed VBA macros to automate repetitive reporting tasks.

Results

  • Automated reporting processes saved approximately 20 hours per month. 
  • Identified West & East regions as top performers, while Central region lagged in profitability.
  • Found seasonal trends (e.g., higher profit margins in March, October, and December).
  • Reduced manual reporting time with VBA automation.

Project Files

Link to Excel Analysis:

👉Click the link below to download the Excel file from Dropbox and explore the full interactive analysis

https://www.dropbox.com/scl/fi/w00wp2yrd4ose6e6a33u5/Sunehra-Tazreen-Excel-Analysis.xlsm?rlkey=9z3m2wo0msgowk2i3ku2j2e1b&st=cm0x64ts&dl=0

Excel PivotTables, Macros & VBA Report

This PDF demonstrates advanced Excel techniques including PivotTable analysis, automation with Macros, and custom VBA scripting to streamline reporting and enhance data-driven decision-making.

Excel Pivottables Macro And Vba 1 Pdf
PDF – 250.7 KB 0 downloads

How to View This Project?

  • To explore the analysis, please download the Excel file from Dropbox and interact with the PivotTables, macros, and VBA automation directly.
  • For additional context, refer to the attached PDF document, which provides a detailed explanation of the methodology, steps, and key insights from the project.