Scribd
Upload
4 views1 page

Power BI Sales and Profit Analysis

The document provides a financial performance overview for various product sub-categories, detailing their quantity sold, revenue, and profit margins. The total sales for the year amount to 37,873 units with a total revenue of approximately $11.49 million and a profit of $286,397. The top-performing sub-categories include Phones and Copiers, while Bookcases and Supplies show negative profit margins.

Uploaded by

akunsebelah99
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views1 page

Power BI Sales and Profit Analysis

The document provides a financial performance overview for various product sub-categories, detailing their quantity sold, revenue, and profit margins. The total sales for the year amount to 37,873 units with a total revenue of approximately $11.49 million and a profit of $286,397. The top-performing sub-categories include Phones and Copiers, while Bookcases and Supplies show negative profit margins.

Uploaded by

akunsebelah99
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Contribution by Product Month  Year Power BI Desktop

3.28%
2.29%
15.77%
Sub-Category
Binders
All  All  Business Performance Dashboard
3.7% Paper
4.57%
Unit sales Top Month: Nov
13.67% Furnishings Total profit Top Month: Dec
37,873 5,775
6.22%
Phones 50K 286,397.02 43,369.19 5K

7.86% Storage

Quantity
9.41%

Profit
Art
7.92%
8.68%
8.34%

Financial Performance 0K 0K
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Month Month
Sub-Category Quantity Revenue Sum of Profit GPM (%)

Accessories 2,976 878922.52 41,936.64 4.77%
Sales by Area
Appliances 1,729 547368.45 18,138.01 3.31%
Art 3,000 136021.11 6,527.79 4.80%
Binders 5,974 1013454.13 30,221.76 2.98%
Bookcases 868 597826.12 -3,472.56 -0.58%
Chairs 2,356 1662757.97 26,590.17 1.60%
Copiers 234 657721.17 55,617.82 8.46%
Envelopes 906 74179.35 6,964.18 9.39%
Fasteners 914 17057.79 949.52 5.57%
Furnishings 3,563 454116.81 13,059.14 2.88%
Labels 1,400 70634.76 5,546.25 7.85%
Machines 440 914789.88 3,384.76 0.37%
Paper 5,178 389404.41 34,053.57 8.75%
Phones 3,289 1628827.96 44,515.73 2.73%
Storage 3,158 1099229.48 21,278.83 1.94%
Supplies 647 201235.83 -1,189.10 -0.59%
Tables 1,241 1144514.33 -17,725.48 -1.55%
Total 37,873 11488062.07 286,397.02 2.49%

You might also like