This project presents a detailed supply chain analysis using the Global Superstore dataset. Built using Google Looker Studio, the dashboard visualizes key business metrics such as sales, profit, order volume, and shipping performance across global regions.
- Understand regional sales and profitability trends.
- Analyze product category contributions to overall revenue.
- Evaluate shipping methods and order volumes.
- Create an interactive, shareable dashboard for business insights.
- Google Sheets – Data hosting and transformation
- Google Looker Studio – Data visualization and dashboard creation
- Excel – Initial data cleanup
- Western US and Central Asia are top-performing regions by sales.
- Copiers and Phones are the highest profit-generating sub-categories.
- Standard Class is the most frequently used shipping mode.
- Profit trends show a peak during the Q4 season each year.
- KPIs: Total Sales, Total Profit, Total Orders, Avg. Shipping Cost
- Interactive Filters: Region, Segment
- Charts Included:
- Sales by Region
- Profit by Sub-Category
- Sales by Category (Pie Chart)
- Profit Trends Over Time (Line Chart)
- Order Volume by Shipping Mode
- Name: Global Superstore 2016
- Format: Excel (.xlsx)
- Source: Kaggle – Global Superstore
Kanak Yadav
Aspiring Data Analyst | Passionate about BI tools, visualization, and storytelling through data.
📫 Reach out: LinkedIn | [yk.kanakyadav@gmail.com]