E-COMMERCE DATA ANALYSIS(KMS SUPERSTORES)

Excel

This dataset contained data gathered over a period of 4 years (2009-2012). The total sales generated during this period was $14,915,600.

The total profit generated over the period of time was $1,521,768.

The technology product category generated the highest sales with $5,984,248 over this period, followed by Furniture with $5,178,590 and Office supplies with $3,752,762. I visualized this using a pie chart.

Concerning the regions, the West generated the highest sales valued at $3,597,549 while Nunavut generated the lowest sales valued at $116,376. I visualized this using a column bar chart.

Concerning the regions, Ontario generated the highest profit valued at $346,869 while Nunavut generated the lowest profit valued at $2,841. I visualized this using a column bar chart.

The shipping method that generated the highest costs was Delivery Truck with $51,972

followed by Regular Air with $48,008 and Express Air carrying the lowest costs with $7,850.91.

See the full data set and analysis here