Question: You have been given a report from the CRM system used by Sophia's Software, Inc. Sophia's is a software-as-a-service company that licenses its software products

 You have been given a report from the CRM system usedby Sophia's Software, Inc. Sophia's is a software-as-a-service company that licenses itssoftware products to customers. Sophia's is trying to better understand its customerattrition (customers who do not review their subscriptions.) Custom Name SC ProductSubscription End Date Custom 132 Custom & Lustom 133 Customer 43 BannerAd Callin Banner Ad Trade Show Webste Referral Pine Pine Pine CherryCherry Wahut Sales Rep Man Pennypkes Costanza Morgan Costanza Pennypacker Senfeld Newman

You have been given a report from the CRM system used by Sophia's Software, Inc. Sophia's is a software-as-a-service company that licenses its software products to customers. Sophia's is trying to better understand its customer attrition (customers who do not review their subscriptions.) Custom Name SC Product Subscription End Date Custom 132 Custom & Lustom 133 Customer 43 Banner Ad Callin Banner Ad Trade Show Webste Referral Pine Pine Pine Cherry Cherry Wahut Sales Rep Man Pennypkes Costanza Morgan Costanza Pennypacker Senfeld Newman Costanza Morgan Seinfeld Drake Costanza Location Industry Vermont Ute Scences New Hampshire Technology Maine Financial Services Vermont Technology Massachusetts Technology Connecticut Technology Subscription Start Date 5/8/2017 SA1/2012 11/23 2012 9/16/2012 SA 2/2012 3/7/2017 30,000 53 800 31.100 51.700 50.900 18,700 3/17/2018 If a customer has a subscription end date, the customer has attritted (or not renewed its subscription). If the customer does not have a subscription end date, the customer is active and has renewed its subscription. In the table above, Customer 62 is active; whereas Customer 43 has attritted. In addition the information from Sophia's CRM system, the Company also categorizes its customers by annual revenue range as follows: Pricing Tier Tier 1 Tier 2 Tier 3 Tier 4 Annual Revenue Range $ to $ 10,000 $ 10,000 to $ 20,000 $ 20,000 to $ 30,000 $ 30,000 to $ 40,000 $ 40,000 to $ 60,000 | | Tier 5 Your assignment is to seek insights regrading Sophia's customer attrition by creating and analyzing pivot tables. Create as many pivot table analyses as you deem necessary to help you understand customer attrition. Customer Name Customer 62 Customer 79 Pine Customer 132 Customer 8 Customer 133 Customer 43 Customer 40 Customer 87 Customer 127 Customer 61 Customer 124 Customer 37 Customer 34 Customer 25 Customer 101 Customer 89 Customer 78 Sales Source Product Sales Rep Location Industry Manager Banner Ad Pine Pennypacker Costanza Vermont Life Sciences Call in Morgan Costanza New Hampshire Technology Banner Ad Pine Pennypacker Seinfeld Maine Financial Services Trade Show Cherry Newman Costanza Vermont Technology Website Cherry Morgan Seinfeld Massachusetts Technology Referral Walnut Drake Costanza Connecticut Technology Call in Walnut Wilhelm Costanza Connecticut Manufacturing Other Redwood Wilhelm Kramer Connecticut Financial Services Website Cherry Morgan Seinfeld New Hampshire Durable Goods Call in Cherry Newman Benes Massachusetts Financial Services Referral Cherry Pennypacker Seinfeld Maine Life Sciences Referral Spruce Newman Costanza Maine Manufacturing Website Walnut Wilhelm Kramer New Hampshire Durable Goods Trade Show Pine Drake Costanza Maine Technology Banner Ad Cherry Drake Kramer Connecticut Manufacturing Other Cherry Wilhelm Benes Massachusetts Manufacturing Trade Show Redwood Pennypacker Seinfeld New Hampshire Financial Services Website Redwood Morgan Costanza Vermont Financial Services Website Birch Jarmel Rhode Island Life Sciences Banner Ad Redwood Morgan Kramer Maine Financial Services Banner Ad Pine Newman Kramer New Hampshire Financial Services Call in Redwood Morgan Benes Vermont Technology Other Walnut Morgan Costanza Maine Life Sciences Banner Ad Pine Wilhelm Costanza New Hampshire Retail Subscription Subscription Annual Start Date End Date Amount 5/8/2017 30,000 5/11/2017 53,800 11/23/2017 31,100 9/16/2017 51,700 5/12/2017 50,900 3/17/2017 3/17/2018 18,700 8/15/2017 50,900 11/10/2017 11/10/2018 20,200 7/16/2017 15,000 3/29/2017 3/29/2018 48,400 6/26/2017 51,400 1/18/2017 1/18/2018 13,500 6/29/2017 46,700 5/5/2017 5/5/2018 8,100 1/23/2017 35,000 8/17/2017 50,700 3/25/2017 26,500 10/15/2017 10/15/2018 25,500 5/26/2017 18,800 4/1/2017 27,800 12/19/2017 29,500 11/6/2017 11/6/2018 11,300 12/28/2017 41,400 2/17/2017 2/17/2018 22,400 Customer 67 Customer 74 Benes Customer 59 Customer 110 Customer 75 Customer 70 Customer 38 Customer 120 Customer 91 Customer 69 Customer 95 Customer 11 Customer 109 Customer 103 Customer 26 Customer 86 Customer 51 Customer 105 Customer 122 Customer 36 Customer 56 Customer 85 Customer 134 Customer 102 Customer 82 Customer 71 Customer 135 Customer 47 Customer 33 Customer 4 Customer 65 Customer 13 Customer 123 Other Redwood Morgan Seinfeld New Hampshire Manufacturing Referral Redwood Newman Benes Vermont Retail Website Cherry Pennypacker Kramer Maine Manufacturing Call in Spruce Pennypacker Benes Massachusetts Life Sciences Website Pine Jarmel Costanza Vermont Manufacturing Banner Ad Cherry Pennypacker Kramer Rhode Island Life Sciences Referral Walnut Jarmel Seinfeld Massachusetts Financial Services Referral Birch Morgan Kramer Massachusetts Durable Goods Trade Show Redwood Drake Benes Connecticut Retail Referral Cherry Jarmel Kramer Vermont Manufacturing Banner Ad Birch Jarmel Costanza Rhode Island Technology Other Redwood Jarmel Costanza Connecticut Financial Services Call in Birch Newman Benes Rhode Island Financial Services Other Spruce Newman Kramer Connecticut Manufacturing Website Cherry Jarmel Seinfeld Massachusetts Financial Services Call in Cherry Newman Kramer Vermont Financial Services Other Spruce Pennypacker Benes Connecticut Technology Other Cherry Morgan Costanza Maine Manufacturing Redwood Jarmel Costanza Maine Life Sciences Website Cherry Wilhelm Kramer Maine Technology Trade Show Birch Jarmel Seinfeld Vermont Financial Services Trade Show Redwood Jarmel Costanza Vermont Retail Trade Show Pine Newman Costanza Connecticut Financial Services Other Redwood Wilhelm Costanza Vermont Financial Services Referral Spruce Drake Kramer New Hampshire Technology Trade Show Cherry Jarmel Seinfeld Maine Life Sciences 6/22/2017 6/22/2018 27,200 9/19/2017 9/19/2018 29,300 7/17/2017 46,000 11/22/2017 11/22/2018 28,300 4/15/2017 4/15/2018 47,600 6/18/2017 39,600 9/19/2017 9/19/2018 13,100 4/20/2017 31,800 10/31/2017 37,300 11/12/2017 55,700 5/17/2017 5/17/2018 42,900 4/22/2017 49,500 9/24/2017 52,700 8/1/2017 47,800 9/10/2017) 47,000 10/27/2017 52,900 8/8/2017 8/8/2018 27,000 1/12/2017 38,600 7/6/2017 48,100 12/14/2017 12/14/2018 36,800 3/4/2017 3/4/2018 14,100 4/24/2017 51,000 12/19/2017 53,700 5/14/2017 31,800 1/16/2017 42,400 4/20/2017 16,900 Other Customer 21 Customer 2 Customer 52 Customer 24 Customer 64 Customer 97 Customer 48 Customer 46 Customer 112 Customer 73 Customer 116 Customer 39 Customer 130 Customer 44 Customer 125 Customer 119 Customer 20 Customer 126 Other Pine Newman Benes New Hampshire Life Sciences Banner Ad Redwood Drake Kramer Vermont Financial Services Referral Pine Morgan Kramer Vermont Financial Services Banner Ad Birch Pennypacker Kramer Rhode Island Life Sciences Banner Ad Birch Morgan Costanza Massachusetts Manufacturing Website Redwood Newman Kramer Maine Financial Services Call in Birch Drake Seinfeld New Hampshire Manufacturing Website Walnut Wilhelm Seinfeld Massachusetts Life Sciences Other Birch Morgan Kramer Massachusetts Financial Services Referral Birch Jarmel Costanza Rhode Island Technology Website Cherry Pennypacker Seinfeld Vermont Durable Goods Trade Show Cherry Pennypacker Seinfeld Vermont Manufacturing Other Cherry Pennypacker Kramer Rhode Island Technology Referral Pine Drake Kramer Maine Financial Services Call in Birch Morgan Costanza Rhode Island Retail Banner Ad Cherry Morgan Benes Connecticut Life Sciences Website Walnut Drake Seinfeld Rhode Island Durable Goods Referral Redwood Wilhelm Kramer Vermont Manufacturing Referral Walnut Drake Kramer Maine Retail Other Walnut Newman Benes New Hampshire Financial Services Banner Ad Pine Pennypacker Benes Massachusetts Technology Banner Ad Spruce Newman Costanza Rhode Island Retail Trade Show Redwood Drake Seinfeld Maine Manufacturing Trade Show Redwood Wilhelm Costanza Rhode Island Retail Website Spruce Newman Kramer Maine Retail Other Walnut Newman Seinfeld Massachusetts Manufacturing 4/8/2017 51,900 12/17/2017 48,200 1/9/2017 1/8/2018 9,100 11/7/2017 11/7/2018 41,800 1/30/2017 53,500 1/23/2017 1/23/2018 15,500 9/26/2017 53,400 11/25/2017) 21,700 10/4/2017 35,400 11/25/2017) 43,200 4/6/2017 4/5/2018 27,800 10/2/2017 48,400 7/4/2017 40,100 1/24/2017 1/24/2018 14,200 11/6/2017 48,400 2/2/2017 2/2/2018 17,600 6/16/2017 15,000 7/17/2017 35,000 9/9/2017 26,800 10/22/2017 51,900 9/7/2017 58,300 4/15/2017 36,300 12/27/2017 12/27/2018 16,800 5/21/2017 34,000 11/1/2017 11/1/2018 13,500 3/24/2017 3/24/2018 53,100 Customer 99 Customer 121 Customer 32 Customer 80 Customer 53 Customer 106 Customer 49 Customer 68 Customer 96 Customer 92 8/13/2017 4/30/2017 1/29/2017 Customer 98 Customer 41 Customer 23 Customer 104 Customer 118 Customer 29 Customer 30 Customer 18 Customer 63 Customer 111 Customer 115 Customer 128 Customer 117 Customer 100 Customer 107 Customer 5 Other Birch Newman Benes Maine Life Sciences Call in Redwood Morgan Benes Rhode Island Life Sciences Banner Ad Spruce Newman Benes Connecticut Retail Website Cherry Jarmel Costanza New Hampshire Financial Services Website Cherry Jarmel Benes New Hampshire Life Sciences Referral Cherry Drake Seinfeld Maine Technology Banner Ad Birch Drake Costanza Vermont Technology Other Cherry Pennypacker Kramer Vermont Technology Trade Show Pine Newman Costanza Vermont Manufacturing Website Birch Morgan Benes Connecticut Retail Referral Redwood Morgan Seinfeld Massachusetts Life Sciences Other Spruce Drake Kramer Rhode Island Technology Trade Show Pine Drake Costanza Rhode Island Technology Other Cherry Pennypacker Kramer New Hampshire Retail Website Redwood Drake Kramer Massachusetts Manufacturing Trade Show Redwood Jarmel Benes Massachusetts Technology Other Redwood Morgan Seinfeld Massachusetts Financial Services Website Cherry Drake Costanza Connecticut Manufacturing Banner Ad Redwood Drake Costanza Rhode Island Technology Website Pine Newman Benes New Hampshire Durable Goods Referral Cherry Pennypacker Costanza Connecticut Retail Banner Ad Birch Jarmel Costanza New Hampshire Technology Banner Ad Spruce Newman Benes Vermont Technology Banner Ad Cherry Newman Costanza Massachusetts Retail Banner Ad Pine Pennypacker Seinfeld Connecticut Financial Services Call in Spruce Jarmel Costanza Maine Manufacturing 10/14/2017 2/13/2017 8/12/2017 3/6/2017 2/11/2017 5/18/2017 11/22/2017 11/23/2017 5/18/2017 1/25/2017 2/15/2017 11/25/2017) 11/6/2017 7/18/2017 8/14/2017 12/29/2017 12/29/2017 12/3/2017 2/25/2017 3/4/2017 2/6/2017 3/8/2017 9/26/2017 32,800 28,900 1/29/2018 13,800 54,500 2/13/2018 32,700 51,300 51,800 53,400 5/18/2018 25,600 56,100 31,500 5/18/2018 48,300 46,500 25,600 11/25/2018 22,500 34,300 23,400 52,000 51,000 51,000 52,600 2/25/2018 21,000 54,900 30,100 50,500 44,900 Customer 1 Customer 9 Customer 54 Customer 88 Customer 83 Customer 35 Customer 84 Customer 113 Customer 31 Customer 129 Customer 76 Customer 14 Customer 58 Customer 22 Customer 10 Customer 57 Customer 66 Customer 94 Customer 77 Customer 60 Customer 72 Customer 3 Other Cherry Drake Costanza New Hampshire Life Sciences Website Birch Jarmel Kramer Rhode Island Life Sciences Banner Ad Redwood Morgan Kramer Connecticut Financial Services Referral Pine Morgan Benes Vermont Technology Website Spruce Newman Costanza Massachusetts Life Sciences Referral Cherry Morgan Seinfeld Vermont Technology Trade Show Walnut Newman Seinfeld Vermont Life Sciences Trade Show Redwood Jarmel Kramer New Hampshire Retail Referral Redwood Morgan Benes Massachusetts Technology Trade Show Cherry Wilhelm Kramer Connecticut Technology Website Walnut Jarmel Benes Connecticut Technology Trade Show Birch Newman Benes Maine Durable Goods Other Birch Morgan Costanza Connecticut Technology Banner Ad Redwood Wilhelm Benes Connecticut Retail Referral Cherry Morgan Kramer New Hampshire Financial Services Trade Show Cherry Wilhelm Kramer Rhode Island Life Sciences Other Cherry Drake Kramer Connecticut Retail Banner Ad Cherry Pennypacker Costanza Rhode Island Retail Website Spruce Jarmel Seinfeld New Hampshire Financial Services Call in Pine Drake Seinfeld Rhode Island Financial Services Call in Pine Jarmel Costanza Connecticut Retail Website Walnut Newman Seinfeld Rhode Island Manufacturing Website Redwood Wilhelm Seinfeld Maine Financial Services Other Redwood Morgan Costanza New Hampshire Life Sciences Referral Spruce Morgan Kramer Massachusetts Manufacturing Referral Birch Wilhelm Seinfeld Maine Financial Services 4/22/2017 5/3/2017 12/18/2017 5/13/2017 5/5/2017 2/12/2017 9/15/2017 8/19/2017 1/29/2017 10/23/2017 8/23/2017 8/8/2017 11/21/2017) 8/11/2017 1/9/2017 7/22/2017 4/4/2017 10/4/2017 4/12/2017 8/11/2017 3/29/2017 4/23/2017 10/20/2017 11/1/2017 8/18/2017 3/16/2017 4/22/2018 36,100 37,900 12/18/2018 47,800 53,000 50,000 2/12/2018 18,800 52,200 8/19/2018 19,900 36,400 10/23/2018 13,300 31,100 8/8/2018 31,500 25,800 40,000 1/9/2018 7,700 42,000 46,100 10/4/2018 37,600 42,900 25,900 3/29/2018 14,000 4/23/2018 11,600 45,200 11/1/2018 17,300 41,500 3/16/2018 13,100 Customer 93 Customer 114 Customer 6 Customer 17 Customer 7 Customer 108 Customer 50 Customer 15 Customer 55 Customer 19 Customer 90 Customer 16 Customer 81 Customer 45 Customer 131 Customer 42 Customer 28 Customer 27 Customer 12 Website Redwood Newman Benes New Hampshire Financial Services Banner Ad Redwood Drake Kramer Maine Financial Services Other Cherry Morgan Benes Rhode Island Durable Goods Other Redwood Drake Seinfeld Rhode Island Life Sciences Other Pine Newman Kramer Rhode Island Manufacturing Other Spruce Pennypacker Kramer Rhode Island Retail Trade Show Walnut Pennypacker Costanza Maine Financial Services 2/21/2017| 4/10/2017 8/12/2017 1/13/2017) 9/20/2017 2/3/2017) 10/16/2017 46,600 48,500 35,900 23,800 40,500 25,500 29,400 You have been given a report from the CRM system used by Sophia's Software, Inc. Sophia's is a software-as-a-service company that licenses its software products to customers. Sophia's is trying to better understand its customer attrition (customers who do not review their subscriptions.) Custom Name SC Product Subscription End Date Custom 132 Custom & Lustom 133 Customer 43 Banner Ad Callin Banner Ad Trade Show Webste Referral Pine Pine Pine Cherry Cherry Wahut Sales Rep Man Pennypkes Costanza Morgan Costanza Pennypacker Senfeld Newman Costanza Morgan Seinfeld Drake Costanza Location Industry Vermont Ute Scences New Hampshire Technology Maine Financial Services Vermont Technology Massachusetts Technology Connecticut Technology Subscription Start Date 5/8/2017 SA1/2012 11/23 2012 9/16/2012 SA 2/2012 3/7/2017 30,000 53 800 31.100 51.700 50.900 18,700 3/17/2018 If a customer has a subscription end date, the customer has attritted (or not renewed its subscription). If the customer does not have a subscription end date, the customer is active and has renewed its subscription. In the table above, Customer 62 is active; whereas Customer 43 has attritted. In addition the information from Sophia's CRM system, the Company also categorizes its customers by annual revenue range as follows: Pricing Tier Tier 1 Tier 2 Tier 3 Tier 4 Annual Revenue Range $ to $ 10,000 $ 10,000 to $ 20,000 $ 20,000 to $ 30,000 $ 30,000 to $ 40,000 $ 40,000 to $ 60,000 | | Tier 5 Your assignment is to seek insights regrading Sophia's customer attrition by creating and analyzing pivot tables. Create as many pivot table analyses as you deem necessary to help you understand customer attrition. Customer Name Customer 62 Customer 79 Pine Customer 132 Customer 8 Customer 133 Customer 43 Customer 40 Customer 87 Customer 127 Customer 61 Customer 124 Customer 37 Customer 34 Customer 25 Customer 101 Customer 89 Customer 78 Sales Source Product Sales Rep Location Industry Manager Banner Ad Pine Pennypacker Costanza Vermont Life Sciences Call in Morgan Costanza New Hampshire Technology Banner Ad Pine Pennypacker Seinfeld Maine Financial Services Trade Show Cherry Newman Costanza Vermont Technology Website Cherry Morgan Seinfeld Massachusetts Technology Referral Walnut Drake Costanza Connecticut Technology Call in Walnut Wilhelm Costanza Connecticut Manufacturing Other Redwood Wilhelm Kramer Connecticut Financial Services Website Cherry Morgan Seinfeld New Hampshire Durable Goods Call in Cherry Newman Benes Massachusetts Financial Services Referral Cherry Pennypacker Seinfeld Maine Life Sciences Referral Spruce Newman Costanza Maine Manufacturing Website Walnut Wilhelm Kramer New Hampshire Durable Goods Trade Show Pine Drake Costanza Maine Technology Banner Ad Cherry Drake Kramer Connecticut Manufacturing Other Cherry Wilhelm Benes Massachusetts Manufacturing Trade Show Redwood Pennypacker Seinfeld New Hampshire Financial Services Website Redwood Morgan Costanza Vermont Financial Services Website Birch Jarmel Rhode Island Life Sciences Banner Ad Redwood Morgan Kramer Maine Financial Services Banner Ad Pine Newman Kramer New Hampshire Financial Services Call in Redwood Morgan Benes Vermont Technology Other Walnut Morgan Costanza Maine Life Sciences Banner Ad Pine Wilhelm Costanza New Hampshire Retail Subscription Subscription Annual Start Date End Date Amount 5/8/2017 30,000 5/11/2017 53,800 11/23/2017 31,100 9/16/2017 51,700 5/12/2017 50,900 3/17/2017 3/17/2018 18,700 8/15/2017 50,900 11/10/2017 11/10/2018 20,200 7/16/2017 15,000 3/29/2017 3/29/2018 48,400 6/26/2017 51,400 1/18/2017 1/18/2018 13,500 6/29/2017 46,700 5/5/2017 5/5/2018 8,100 1/23/2017 35,000 8/17/2017 50,700 3/25/2017 26,500 10/15/2017 10/15/2018 25,500 5/26/2017 18,800 4/1/2017 27,800 12/19/2017 29,500 11/6/2017 11/6/2018 11,300 12/28/2017 41,400 2/17/2017 2/17/2018 22,400 Customer 67 Customer 74 Benes Customer 59 Customer 110 Customer 75 Customer 70 Customer 38 Customer 120 Customer 91 Customer 69 Customer 95 Customer 11 Customer 109 Customer 103 Customer 26 Customer 86 Customer 51 Customer 105 Customer 122 Customer 36 Customer 56 Customer 85 Customer 134 Customer 102 Customer 82 Customer 71 Customer 135 Customer 47 Customer 33 Customer 4 Customer 65 Customer 13 Customer 123 Other Redwood Morgan Seinfeld New Hampshire Manufacturing Referral Redwood Newman Benes Vermont Retail Website Cherry Pennypacker Kramer Maine Manufacturing Call in Spruce Pennypacker Benes Massachusetts Life Sciences Website Pine Jarmel Costanza Vermont Manufacturing Banner Ad Cherry Pennypacker Kramer Rhode Island Life Sciences Referral Walnut Jarmel Seinfeld Massachusetts Financial Services Referral Birch Morgan Kramer Massachusetts Durable Goods Trade Show Redwood Drake Benes Connecticut Retail Referral Cherry Jarmel Kramer Vermont Manufacturing Banner Ad Birch Jarmel Costanza Rhode Island Technology Other Redwood Jarmel Costanza Connecticut Financial Services Call in Birch Newman Benes Rhode Island Financial Services Other Spruce Newman Kramer Connecticut Manufacturing Website Cherry Jarmel Seinfeld Massachusetts Financial Services Call in Cherry Newman Kramer Vermont Financial Services Other Spruce Pennypacker Benes Connecticut Technology Other Cherry Morgan Costanza Maine Manufacturing Redwood Jarmel Costanza Maine Life Sciences Website Cherry Wilhelm Kramer Maine Technology Trade Show Birch Jarmel Seinfeld Vermont Financial Services Trade Show Redwood Jarmel Costanza Vermont Retail Trade Show Pine Newman Costanza Connecticut Financial Services Other Redwood Wilhelm Costanza Vermont Financial Services Referral Spruce Drake Kramer New Hampshire Technology Trade Show Cherry Jarmel Seinfeld Maine Life Sciences 6/22/2017 6/22/2018 27,200 9/19/2017 9/19/2018 29,300 7/17/2017 46,000 11/22/2017 11/22/2018 28,300 4/15/2017 4/15/2018 47,600 6/18/2017 39,600 9/19/2017 9/19/2018 13,100 4/20/2017 31,800 10/31/2017 37,300 11/12/2017 55,700 5/17/2017 5/17/2018 42,900 4/22/2017 49,500 9/24/2017 52,700 8/1/2017 47,800 9/10/2017) 47,000 10/27/2017 52,900 8/8/2017 8/8/2018 27,000 1/12/2017 38,600 7/6/2017 48,100 12/14/2017 12/14/2018 36,800 3/4/2017 3/4/2018 14,100 4/24/2017 51,000 12/19/2017 53,700 5/14/2017 31,800 1/16/2017 42,400 4/20/2017 16,900 Other Customer 21 Customer 2 Customer 52 Customer 24 Customer 64 Customer 97 Customer 48 Customer 46 Customer 112 Customer 73 Customer 116 Customer 39 Customer 130 Customer 44 Customer 125 Customer 119 Customer 20 Customer 126 Other Pine Newman Benes New Hampshire Life Sciences Banner Ad Redwood Drake Kramer Vermont Financial Services Referral Pine Morgan Kramer Vermont Financial Services Banner Ad Birch Pennypacker Kramer Rhode Island Life Sciences Banner Ad Birch Morgan Costanza Massachusetts Manufacturing Website Redwood Newman Kramer Maine Financial Services Call in Birch Drake Seinfeld New Hampshire Manufacturing Website Walnut Wilhelm Seinfeld Massachusetts Life Sciences Other Birch Morgan Kramer Massachusetts Financial Services Referral Birch Jarmel Costanza Rhode Island Technology Website Cherry Pennypacker Seinfeld Vermont Durable Goods Trade Show Cherry Pennypacker Seinfeld Vermont Manufacturing Other Cherry Pennypacker Kramer Rhode Island Technology Referral Pine Drake Kramer Maine Financial Services Call in Birch Morgan Costanza Rhode Island Retail Banner Ad Cherry Morgan Benes Connecticut Life Sciences Website Walnut Drake Seinfeld Rhode Island Durable Goods Referral Redwood Wilhelm Kramer Vermont Manufacturing Referral Walnut Drake Kramer Maine Retail Other Walnut Newman Benes New Hampshire Financial Services Banner Ad Pine Pennypacker Benes Massachusetts Technology Banner Ad Spruce Newman Costanza Rhode Island Retail Trade Show Redwood Drake Seinfeld Maine Manufacturing Trade Show Redwood Wilhelm Costanza Rhode Island Retail Website Spruce Newman Kramer Maine Retail Other Walnut Newman Seinfeld Massachusetts Manufacturing 4/8/2017 51,900 12/17/2017 48,200 1/9/2017 1/8/2018 9,100 11/7/2017 11/7/2018 41,800 1/30/2017 53,500 1/23/2017 1/23/2018 15,500 9/26/2017 53,400 11/25/2017) 21,700 10/4/2017 35,400 11/25/2017) 43,200 4/6/2017 4/5/2018 27,800 10/2/2017 48,400 7/4/2017 40,100 1/24/2017 1/24/2018 14,200 11/6/2017 48,400 2/2/2017 2/2/2018 17,600 6/16/2017 15,000 7/17/2017 35,000 9/9/2017 26,800 10/22/2017 51,900 9/7/2017 58,300 4/15/2017 36,300 12/27/2017 12/27/2018 16,800 5/21/2017 34,000 11/1/2017 11/1/2018 13,500 3/24/2017 3/24/2018 53,100 Customer 99 Customer 121 Customer 32 Customer 80 Customer 53 Customer 106 Customer 49 Customer 68 Customer 96 Customer 92 8/13/2017 4/30/2017 1/29/2017 Customer 98 Customer 41 Customer 23 Customer 104 Customer 118 Customer 29 Customer 30 Customer 18 Customer 63 Customer 111 Customer 115 Customer 128 Customer 117 Customer 100 Customer 107 Customer 5 Other Birch Newman Benes Maine Life Sciences Call in Redwood Morgan Benes Rhode Island Life Sciences Banner Ad Spruce Newman Benes Connecticut Retail Website Cherry Jarmel Costanza New Hampshire Financial Services Website Cherry Jarmel Benes New Hampshire Life Sciences Referral Cherry Drake Seinfeld Maine Technology Banner Ad Birch Drake Costanza Vermont Technology Other Cherry Pennypacker Kramer Vermont Technology Trade Show Pine Newman Costanza Vermont Manufacturing Website Birch Morgan Benes Connecticut Retail Referral Redwood Morgan Seinfeld Massachusetts Life Sciences Other Spruce Drake Kramer Rhode Island Technology Trade Show Pine Drake Costanza Rhode Island Technology Other Cherry Pennypacker Kramer New Hampshire Retail Website Redwood Drake Kramer Massachusetts Manufacturing Trade Show Redwood Jarmel Benes Massachusetts Technology Other Redwood Morgan Seinfeld Massachusetts Financial Services Website Cherry Drake Costanza Connecticut Manufacturing Banner Ad Redwood Drake Costanza Rhode Island Technology Website Pine Newman Benes New Hampshire Durable Goods Referral Cherry Pennypacker Costanza Connecticut Retail Banner Ad Birch Jarmel Costanza New Hampshire Technology Banner Ad Spruce Newman Benes Vermont Technology Banner Ad Cherry Newman Costanza Massachusetts Retail Banner Ad Pine Pennypacker Seinfeld Connecticut Financial Services Call in Spruce Jarmel Costanza Maine Manufacturing 10/14/2017 2/13/2017 8/12/2017 3/6/2017 2/11/2017 5/18/2017 11/22/2017 11/23/2017 5/18/2017 1/25/2017 2/15/2017 11/25/2017) 11/6/2017 7/18/2017 8/14/2017 12/29/2017 12/29/2017 12/3/2017 2/25/2017 3/4/2017 2/6/2017 3/8/2017 9/26/2017 32,800 28,900 1/29/2018 13,800 54,500 2/13/2018 32,700 51,300 51,800 53,400 5/18/2018 25,600 56,100 31,500 5/18/2018 48,300 46,500 25,600 11/25/2018 22,500 34,300 23,400 52,000 51,000 51,000 52,600 2/25/2018 21,000 54,900 30,100 50,500 44,900 Customer 1 Customer 9 Customer 54 Customer 88 Customer 83 Customer 35 Customer 84 Customer 113 Customer 31 Customer 129 Customer 76 Customer 14 Customer 58 Customer 22 Customer 10 Customer 57 Customer 66 Customer 94 Customer 77 Customer 60 Customer 72 Customer 3 Other Cherry Drake Costanza New Hampshire Life Sciences Website Birch Jarmel Kramer Rhode Island Life Sciences Banner Ad Redwood Morgan Kramer Connecticut Financial Services Referral Pine Morgan Benes Vermont Technology Website Spruce Newman Costanza Massachusetts Life Sciences Referral Cherry Morgan Seinfeld Vermont Technology Trade Show Walnut Newman Seinfeld Vermont Life Sciences Trade Show Redwood Jarmel Kramer New Hampshire Retail Referral Redwood Morgan Benes Massachusetts Technology Trade Show Cherry Wilhelm Kramer Connecticut Technology Website Walnut Jarmel Benes Connecticut Technology Trade Show Birch Newman Benes Maine Durable Goods Other Birch Morgan Costanza Connecticut Technology Banner Ad Redwood Wilhelm Benes Connecticut Retail Referral Cherry Morgan Kramer New Hampshire Financial Services Trade Show Cherry Wilhelm Kramer Rhode Island Life Sciences Other Cherry Drake Kramer Connecticut Retail Banner Ad Cherry Pennypacker Costanza Rhode Island Retail Website Spruce Jarmel Seinfeld New Hampshire Financial Services Call in Pine Drake Seinfeld Rhode Island Financial Services Call in Pine Jarmel Costanza Connecticut Retail Website Walnut Newman Seinfeld Rhode Island Manufacturing Website Redwood Wilhelm Seinfeld Maine Financial Services Other Redwood Morgan Costanza New Hampshire Life Sciences Referral Spruce Morgan Kramer Massachusetts Manufacturing Referral Birch Wilhelm Seinfeld Maine Financial Services 4/22/2017 5/3/2017 12/18/2017 5/13/2017 5/5/2017 2/12/2017 9/15/2017 8/19/2017 1/29/2017 10/23/2017 8/23/2017 8/8/2017 11/21/2017) 8/11/2017 1/9/2017 7/22/2017 4/4/2017 10/4/2017 4/12/2017 8/11/2017 3/29/2017 4/23/2017 10/20/2017 11/1/2017 8/18/2017 3/16/2017 4/22/2018 36,100 37,900 12/18/2018 47,800 53,000 50,000 2/12/2018 18,800 52,200 8/19/2018 19,900 36,400 10/23/2018 13,300 31,100 8/8/2018 31,500 25,800 40,000 1/9/2018 7,700 42,000 46,100 10/4/2018 37,600 42,900 25,900 3/29/2018 14,000 4/23/2018 11,600 45,200 11/1/2018 17,300 41,500 3/16/2018 13,100 Customer 93 Customer 114 Customer 6 Customer 17 Customer 7 Customer 108 Customer 50 Customer 15 Customer 55 Customer 19 Customer 90 Customer 16 Customer 81 Customer 45 Customer 131 Customer 42 Customer 28 Customer 27 Customer 12 Website Redwood Newman Benes New Hampshire Financial Services Banner Ad Redwood Drake Kramer Maine Financial Services Other Cherry Morgan Benes Rhode Island Durable Goods Other Redwood Drake Seinfeld Rhode Island Life Sciences Other Pine Newman Kramer Rhode Island Manufacturing Other Spruce Pennypacker Kramer Rhode Island Retail Trade Show Walnut Pennypacker Costanza Maine Financial Services 2/21/2017| 4/10/2017 8/12/2017 1/13/2017) 9/20/2017 2/3/2017) 10/16/2017 46,600 48,500 35,900 23,800 40,500 25,500 29,400

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

I will extract data from the uploaded images analyze customer attrition trends and create pivo... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!