Interactive Dashboard for Profitability & Trend Analysis in Microsoft Excel US Superstore Sales Intelligence
👋
Project Highlights:
This page provides an executive summary of the analysis. For the complete code, step-by-step data cleaning, and detailed statistical modeling, please refer to the Full Project Links at the bottom of this page.
Over 9,900 transaction records (2014–2017) were transformed into strategic insights through an Interactive Excel Dashboard. Exploratory Data Analysis (EDA) was conducted to map profitability patterns, shipping trends, and discount impacts utilizing advanced pivot tables and slicing for dynamic visualization.
Office Supplies was identified as the primary volume driver, while significant profit leakages were detected in major markets such as Texas, Colorado, and Ohio. These findings were consolidated into an integrated dashboard to facilitate real-time sales performance monitoring and strategic business improvements.
Post a Comment