E-commerce data

a power BI report for two different department in E-commerce data in two interactive dashboards (sales performance and product performance)

with some

basic visuals:

KPI: Total sales, Total profit, units sold and shipping cost

Charts: line, donut, bar and column

Slicers: date, product and etc…

Specific visuals:

Top 10 Shipping Cost and profit by Product

Top 10 Average of Aging by Product

Insights:

First: mobile abb sales is very low

Second: the highest month in sales and profit is November and the lowest is February

Third: the most common payment method is with the credit card

Forth: the order priority is usually (medium)

Fifth: the most performed category is fashion and the least is electronics

Sixth: the highest shipping costs is T-shirt but has the highest sales

Seventh: the AVG aging of the apple laptops is high

Recommendation:

First: Launch a "Mobile-Exclusive" Revamp Program.

Second: Extend the November momentum and create urgency in February

Third: Encourage credit card use further while preparing for other methods

Forth: Optimize shipping and inventory for medium-priority efficiency.

Fifth: Double down on fashion and re-evaluate the electronics strategy.

Sixth:encourage larger order and Mitigate shipping costs and maximize the product's value for T-shirt

Seventh: Launch an aggressive inventory clearance campaign.