Power BI Desktop Build a visual  

Visual types

AXON SALES DASHBOARD 

Orders Sales Profit YoY Growth Profit Margin Year  Month Product Line  Product Name 

151 $4.52M $1.81M 36.13% 40.07% 2004  All  All  All 

Total Sales by ProductLines Sales Trend by Month

$1.0M
0.34M (7.47%)
1.76M (39.04%)
Classic Cars
0.47M (10.31%)
Vintage Cars

Motorcycles

Planes
$0.5M
0.47M
(10.45%) Trucks and Buses

Ships Off Suggest a type

0.53M (11.68%) Trains
Data
$0.0M
0.85M (18.92%) Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
+Add data
Top 10 Countries by Sales Top 10 Countries by Units Sold Total 5 Customers by Sales Total 5 Products by Sales

USA $1.53M USA 17K

Euro+ Shop… 340.83K 1992 Ferrari … $120.38K
France $0.51M France 6K
Spain $0.44M Spain 5K
Mini Gifts Di… 231.56K 2001 Ferrari … $105.49K
UK $0.24M UK 3K
New Zealand $0.23M New Zealand 3K
Australian C… 127.16K 1952 Alpine … $88K
Australia $0.2M Australia 2K
Italy $0.18M Italy 2K
Land of Toys… 126.79K 2003 Harley-… $81.64K
Germany $0.13M Canada 2K

Japan $0.13M Japan 2K

Vida Sport, L… 108.78K 1980s Black … $80.08K
Canada $0.12M Germany 1K

$0M $1M $2M 0K 10K 20K 0K 200K 400K $0K $50K $100K
 Power BI Desktop Build a visual  

Visual types

SALES OVERVIEW Year Product Line Product Name 

2003 2004 2005 All  All 

Orders Sales Profit YoY Growth Profit Margin

151 $4.52M $1.81M 36.13% 40.07%

Present Year Sales and Last Year Sales by Month Total Sales by Credit Category Total 5 Products by Sales and Profit
Present Year Sales Last Year Sales $2.2M Total Sales Total Profit
$2.1M
$1.0M
$2M
1992 Ferrari 360 …

2001 Ferrari Enzo

$0.5M $1M 1952 Alpine Ren…



2003 Harley-Dav…
$0.2M
$0.0M Off Suggest a type
1980s Black Haw…
$0M
$0.0M Standard Premium Moderate Low
Data
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec $0K $100K
Credit Credit
+Add data
Total Sales, Total Cost Price and Total Profit % by Short Month Product Wise Sales Sales by Sales Representatives

Total Sales Total Cost Price Total Profit %

1992 Ferrari 36… $0.12M Gerard Hernandez 0.53M
$1.0M
2001 Ferrari En… $0.11M George Vanauf 0.43M
1952 Alpine Re… $0.09M Pamela Castillo 0.41M
70%
2003 Harley-D… $0.08M Barry Jones 0.39M
1980s Black Ha… $0.08M Peter Marsh 0.34M
1969 Ford Falc… $0.08M Steve Patterson 0.34M
$0.5M 1968 Ford Mus… $0.07M Leslie Jennings 0.33M
1998 Chrysler … $0.07M Larry Bott 0.32M
65%
2002 Suzuki XR… $0.06M Loui Bondur 0.31M
1962 LanciaA … $0.06M Foon Yue Tseng 0.24M
1957 Corvette … $0.06M Martin Gerard 0.21M
$0.0M
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec $0.0M $0.1M 0.0M 0.5M
 Power BI Desktop Build a visual  

Visual types

Order Details Year Product Line Product Name Cart Category


Order Status 

2003 2004 2005 All  All  All 

See details
Orders Units Sold Average Shipping
Days
326 106K 4 Fix this

Average Order Sales by ProductLine Orders Trend Month Order Status Overview

3.14K 2.93K (9.94%) Shipped 303

(10.66%) 0.58K Classic Cars 60

Count of orderNumber
(1.96%) Cancelled 6
Vintage Cars
3.4…
(1…) Motorcycles In Process 6
40
Trucks and Bus…
On Hold 4

Planes
Ships Resolved 4
20 Off Suggest a type
5.51K 11.82K Trains Disputed 3
(18.72%) (40.13%) Data
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 0 200
+Add data
Orders Recieved by Customers Order Quantity by orderNumber Sales by Cart Category
800
Euro+ Shopping Channel 26
Mini Gifts Distributors Ltd. 17 Very High $7.02M
Sum of Order Quantity

Australian Collectors, Co. 5 600

