Power BI Desktop

Summary Sales And Budget 2016 Customer Notes

 Power BI Desktop
Units Sold Total Sales
Adventure Works Country  Sub Category 

91,321 29,307,837 All  All 

Summary Units Sold by Sub Category Total Sales by Country and Sub Category
Mountain Bikes Sub Category Helmets Mountain Bikes Road Bikes Tires and Tubes Touring Bikes
Tires and Tubes accounted for
8K (11.47%) Tires and Tubes 10M
37.68% of Units Sold. 26K (37.6…)
Helmets
Australia in Sub Category made 10K (14…)

Total Sales
up 17.40% of Total Sales.
5M

0M
Bottles and Ca…
United States Australia United Germany France Canada
12K (17.8%) Road Bikes Kingdom
13K (18.75%)
Country

Total Sales by Year, Quarter and Month Total Sales by Country

2.0M

1.5M
Total Sales

1.0M

0.5M

0.0M
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec

Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
2014 2015

Month ©
© 2023
2023 TomTom,
TomTom, ©
© 2023
2023 Microsoft
Microsoft Corporation,
Corporation, ©
© OpenStreetMap
OpenStreetMap
 Power BI Desktop
Total Sales Units Sold Total Budget Variance
Sales And Budget 2016
16,473,618 82,884 $16,869,574 ($395,956)

At $1,978,396, Dec had the highest Total Total Sales and Total Budget by Category Variance % by Month
Budget and was 130.49% higher than Feb,
Total Sales Total Budget
which had the lowest Total Budget at
$858,350. 0%

Total Budget and total Total Sales are Bikes

Variance %
positively correlated with each other.

Category
Accessories
Dec accounted for 11.73% of Total Budget.
-5%

Total Budget and Total Sales diverged the Clothing

most when the Month was Aug, when
Total Budget were $115,084.17 higher than 0M 5M 10M 15M 20M Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Total Sales. Total Sales and Total Budget Month

Variance % trended down, resulting in a

59.09% decrease between Total Budget and Total Sales by Month Group Units Sold Total Sales %GT Total Sales

Friday, January 1, 2016 and
Total Budget Total Sales  North America 40,699 6,572,762.17 39.90%
Thursday, December 1, 2016.
$2.0M  United States 29,830 5,483,882.67 33.29%
Variance % started trending down on  Canada 10,869 1,088,879.50 6.61%
Total Budget and Total Sales

Friday, January 1, 2016, falling by 59.09% (  Europe 25,039 5,517,376.34 33.49%

1058.41%) in 11 months.  United Kingdom 9,700 2,140,388.50 12.99%
 Germany 7,670 1,784,107.09 10.83%
Variance % dropped from 1791.09% to $1.5M
 France 7,669 1,592,880.75 9.67%
732.68% during its steepest decline Pacific 17,146 4,383,479.54 26.61%

between Friday, January 1, 2016 and
 Australia 17,146 4,383,479.54 26.61%
Thursday, December 1, 2016.
Total 82,884 16,473,618.05 100.00%
$1.0M

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Month
 Power BI Desktop
Total Sales by Gender Total Sales by Marital Status Total Sales by Age
Customer 14.52M 14.1…
4.45M
(15.18%) 11.48M
(49.54%) (48.…) (39.1…) Age (groups)
Gender MaritalStatus 5.… 50-60
(…)
At 9,887,500.13, Bachelors had the highest F M 60-70
Total Sales and was 505.78% higher than
M S under 50
Partial High School, which had the lowest Total
14.79M 15.16…
Sales at 1,632,189.92. 70+
(50.46%) (51.7…) 8.20M
(27.99%)
Bachelors accounted for 33.74% of Total Sales.

Under 50K had 10,535,223.41 Total Sales, Total Sales by Occupation Total Sales by Education
50K-130K had 16,803,741.59, and 130K + had 10M
2.85M (9.74%)
1,968,871.59. 9.89M (33.76%)
4.68M Occupation

Total Sales
(15.96%) Professional
50-60 in Sub Category made up 12.43% of 5M
Units Sold. Skilled Manual
Management
Clerical 0M
Bachelors Partial Graduate High School Partial High
5.46M (18.62%) Manual
College Degree School
6.43M (21.92%)
Education

Units Sold by Age and Sub Category Total Sales by Yearly Income
Sub Category Bottles a… Helmets Mountai… Road Bikes Tires and …

YearlyIncome (groups)
10K 50K-130K
Units Sold

Under 50K
5K

130K +

0K
50-60 60-70 under 50 70+ 0M 5M 10M 15M 20M
Age (groups) Total Sales
 Power BI Desktop

The dashboard reveals that North America has the highest total sales, followed by Australia. Within North America, the United States leads in sales.
The most popular subproducts in the United States are mountain bikes and road bikes.

Across all regions, the top-selling category is tires and tubes, accounting for 38% of total sales.
In 2016, the top three sales leaders were mountain bikes, road bikes, and touring bikes. November emerges as the month with the highest sales
volume.

The majority of buyers are woman, comprising 51% of the customer base. They primarily fall within the age of 50 to 60 years and have annual
income ranging from 50K to 130K.
It is noteworthy that customers with a bachelor's degree and professional occupation exhibit the highest total sales. On the other hand, customers
with a partial high school education level tend to have the lowest total sales.