INF30004 BUSINESS INTELLIGENCE AND DATA VISUALISATION CONTINUOUS LEARNING ACTIVITIES #2 Task 1: Percentage of profit by region 7.94% Name: Thi Yen Nhi Tran ID: 102415004 Total profit by customer segment 23.69% 500K 400K 39.60% 300K Profit : Product Category (AII) Furniture Office Supplies Technology Region Central East West South Customer Segment 200K Consumer Corporate 100K Home Office Small Business OK Corporate Small Business Region Home Office Consumer 28.77% Total profit by product category/ sub-category Product Cat .. Product Sub-Category Furniture Office Supplies Chairs & Chairmats Office Furnishings Bookcases Tables Binders and Binder Acces. Appliances Envelopes Paper Labels Storage & Organization Pens & Art Supplies Scissors, Rulers and Trim .. Rubber Bands -72,495 165,349 92,209 -7,709 226,573 121,651 46,133 35,362 17,775 7,951 1,196 -1,937 | 2,842 | -100K -50K OK 50K 100K 150K 200K Total profit 250K 300K (Dashboard 1) (AII) Central East South West State or Province (AII) Alabama Arizona Arkansas California Colorado Connecticut Product Sub-Category Appliances Binders and Binder Access .. Bookcases Chairs & Chairmats Computer Peripherals 350K Copiers and Fax Envelopes v
Percentage of profit by region 7.94% Product Culegury (A1) Furniture DHice Supplies Technology Region Central 23.69% 39.60% West South 28.77% (Figure 1: Percentage of profit by region) Figure 1 pie chart shows that Superstore's profit generated from the central region is the highest (39.6%). The second and third highest rate of profit belonged to the east (28.77%) and west (23.69%) respectively. Meanwhile, the business performance in the South is extremely low, with only nearly 8% of the total profit and only 1/5 of the rate of the central area. Total profit by product category/ sub-category Product Cat .. Product Sub-Category ? Furniture Chairs & Charmats Office Furnishings Bookcases Tables Office Supplies Binclues and Binder Acces .. Appliances Envelopes Paper Labels Storage & Organization Pors & Art Supplies Scissors; Rulers and Trim .. Rubber Bands Technology Telephones and Communi .. Office Machines Copiers and Fax Computer Peripherals -72,495 -7,709 92,209 165,349 226,573 121,651 46,133 35,362 17,775 7,951 1,196 1,937 -2,842 100K 50K DR 168,073 179,157 87,918 50K 100K 150K 200K 250K 300K 297,951 350K Total profit F Region (All) Central Cast South West State or Province (AI) Alabama Arizona Arkansas California Calaradio Connecticut Delaware District of Colum ... Florida Gourgia Idaho Product Sub-Category Appliances Binders and Bind .. Bookcasos Chairs & Chaimats Computer Periph .. Copiers and Fax Envelopes Labels Office Furnishings Office Machines Paper (Figure 2: Total profit by product category/ sub-category) Looking at Figure 2, it can be recognized that the profit coming from the technology product portfolio is the highest (nearly $ 700k), of which telephones and communication are the most profitable product category outnumbering the rest. In contrast, Furniture is the category of products that are least profitable. Furthermore, the Tables business needs to be reconsidered when it generates a negative return value of around - $ 73k.
Total profit by customer segment 500K Customer Segment Consumer Corporate Home Office Small Business 450K 400K 350K 300K Profit 250K 200K 150K 100K 50K OK