Danish Wholesale Imports 5
Down Under Souveniers,… High-Value $2.33M
5
400
Dragon Souveniers, Ltd. 5
Reims Collectables 5 Standard $0.19M
Anna's Decorations, Ltd 4
200
Baane Mini Imports 4
Blauer See Auto, Co. 4 Low-Value $0.07M

Corporate Gift Ideas Co. 4 0

10100 10150 10200 10250 10300 10350 10400 10450
0 10 20 orderNumber $0M $5M
 Power BI Desktop Build a visual  

Visual types

Customer Details 

Year Country Customer Name Credit Category

Customers Customers having Total Sales
No Sales
122 24 $9.6M 2003 2004 2005 All  All  All 

Total Sales by Customers Customer count by Country Sales by Country

3.3M
Euro+ Shoppin… $0.82M 3M
Mini Gifts Distr… $0.59M
Australian Coll… $0.18M 2M
Muscle Machin… $0.18M
1.1M 
La Rochelle Gifts $0.16M 1M 0.6M 0.4M
Dragon Souve… $0.16M 0.3M 0.3M 0.2M 0.2M 0.2M 0.1M
Down Under S… $0.15M 0M Off Suggest a type

Switzerland
USA
Spain
France
Australia
New Zeal…
UK
Italy
Finland
Norway
Singapore
Denmark
Canada
Germany
Austria
Sweden
Japan

Belgium
Land of Toys Inc. $0.15M
AV Stores, Co. $0.15M
Data

$0.0M $0.5M $1.0M ©

© 2024
2024 Microsoft
Microsoft Corporation
Corporation +Add data

Detailed Info Customer Count by Credit Category Customers count by Country

customerName Present Year Sa… Last Year Sales Sales Variance Sales Variance %
 USA 36
Euro+ Shopping Channel $290,018.52 $530,671.02 ($240,652.50) -45.35% Germ… 13
9 (7.…) 4 (3.28%)
France 12
Mini Gifts Distributors Ltd. $192,481.73 $399,345.61 ($206,863.88) -51.80% 24 Standard
(19.…) Spain 7
La Rochelle Gifts $91,147.11 $67,426.01 $23,721.10 35.18% Premium C…
Austr… 5
The Sharp Gifts Warehouse $83,984.89 $59,551.38 $24,433.51 41.03% No Credit UK 5
Down Under Souveniers, Inc $75,020.13 $79,601.95 ($4,581.82) -5.76% Moderate Italy 4
Anna's Decorations, Ltd $56,932.3 $80,101.92 ($23,169.62) -28.93% 60 New … 4
Low Credit
25 (49.1…)
Salzburg Collectables $52,420.07 $85,060 ($32,639.93) -38.37% Canada 3
(20.49%)
Finland 3
Gifts4AllAges.com $50,806.85 $33,533.47 $17,273.38 51.51%
Total $1,770,936.71 $7,833,253.9 ($6,062,317.19) -77.39% 0 20 40
 Power BI Desktop Build a visual  

Visual types


Product Details Year  productVendor  Product Line  Product Name 

Product Lines No. of Products No of Vendors Stock Quantity 2003  All  All  All 

7 110 13 555K
Vendor Wise Products Quantity Sold by Productlines Products Sold Quantity
1K
Classic Metal Creati… 10 1992 Ferrari 360 Sp… 0.67K
3K (7.8%) (2.74%)
Carousel DieCast L… 9 13K (35.02%) 1936 Mercedes-Be… 0.43K
4K
Exoto Designs 9 (10.52%) Classic Cars 1964 Mercedes Tou… 0.43K
Gearbox Collectibles 9 Vintage Cars 1940s Ford truck 0.41K
Highway 66 Mini Cl… 9 1926 Ford Fire Engi… 0.39K
Trucks and Buses 
Motor City Art Clas… 9 1956 Porsche 356A … 0.39K
Motorcycles
Autoart Studio Desi… 8 1948 Porsche Type … 0.38K
4K Planes
Min Lin Diecast 8 1965 Aston Martin … 0.38K
(11.06%) Off Suggest a type
Ships
Second Gear Diecast 8 1996 Peterbilt 379 … 0.37K
Trains
Studio M Art Models 8
4K (11.13%)
1950's Chicago Surf… 0.37K Data
Unimax Art Galleries 8 1968 Dodge Charger 0.37K
8K (21.72%) +Add data
0 5 10 0.0K 0.5K

Detailed Info Stock Availability by Productline

Classic Cars Vintage Cars Planes
productLine Present Year… Last Year Sales Sales Variance Sales Variance %


 Classic Cars $1,374,832.22 $1,374,832.22 No Last Year Sales

1992 Ferrari 360 Spider red $103,480.3 $103,480.30 No Last Year Sales
1952 Alpine Renault 1300 $67,985.34 $67,985.34 No Last Year Sales 62K

