Business Analysis & Visualization

Freelance Project

Description

This project analyzes the Superstore dataset to uncover insights across sales performance, shipping efficiency, regional trends and time-based growth.

Tools

Microsoft Excel

Microsoft Power BI

Using Excel and Power BI, I built four dashboards to explore key business questions:

1) Which products and categories are most profitable?
2) How do discounts affect profit margins? Which shipping modes and order priorities are cost-effective?
3)What are the seasonal and yearly trends in performance?
4)How do sales and profit vary by region and market?
These dashboards are designed to support strategic decisions, highlight inefficiencies, and drive performance improvements.

This dashboard shows the geographic distribution of sales and profits across regions and markets, with category-level breakdowns.

Insights:

Western Europe leads all regions in sales and profits.

Europe and USCA are the top markets, while Africa and Central Asia contribute the least.

Technology dominates across most markets.

The Asia Pacific market shows steady growth, a sign of emerging potential.

This dashboard analyzes sales and profit performance across years, categories and individual products, highlighting performance drivers and pricing impact.

Insights:

Technology leads in both sales and profit.

Canon imageCLASS 2200 is the top-performing product.

The scatter plot reveals that higher discounts don’t always lead to higher profits, in fact, deep discounts often reduce profit.

Tables generate strong sales but consistent losses.

This dashboard explores the impact of shipping cost on profit margins, broken down by shipping mode and order priority.

Insights:

Standard Class is the most used shipping mode and generates the most profit, even though it has the highest shipping cost.

Same Day shipping has the lowest profit, likely due to higher operational costs.

Medium priority orders generate the most profit, while Low priority orders barely contribute.

Total shipping profit falls over 30% below the goal.

This dashboard visualizes how sales and profit evolved over time, both overall and by product category.

Insights:

There is a clear increase in both sales and profits from 2012 to 2015, indicating business growth.

Technology consistently outperforms the other categories, especially in 2015.

Seasonal peaks and dips suggest recurring demand cycles, possibly tied to holidays or promotions.

Profit growth is less dramatic than sales growth, indicating tighter margins or rising costs.

Ifigeneia Tsiflidou