The following is a case study about data analysis & data visualization basics

4 case questions in total. it's not difficult, but I am not sure about the answer

the pictures in the very bottoms are the ppt you can use in answering the questions

Case Study Lemonade, an W startup founded in 2015, made its initial public offering in July with a $1.7 billion valuation. Lemonade is an online platform that aims to address some of the key problems of the traditional home insurance industry. The company has been able to develop its business through smart design and a good marketing strategy. The AI component was built on top of that. The company's website and mobile app are very easy to use, the users can ll out a form with their name, gender, age, marriage status, incoming, address, phone number, and inform whether they had previous insurance or not. The process of buying insurance and filing claims with the app and website goes through digital assistants and is much faster than traditional insurance companies. As one of the first movers in the Wspace, Lemonade had the edge over other similar companies that have cropped up in recent years, and it was able to quickly snatch a lot of users who were looking for a shift from traditional insurance model to one that was more Lechzfucused. Lemonade' 5 business model and messaging are also interesting. The company takes a at fee from premiums, which means the company doesn't make a prot from denying claims. The unclaimed money goes to charities of users' choice. The company also says that it will not invest premiums into heavily polluting industries and companies that cause harm. So, basically, Lemonade is marketing itself as the good guy in a historically reviled industry, on a mission, per the company's words, to \"transform insurance from a necessary evil to a social good.\" Insurance depends a lot on data, and established agencies have more than a century of data they can use to develop risk models and create insurance policies. Lemonade didn't have the data of traditional agencies, but it also didn't have their baggage of customers and old policies. It was able to create its entire technology stack from the ground up to cater to the needs of an AI factory. With the entire experience being digitized, the company can collect a lot more data from each customer interaction, including data points W do not capture. This enables the company to create machine learning models that not only predict insurance risk with growing accuracy over time but can also create automation and personalization opportunities that were impossible before. The company has two AI chatbots: Maya helps you create your insurance plan in a few minutes, and Jim handles the claims process. According to the company, AI handles a third of the cases and pays claims in a matter of minutes. The rest of the claims are transferred to human agents. The chatbot continues to improve as it gathers more data. The company believes that with time, AI will give it the edge over traditional agencies and allow it to provide much more affordable plans to customers. And its $480 million pre-IPO funding and its post-1P0 growth show that investors believe its plan can work. Based on the case study above answer the following questions. 1- Based on the case study above identify and cite (3,0): a. six raw data sources from three different types. b. four types of information that can be extracted from this data. C. two decisions that can be made based on it. 2 - How a dashboard structure for Lemonade would look like? Use the raw data and the information that you described in question 1 and provide ve KPIs that could be part of the three layers structure on a dashboard. (3,0) 3 You have a meeting with the CEO of Lemonade and you are supposed to convince them to hire you to build the dashboard structure that you described above. Describe the main benet of dashboards that you would use to sell your service. (3,0) 4 Based on the case study above and considering computer data types \"having previous insurance\" is a raw data type (1,0): a. Char b. String c. Boolean (1. Double e. Array Answer: DASHBOARD STRUCTURE 83K LLLLLLLLLLLL Dashboard Dashboard Sales by Quarter B .. Sales and Drufft by Month Profit by Cantry O Sites Ofall Organized Information LLLLLLLLLLLL Report A Report B Report C 01100 X 10110 ORACLE Raw Data 11110 Dataset A Dataset B Dataset CKPI is a metric that measures how projects, individuals, departments, or businesses perform in terms of strategic goals. JJ 0 .1. If" C O 0 AAA 33:. INDIVIDUAL MANAGERIAL BUSINESS PROGRESS ADJUSTMENT HEALTH Laid DASHBOARD KPIs Visits by Week of Year Bounce Rate by Week of Year 1.029.973 75 BOS VISITS 70 1. How many people are visiting your website? 94 sec 30 5 AVG. SESSION DURATION 40 * 2. How many pages are they 1,8 pages Traffic Sources Visitors by User Type looking at? 26 % Direct PER VISIT 5% Display 3. How long are they staying? 58 % Organic 58 % 10 % Paid 31 % 4. How many people are BOUNCE RATE 5% Referral New converting? 7% Social Returning 1.853.672 5. What weeks are more Top 3 Channels by Conversion Top 3 Campaigns by Conversion Top 3 Pages by Conversion PAGE VIEWS Page 2 critical? 10% 6. Is the website achieving GOAL CONVERSION satisfactory access? WEBSITE ACCESS - DASHBOARDFORUM: DASHBOARD KPIs E74M 8% Customer Satisfaction Total Revenue 2017 Support Costs To Revenue 2017 5 % E 67.619 7% E 21.882 E 23.661 E 22.076 TOTAL SPEND CAMPAIGN 1 CAMPAIGN 2 CAMPAIGN 3 Revenue And % Of Support Costs To Revenue Of E 105.00 of E 25.000 of E 30.000 of E 50.000 100M 30 % 71% E80M 24 96 Positive E60M 18 % Revenue % Of Support Costs To Revenue E40M CPA by Campaign - Last 12 weeks 12 9 Acquisitions by Campaign - Last 12 weeks 40 % 20M 6 9% 71.680 Campaign 1 E419 32 COM Very Satisfied Satisfied TOTAL IMPRESSIONS 2012 2013 2014 2015 2016 2017 Neutral Unsatisfied Campaign 2 :1.118 54 Revenue + % Of Support Costs Very Unsatisfied Campaign 3 E678 2.203 20 Costs Per Support Avg Time To Solve An Issue TOTAL CLICKS E15.00 Daily Impressions by Campaign - Last 12 weeks Less than 1 hour 79 % E10,00 106 E5.00 TOTAL ACQUISITIONS 1 - 2 hours E0.00 Jan 2017 Feb 2017 Mar 2017 Apr 2017 May 2017 Jun 2017 Jul 2017 Aug 2017 Sep 2017 Oct 2017 Nov 2017 Dec 2017 More than 2 hours 2016-01-21 2016-01-23 2016-01-25 2016-01-27 2016-01-29 2016-01-31 2016-02-02 2016-02-04 2016-02-06 2016-02-08 2016-02-10 2016-02-12 2016-02-14 2016-02-16- 2016-02-18 2016-02-20 2016-02-22 2016-02-24 2016-02-26 2016-02-28 2016-03-01 2016-03-03 2016-03-05 2016-03-07 2016-03-09 2016-03.11 2016-03-13- 2016-03-15 2016-03-17 2016-03-19 2016-03-21 2016-03-23 2016-04-06 2016-04-10 E 631 2016-03-25 2016-03-27 2016-03-29 2016-03-31 2016-04-04 2016-04-02 2016-04-08 2016-04-12 Cost Per Support *. Avg Cost Per Support COST PER ACQUISITION MARKETING DASHBOARD COSTUMER SUPPORT DASHBOARDDASHBOARD BENEFITS Centralized (Data) Customizable Intuitive Dashboard Real time Collaborative Updated InteractiveWHAT IS THE DIFFERENCE BETWEEN DATA AND INFORMATION? Are you an agent acting on a student's behalf? * No YES OR NO First Name * Middle Max length 15 characters Max length 14 characters. Last Name * Max length 25 characters. DATA INFORMATION Email Address * Confirm Email Address * V = RAW FACTS Country of Citizenship * PROCESSED FACTS h How would you describe yourself? * A = mr UNORGANIZED C =2nr V =mr-h ORGANIZED 30 450 609 [sin xdx =-cosx+C tan (8) HELP TO MAKE sin I am a mature student dix Cos 2 19x +C , POOR MEANING DECISIONS Vote on Mature: Mature Student (Non-Traditional Learners): Applicants who do not meet the usual qualifications for [tgxax= admission to Cape Breton University may be considered for admission as a Mature Student, provided they meet the following criteria: 2X MEANINGFUL . be at least 21 years of age (by the first day of classes) sin Ing +c . be a Canadian citizen or permanent resident . not be eligible for regular admission XV3 . apply for the first year of an undergraduate program that does not require previous university-level study NO CONTEXT admission to some programs will require the completion of required subjects have not studied at the university level. Applicants who have studied at the university level must have CONTEXT attempted one year or less of transferable work and been absent from study for a minimum of two years . students can apply for no formal program, allowing them to register in courses without making application to a specific program To prepare for university study, some upgrading may be required. It is recommended that applicants speak with an admission advisor to determine if upgrading is required WHAT CAN I DO WITH Expected Start Term * "YES" OR "NO"? WHY DO WE NEED THIS INTERSECTION TO Account Information Minimum 6 characters. MAKE A DECISION? Password * Confirm Password * ANSWER: DATA AVAILABILITY\fCOMPUTER DATA TYPES R TRUE 16/05/2019 17:59 7 16/05/2019 18:20 FALSE 16/05/2019 22:00 17/05/2019 00:25 INTEGER CHAR BOOLEAN TIMESTAMP 0.5 A 10 000 L 101 FLOAT STRING DATE ARRAY