Analyzing Walmart Sales: Unveiling Key Insights and Trends

Introduction: In this blog post, we will delve into an analysis of Walmart's sales data to uncover valuable insights and identify significant trends. By examining the company's sales performance of 4 years, we aim to gain a deeper understanding of its growth, market positioning, and consumer behavior.

In 2012 The total sales in 2012 was $2.26M.

Sales by segment Sales are categorized by three segments namely Consumer, corporate and home office. Consumer segment made the most sale of $1.17M acquiring 51.94% of total ,Corporate made the sale of $0.69M acquiring 30.61% and Home office made the least sale of $0.39M acquiring 17.44%.

Sales by Market 5 major markets were targeted namely Asia, Europe,USA, Latam, Africa. Most sales were made in Asia of $713K (31.59%) followed by Europe with the sales of $540k (23.93%) ,USCA with the sales of $492.7k (21.81%) , Latam with the sales of $385.1k (17.04%) and lastly Africa made the least sales of $127k (5.63%).

Top 10 Customers The data showed top 10 customers out of which the top most customer Sanjit Chand Contributed 18.91% to profit Sarsah Sern being the least contributor of 7.05% to profit amongst the top customers. Top 6 products The top 6 products that made the most sales were - Ibico EPK-21 Cisco smart phone Nokia smartphone Cordless Samsung smart phone Nokia smartphone , Full size

Bottom 6 products The bottom 6 products that made the least sales were - Office star executive leather arm chair Cisco telepresence system Lexmark Printer GBC Docubind Hoover Stove

Average time for delivery (Days) : 4 Quantity Delivered : 31.44k No. of Returns : 1079

In 2013 The total sales in 2013 made was $2.68M.

Sales by segment Consumer segment saw an increase in sales and made sales of $1.46M acquiring 54.67%, Corporate made the sale of $0.77M acquiring 28.93% and Home Office made the sale of $0.44M acquiring 16.44% of the total sales%.

Sales by Market Sales increased in 2013 and Asia made the sale of $864K (32.27%) followed by Europe with the sales of $717k (26.8%%) ,USCA saw a decrease in the sales making $486.7k (18.81%) , Latam with the sales of 464.7k (17.63%) and lastly Africa made the least sales of $144k (5.4%).

Top 10 Customers The data showed top 10 customers out of which the top most customer Mike Gockenbach Contributed 15.50% to profit and Benjamin Patterson being the least contributor 6.86% to profit amongst the top customers.

.Top 6 products The top 6 products were - Fellows PB500 Electric Punch PLastic Comb Zebra ZM 400 Printer Samsung smart phone, Full size Nokia smartphone Samsung Smart Phone, Caller Id

Bottom 6 products Chromcraft Round table Hon round table Chromcraft Bullnose table Bevis Conference table Cubify CubeX Printer

Average time for delivery (Days) : 4 Quantity Delivered : 38.11k No. of Returns : 1079

In 2014 The total sales in 2014 was $3.41M.

Sales by segment Consumer segment made sales of $1.73M acquiring 50.77%, Corporate made the sale of $1.06M acquiring 31.27% and Home Office made the sale of $0.61M acquiring 17.96% of the total sales%.

Sales By Market Sales further increased in 2013 and Asia made the sale of $1.09M (32.07%) followed by Europe with the sales of $848k (24.92%) ,USCA made the sale of $627.7k (18.43%) , Latam with the sales of 608.7k (17.86%) and lastly Africa made the least sales of $144k (5.4%).

Top 10 customers The data showed top 10 customers out of which the top most customer Tamara Chand Contributed 21.58% to profit and Bill Shonely being the least contributor of 6.73% to profit amongst the top customers.

Top 6 Products Canon image CLASS 2200 Advanced Copier Motorola Smart Phone Full Size Harbour Creations Executive Leather Armchair Cisco Smart Phone Full Size Belkin Router USB

Bottom 6 Products Okidata Inkjet, Hoover Stove White Office Star Executive Leather Armchair Motorola Smartphone Cubify CubeX 3D Printer Double Head Print

Average time for delivery (Days) : 4 Quantity Delivered : 48.14k No. of Returns : 1079

In 2015 The total sales in 2015 was $4.3M.

Sales by segment Consumer segment saw a further increase in sales and made sales of $2.14M acquiring 49.8%, Corporate made the sale of $1.29M acquiring 30.08% and Home Office made the sale of $0.87M acquiring 20.12% of the total sales%.

Sales by Market Sales further increased in 2015 and Asia made the sale of $1.37M (31.93%) followed by Europe with the sales of $1.18M (27.45%) ,USCA made $757k (17.61%) , Latam with the sales of 706k (16.43%) and lastly Africa made the sales of $283k (6.58%).

Top 10 customers The data showed top 10 customers out of which the top most customer Raymond Buch Contributed 16.29% to profit and Alan Hwang being the least contributor of 6.86% to profit amongst the top customers.

Top 6 Products Canon imageCLASS 2200 Advanced Copier Cisco Smart Phone, Full Size Motorola Smartphone, Full Size Hoover Stove, Red Sauder Classic Bookcase, Traditional

Bottom 6 Products Bevis Computer Table, Fully Assembled Lexmark MX611dhe Monochrome Laser Printer Barricks Conference Table, Rectangular Ibico EPK-21 Electric Binding System Cubify CubeX 3D Printer Triple Head Print

Average time for delivery (Days) : 4 Quantity Delivered : 60.62k No. of Returns : 1079