Power BI Desktop
$24.9M REVENUE
$10.5M PROFIT
25.2KORDERS
2.2%
RETURN RATE
Revenue Trending Orders by Category
$2.0M
Accessories 17.0K
$1.5M Bikes 13.9K
Clothing 7.0K
$1.0M
Top 10 Products Orders Revenue Return %
Water Bottle - 30 oz. 3983 $39,755 1.95%
$0.5M
Patch Kit/8 Patches 2952 $13,506 1.61%
Mountain Tire Tube 2846 $28,333 1.64%
Road Tire Tube 2173 $17,265 1.55%
$0.0M Sport-100 Helmet, Red 2099 $73,444 3.33%
Jan 2020 Jul 2020 Jan 2021 Jul 2021 Jan 2022 AWC Logo Cap 2062 $35,865 1.11%
Sport-100 Helmet, Blue 1995 $67,112 3.31%
Fender Set - Mountain 1975 $87,041 1.36%
Sport-100 Helmet, Black 1940 $65,262 2.68%
Monthly Revenue Monthly Orders Monthly Returns Mountain Bottle Cage 1896 $38,062 2.02%
$1.83M
2146
166 Most Ordered Product Type: Most Returned Product Type:
Prev Month: $1.77M Prev Month: 2,165 Prev Month: 169 Tires and Tubes Shorts
Power BI Desktop
Select all Europe North America Pacific
Canada
United Kingdom
France
United States
Germany
Australia
©
© 2023
2023 Microsoft
Microsoft Corporation
Corporation
Power BI Desktop
Selected Product: Monthly Orders vs Target Monthly Revenue vs Target Monthly Profit vs Target
Water Bottle -
30 oz. 404 $4,067 $2,543
0 438 $0 $4,292 $0 $2,684
Price Adjustment(%) Total Profit Adjusted Profit
0.00
$500
$0
Jul 2021 Sep 2021 Nov 2021 Jan 2022 Mar 2022 May 2022
Product Metric Selection
8% Report Summary
Revenue Total Orders for
Profit 6% Water Bottle - 30 oz.were 404
Orders
Total Profit (380.77% increase) and
4%
Returns Adjusted Profit (380.77% increase)
both trended up between
Return % 2% Sunday, June 27, 2021 and
Sunday, June 26, 2022.
0%
Jul 2021 Sep 2021 Nov 2021 Jan 2022 Mar 2022 May 2022
Across all metrics, Total Profit had
the most interesting recent trend
Power BI Desktop
17.4K
Total Customers Revenue per Customer
$4K
UNIQUE CUSTOMERS
$2K
$1.4K
REVENUE PER CUSTOMER
$0K
Jan 2020 Jul 2020 Jan 2021 Jul 2021 Jan 2022
Orders by Income Level Top 100 Customers 2020 2022
CustomerKey FullName Orders Revenue
High 2.8K
Average
11.6K 11433 Mr. Maurice Shan 6 $12,408
11439 Mrs. Janet Munoz 6 $12,015 Top Customer(by Revenue):
11241 Mrs. Lisa Cai 7 $11,330
Mr. Maurice Shan
11417 Mrs. Lacey Zheng 7 $11,086
11420 Mr. Jordan Turner 7 $11,022
11242 Mr. Larry Munoz 7 $10,852
Low 10.3K 13263 Mrs. Kate Anand 4 $10,437
Orders: Revenue:
12655 Mr. Larry Vazquez 4 $10,395
6 $12.4K
11425 Mrs. Ariana Gray 6 $10,391
Orders by Occupation
12631 Mr. Clarence Gao 4 $10,332
Management 12650 Mr. Aaron Wright 4 $10,329
4.4K Professional
7.9K 13405 Mr. Ethan Bryant 4 $10,309
11429 Mr. Marco Lopez 6 $10,290
12632 Mrs. Bonnie Nath 4 $10,283 Among Customers in Skilled Manual roles in 2022, Ruben Suarez
11245 Mr. Ricky Vazquez 4 $10,166 drove the most revenue as $4,683
11237 Mr. Clarence Anand 4 $10,065
11428 Mrs. Deanna Perez 4 $9,762
Skilled Manual 11427 Mrs. Desiree Dominguez 4 $9,718
6.0K Total 1272 $6,15,328