2001 Ferrari Enzo $59,852.24 $59,852.24 No Last Year Sales Trucks an… Ships

1969 Ford Falcon $57,403.47 $57,403.47 No Last Year Sales 125K

1968 Ford Mustang $56,462.25 $56,462.25 No Last Year Sales Motorcycles

1998 Chrysler Plymouth Pr $52 214 15 $52 214 15 No Last Year Sales
36K 27K
Total $3,317,348.39 $3,317,348.39 No Last Year
Sales Trains
219K 69K
 Power BI Desktop Build a visual  

Visual types

Payment Details Year  Short Month  customerName  

All  All  All 

No. of Payments Total Sales Total Payments Due Payments Average Payment

273 $9.6M 8.85M 750.35K 32.43K

Payments Trend by Year and Month
1.0M
0.86M
0.83M

0.69M
0.82M

0.48M
0.5M 0.40M 0.38M 0.39M 
0.32M
0.28M 0.27M
0.25M 0.23M 0.25M
0.20M 0.18M 0.21M
0.11M
0.14M 0.16M 0.06M Off Suggest a type
0.03M 0.19M 0.19M 0.18M
0.16M 0.16M 0.17M
0.14M 0.14M
0.0M Data
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
2003 2004 2005
+Add data

Total Payments Payments by Month Customer Payment dues

10M
Euro+ Shoppin… 716K 1.6M 8.9M Euro+ Shoppi… 105K
Mini Gifts Distri… 584K The Sharp Gift… 84K
1.6M
Australian Colle… 181K Salzburg Colle… 52K
Muscle Machin… 178K 0.5M Gifts4AllAges.… 51K
0.6M
Dragon Souven… 156K 5M 0.6M UK Collectabl… 45K
0.4M
Down Under S… 155K 0.4M Scandinavian … 44K
0.6M
AV Stores, Co. 148K 0.5M Tekni Collecta… 44K
1.0M
Anna's Decorati… 137K Souveniers An… 42K
0.5M
Corporate Gift I… 132K 0.4M La Rochelle Gi… 42K
Saveley & Henr… 130K 0M Land of Toys I… 41K
ar r y l t v c al
Jan Fe
b
M Ap Ma Ju
n Ju Aug Se
p
Oc No De Tot
0K 500K 0K 50K 100K
 Power BI Desktop Build a visual  

Visual types

Employee Details 

Employees Sales Total Sales Profit Country Sales Representative

Representatives
23 17 $9.6M $3.83M 2003 2004 2005
All  All 

Contribution Variance of Last Year and Present Year Sales Representatives Sales Representatives With No Sales
employeeNumber employeeName officeCode country
Present Year Sales Total Sales LY Sales Difference
1619 Tom King 6 Australia
Present Year Sales a…

1625 Yoshimi Kato 5 Japan

-50%

Sales Difference
Employee Count by Job Title
$0.5M

Sales Rep 17
President 1
Sale Manager (EMEA) 1 Off Suggest a type
$0.0M -100%
Sales Manager (APAC) 1
Andy Barry Foon George Gerard Julie Larry Leslie Leslie Loui Mami Martin Pamela Peter Steve Data
Fixter Jones Yue Vanauf Hern… Firrelli Bott Jenni… Thom… Bondur Nishi Gerard Castillo Marsh Patter… Sales Manager (NA) 1
Tseng
0 10 +Add data
employeeName
Total Sales by Employee Employee Count by Country Employess by Country

Gerard Hernandez $1.26M 2

Leslie Jennings $1.08M
2 country
Pamela Castillo $0.87M
USA
Larry Bott $0.73M
10 France
Barry Jones $0.7M
$0.67M 4 Australia
George Vanauf
Peter Marsh $0.58M Japan
Loui Bondur $0.57M UK
Andy Fixter $0.56M
5
$0M $1M ©
© 2024
2024 Microsoft
Microsoft Corporation
Corporation
 Power BI Desktop Build a visual  

Visual types


Employee Reports To

jobTitle × employeeNumber × employeeName × reportsTo ×

Sales Rep 1370 Gerard Hernandez

1188
1

1216
1
President
1 
1286
1
Sale Manager (EMEA)
1
1323 Off Suggest a type
1
Sales Manager (APAC)
1 Data
1337
1
Count of employeeN… Sales Manager (NA) +Add data
23 1
1370 Gerard Hernandez 1102
1 1 1
VP Marketing
1
1401
1
VP Sales
1
1501
1
Sales Rep
17
1504
1

1611
1


 Power BI Desktop Build a visual  

Visual types
Year Employee Name Country
Office Details All  All  All 


Employee Count by Office City, Country Offices by Country Count of Offices by Country
6
country USA Australia France Japan UK 3
3

