I analyzed the sales of a Superstore in the United States over a period of four years. I summarized my findings in four reports in Power BI. I used four reports because I did not want to cram up a lot of information into one report. The reports are broken down as follows;
- Sales by category and sub-category
- Analysis of least profitable sub-categories
- Sales by geographical location
- Sales by product
- Sales by Category
- Analysis of least profitable Sub-categories
- Sales by Geographical location
- Sales by Product
KPIs:
- Sales - $2.3M
- Profit - $286.4k
- Discounts - $1.6K
- Orders - 38K
Technology with total sales of $836K was the highest category in sales followed by Furniture with $742K and lastly, Office Supplies with $719K sales.
Despite making the most sales, Technology had the least orders with a total order of 7K while Office Supplies with the least sales had the most orders totalling 23K. Furniture had 8K orders.
Of the 286.4K profit the Superstore realized, Technology accounted for 50.79% with a profit of $145.5K. Office Supplies accounted for 42.77% with a profit of $122.5K. Furniture, the least profitable category with a profit of $18.5K accounted for 6.44% of total profit.
Over the 4 years, the sub-category that made the most sales was Phones from the Technology category. Phones made sales amounting to $330K.
The second sub-category with the most sales was Chairs from the Furniture category. Chairs made sales of $328K.
The third highest sub-category in terms of sales was Storage from the Office Supplies category. It made $224K in sales.
From the line chart, it is evident sales took a dip in 2014. However in the same year, profit and orders increased by 24% and 5.2% respectively.
Even though the above report is static, the original report is interactive.
A video demonstrating how interactive the report is can be found on Twitter.
The following images depict the breakdown of the report above by year.
KPIs:
- Sales - $484.2K
- Profit - $49.5K
- Discount - $315.5
- Orders - 7581
Technology made the most sales followed by Furniture then Office Supplies.
Office Supplies accounted for 45.6% of total profit in 2013. Technology accounted for 43.38% and Furniture accounted for 11.02%.
Office Supplies had the most orders with 4.6K orders followed by Furniture and Technology with 1.6K and 1.4K orders respectively.
Phones, Chairs and Machines were the top 3 sub-categories in terms of sales.
The Superstore made the most sales in September with $81.8K sales.
KPIs:
- Sales - $470K (decrement of 2.9% from previous year)
- Profit - $61.6K (increment of 24.4% )
- Discount - $327.1 (increment of 3.8%)
- Orders - 7979 (increment of 5.2%)
Furniture made the most sales in 2014 followed by Technology and Office Supplies.
Technology accounted for 54.37% of total profit n 2014. Office Supplies and Furniture accounted for 40.73% and 4.89% respectively.
Office Supplies, the most ordered, had 4.7K orders. An increase of 100 from 2013.
Furniture had 1.8K orders. An increase of 200 from 2013.
Technology had 1.5K orders which is an increase of 100 from 2013.
Chairs, Phones and Storage were the top 3 sub-categories in terms of sales.
The most sales was recorded in November with $76K sales.
KPIs:
- Sales - $608.5K (increment of 29.5%)
- Profit - $81.7K (increment of 32.7%)
- Discount - $399.1 (increment of 22%)
- Orders - 9810 (increment of 23%)
Technology made the most sales in 2015. It made a total of $226K sales which is an increase of 38.7% from 2014.
Furniture made sales amounting to $119K which is an increase of 16.4% from 2014.
Office Supplies made the least sales with its total sales amounting to $184K. However, this was an increase of 34.3% from 2014.
Technology accounted for 48.64% of total profit followed by Office Supplies which accounted for 42.84%. Furniture accounted for 8.52% of total profit.
Office Supplies saw an increase of 25.5% increase in orders with total orders of 5922.
There was a 22.2% increase in orders in the Furniture category. The total order was 2192.
Techonolgy recorded a 13.3% increase in orders. Its total orders was 1695.
Chairs, Phones and Tables were the top 3 sub-categories by sales.
KPIs:
- Sales - $733.9K (increment of 20.6%)
- Profit - $93.5K (increment of 14.4%)
- Discount - $519.4 (increment of 30.1%)
- Orders - 13K (increment of 32.5%)
Technology had the most sales in 2016 followed by Office Supplies then Furniture.
Technology accounted for 54.2% of total profit. Office Supplies and Furniture accounted for 42.5% and 3.23% respectively.
There was a 30% increase in orders for Office Supplies taking the total orders of Office Supplies in 2016 to 7.7K. Furniture recorded an 11% increase in orders with total orders of 2.4K. Technology also recorded a 39.6% increase in profit with total orders of 2.4K.
Of the sub-categories, Phones had the most sales with $106K followed by Chairs and Binders.
The highest sales in a month was recorded in November.
Tables were the least profitable sub-category. Followed by Bookcases, Supplies, Fasteners and Machines. Tables, Bookcases and Supplies recorded losses over the four year period.
A break down of the profits for these categories can be found in the text box under the line charts in the graphs above.
California, New York and Texas were the top 3 states in terms of sales whiles Maine, West Virgina and North Dakota were the bottom 3.
The ribbon chart used in the report above visualizes the sales for all four regions over the four year period.
The West region with total sales of $725.5K was the region with the most sales.
The reports below represent a breakdown the report above.
- Sales - $501.2K
- Profit - $39.7K
- Discount - $558.3
- Orders - 8780
- Texas
- Illinois
- Michigan
- Kansas
- South Dakota
- North Dakota
- Houston
- Chicago
- Detroit
- Sales - $678.8K
- Profit - $91.5K
- Discount - $414
- Orders - 11k
- New York
- Pensylvannia
- Ohio
- District of Columbia
- Maine
- West Virginia
- New York City
- Philadelphia
- Newark
- Sales - $391.7K
- Profit - $46.7K
- Discounts - $238.6
- Orders - 6209
- Florida
- Virginia
- North Carolina
- Missisipi
- Louisiana
- South Carolina
- Jacksonville
- Atlanta
- Springfield
- Sales - $725.5K
- Profit - $108.4K
- Discounts - $350.2
- Orders - 12K
- California
- Washington
- Arizona
- New Mexico
- Idaho
- Wyoming
- Los Angeles
- Seattle
- San Francisco
The product that amaassed the most sales is the Canon imageCLASS 2200 Advanced Copier and the most ordered product was Staples.
Eureka Disposable Bags for Sanitaire Vibra Groomer I Upright Vac was the product with the least sales.
