REPORT REPORT-1 REPORT-2 PRODUCT
PowerSALES
BI DesktopREPORT
Select a Subcategory
31.59M 358.95K 6 22 31.59M 5.26M
All
TotalSales Total-AvgSales UniqueCategory UniqueSubCategory TotSaleUniSubCat AvgSalesPerC…
Select a Year Select a Category
1.44M 2.27M 174.08 31.59M 88
All All AvgSalesPerSu… MaxSales MinSales TotalSalesUnCtg TotalTransaction
Sum of Sales and Totsales(allsel%) by Product Sub Category
14 MATRIX AND 11 KPI
TOP 5 PRODUCT
Sum of sales by Product CATEGORY
Category and Total sales (all selected %) TOP 5 PRODUCT SUBCATEGORY
Product Category 1 Sum of Total Sales Product Sub Category Sum of Total Sales
2
Computers 12,162,419.24 Camcorders 4,972,852.90
Cameras and camcorders 10,102,801.66 Projectors & Screens 4,145,050.32
TV and Video 4,823,734.62 Laptops 3,763,974.47
Cell phones 3,285,926.34 Digital SLR Cameras 3,503,777.56
Music, Movies and Audio Books 635,285.12 Home Theater System 2,470,355.42
Total 31,010,166.98 Total 18,856,010.67
Sum of sales by Product Category and Total sales (all selected %) 3 Product Category sales year wise 4
Product Category Sum of Sales Totsales(allsel%)
Product Category 4 Year Sum of Total Sales
Audio 577,270.33 1.83%
Audio 2011 3,568.50
Cameras and camcorders 10,102,801.66 31.98%
Audio 2012 129,640.25
Cell phones 3,285,926.34 10.40%
Audio 2013 225,604.89
Computers 12,162,419.24 38.50%
Audio 2014 218,456.69
Music, Movies and Audio Books 635,285.12 2.01%
Cameras and camcorders 2011 281,278.34
TV and Video 4,823,734.62 15.27%
Cameras and camcorders 2012 4,541,581.39
Total 31,587,437.31 100.00%
Cameras and camcorders 2013 2,984,862.12
Bottom 1 Product Sub Category Cameras and camcorders 2014 2,295,079.81
5
Cell phones 2011 72,260.47
Product Sub Category Sum of Total Sales
Cell phones 2012 1,322,206.41
VCD & DVD 108,348.99 Cell phones 2013 915,344.27
Total 108,348.99 Total 31,587,437.31
REPORT REPORT-1 REPORT-2 PRODUCT
PowerSALES
BI DesktopREPORT
PREVIOUS YEAR SALES REPORT 6 SALES YOY% GROWTH 7
Year Sum of Sales PreviousYearSales DATE Sum of Sales YoY % Growth
2011 737,139.83 Saturday, January 01, 2011 737,139.83
2012 11,949,468.18 737,139.83 Sunday, January 01, 2012 11,949,468.18 1521%
2013 9,838,662.18 11,949,468.18 Tuesday, January 01, 2013 9,838,662.18 -18%
2014 9,062,167.12 9,838,662.18 Wednesday, January 01, 2014 9,062,167.12 -8%
Total 31,587,437.31 22,525,270.19 Total 31,587,437.31
Product Sub Category Ranking 8 RUNNING TOTAL 9
Product Sub Category SubCatgRank Year Sum of Sales RunningTotal
Camcorders 1 2011 737,139.83 737,139.83
Projectors & Screens 2 2012 11,949,468.18 12,686,608.01
Laptops 3 2013 9,838,662.18 22,525,270.19
Digital SLR Cameras 4 2014 9,062,167.12 31,587,437.31
Home Theater System 5 Total 31,587,437.31 31,587,437.31
Desktops 6
Smart phones & PDAs 7 BOTTOM 1 PRODUCT CATEGORY SALES 10
Digital Cameras 8 Product Category Sum of Total Sales
Televisions 9
Audio 577,270.33
Total 1
Total 577,270.33
11
Product Category Ranking
Year wise sales Category Report 12
Product Category CatgRankSales
Product Category 2011 2012 2013 2014 Total
Computers 1
Audio 3,568.50 129,640.25 225,604.89 218,456.69 577,270.33
Cameras and camcorders 2
Cameras and 281,278.34 4,541,581.39 2,984,862.12 2,295,079.81 10,102,801.66
TV and Video 3
camcorders
Cell phones 4
Cell phones 72,260.47 1,322,206.41 915,344.27 976,115.19 3,285,926.34
Music, Movies and Audio 5
Computers 281,015.75 4,050,025.75 3,818,545.80 4,012,831.94 12,162,419.24
Books
Music, Movies and 17,857.15 264,904.00 225,645.99 126,877.98 635,285.12
Audio 6
Audio Books
Total 1
TV and Video 81,159.62 1,641,110.38 1,668,659.11 1,432,805.51 4,823,734.62
Total 737,139.83 11,949,468.18 9,838,662.18 9,062,167.12 31,587,437.31
REPORT REPORT-1 REPORT-2 PRODUCT
PowerSALES
BI DesktopREPORT
13
Year wise sales SUB Category Sales Report
Product Sub Category 2011 2012 2013 2014 Total
Bluetooth Headphones 174.08 11,731.62 62,495.73 78,394.05 152,795.48
Camcorders 31,082.31 2,269,971.66 1,521,023.21 1,150,775.72 4,972,852.90
Cameras & Camcorders Accessories 2,844.76 38,770.19 46,509.75 82,564.17 170,688.87
Car Video 38,166.04 409,704.51 362,407.20 255,601.73 1,065,879.48
Cell phones Accessories 3,601.54 78,133.15 77,065.73 309,571.48 468,371.90
Computers Accessories 3,505.08 75,288.13 125,632.69 155,510.75 359,936.65
Desktops 47,826.16 778,597.97 576,260.31 359,348.10 1,762,032.54
Digital Cameras 56,624.93 628,689.79 454,779.81 315,387.80 1,455,482.33
Digital SLR Cameras 190,726.34 1,604,149.75 962,549.35 746,352.12 3,503,777.56
Home & Office Phones 6,088.59 81,339.00 50,519.89 38,769.88 176,717.36
Home Theater System 36,183.81 976,258.16 866,328.39 591,585.06 2,470,355.42
Laptops 56,836.12 837,107.02 1,107,937.66 1,762,093.67 3,763,974.47
Monitors 3,501.96 253,469.92 393,728.02 440,290.31 1,090,990.21
Movie DVD 17,857.15 264,904.00 225,645.99 126,877.98 635,285.12
Total 737,139.83 11,949,468.18 9,838,662.18 9,062,167.12 31,587,437.31
Sum of Sales by Year and Product Category 14
Audio Cameras and camcorders Cell phones Computers Music, Movies and Audio Books TV and Video
15M
4.5M
10M 3.8M
4.0M
4.1M
3.0M
2.3M
5M
1.6M 1.7M 1.4M
1.3M
0M
2011 2012 2013 2014
2011 2012 2013 2014
Year