6 2
5
2 4

2 2 2 2
1 1 1 1 
1
0
Sydney Paris Tokyo London Boston NYC San
Francis…
Off Suggest a type
0
Australia France Japan UK USA USA Australia France Japan UK
©
© 2024
2024 Microsoft
Microsoft Corporation
Corporation Data

Total Sales by Sales Representatives and their Office City and Country +Add data
$1.26M

$1.08M

$1.0M $0.87M
$0.70M $0.73M
$0.67M
$0.56M $0.58M $0.57M
$0.49M $0.51M
$0.46M
$0.5M $0.39M $0.39M $0.35M

$0.0M
Andy Fixter Peter Marsh Gerard Loui Bondur Martin Pamela Mami Nishi Barry Jones Larry Bott Foon Yue George Julie Firrelli Leslie Leslie Steve
Hernandez Gerard Castillo Tseng Vanauf Jennings Thompson Patterson
Sydney Paris Tokyo London NYC Boston San Francisco Boston
Australia France Japan UK USA
 Power BI Desktop Build a visual  

Visual types

Year  country  Product Name 

Top - Low Performances by All Categories 
All  All  All 

Top Sales by Sales Representatives Top Sales by Country Top Selling Products
Present Year Sales Last Year Sales Present Year Sales Last Year Sales Present Year Sales Last Year Sales

Gerard Hernandez USA 1992 Ferrari 36…

Leslie Jennings Spain 2003 Harley-Da…
Peter Marsh France 1952 Alpine Re…
Larry Bott New Zealand 1968 Ford Mus…
Pamela Castillo Australia 1956 Porsche 3…
Andy Fixter Finland 2002 Suzuki XR…

Steve Patterson Austria 1969 Dodge Ch…
Loui Bondur UK 1997 BMW R 1…
George Vanauf Italy 1917 Grand To…
Off Suggest a type
Leslie Thompson Japan 1972 Alfa Rom…

$0.0M $0.5M $1.0M

Data
$0M $2M $0.0M $0.2M

+Add data
Lowest Sales by Sales Representatives Lowest Sales by Country Lowest Selling Products
Present Year Sales Last Year Sales Present Year Sales Last Year Sales Present Year Sales Last Year Sales

Martin Gerard Germany 1936 Mercedes…

Barry Jones Hong Kong 1939 Chevrolet …
Foon Yue Tseng Ireland 1954 Greyhoun…
Julie Firrelli Norway 1982 Lamborg…
Mami Nishi Philippines 1938 Cadillac V…
Leslie Thompson Switzerland 1958 Chevy Cor…
George Vanauf Singapore 1939 Cadillac Li…
Loui Bondur Denmark 1950's Chicago …
Steve Patterson Belgium 1982 Ducati 99…

$0.0M $0.5M $1.0M $0M $2M $0.0M $0.2M

 Power BI Desktop Build a visual  

Visual types

Sales & Profit Prediction 

Total Sales Total Sales New Total Cost Price Total Cost Price New Total Profit Total Profit New Year 

$4.52M $4.06M $2.71M $2.57M $1.81M $1.94M 2004 

Sales Parameter  Total Sales and Total Sales New by Short Month
-10  Total Sales Total Sales New
$1.0M

$0.5M

Off Suggest a type

Data

$0.0M
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec +Add data

Cost Parameter 
Total Profit and Total Profit New by Short Month
-5  Total Profit Total Profit New

$0.4M

$0.2M

$0.0M
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
 Power BI Desktop Build a visual  

Visual types

Product Wise Influencer 

Key influencers Top segments  

What influences Sales to Increase  ?

When... ....the average of Sales

increases by  Sales is more likely to increase when productName is 2001
Ferrari Enzo than otherwise (on average).

productName is 2001
3.89K
Ferrari Enzo 8K 

productName is 1952
3.61K
Alpine Renault 1300 6K Off Suggest a type

Average of Sales
productName is 2003 Data
Harley-Davidson Eagle Drag 2.92K
4K
Bike +Add data
Average (excluding selected): 3170.57

productName is 1968 Ford

2.80K
Mustang 2K

productName is 1969 Ford

2.47K
Falcon 0K
2001 Ferrari Enzo
1952 Alpine Ren…
2003 Harley-Da…
1968 Ford Must…
1969 Ford Falcon
1917 Grand Tou…
1992 Ferrari 360…
1980s Black Ha…
1998 Chrysler Pl…
1956 Porsche 35…
1969 Corvair M…
1948 Porsche Ty…
productName is 1917 Grand
2.44K
Touring Sedan

productName is 1992
2.05K productName
Ferrari 360 Spider red
Only show values that are influencers