New Jersey Institute Of Technology-IS 665_ADN24_Solution-REVIEWED AND EDITED BY EXPERTS-A COMPLETE GUIDE FOR EXAM PREPARATION

Document Content and Description Below

IS 665 Data Analysis for Information Systems Final Exam YOUR NAME: Anuradha Naik ([email protected])IS 665 Data Analysis for Information Systems Final Exam Table of Contents 1.Data Warehouse........... ...............................................................................................................................3 2.BFS(10 pts)................................................................................................................................................6 3.Probablity (10 pts)..................................................................................................................................15 4.Temperature(10 pts.)..............................................................................................................................17 5. Association Rules (10 pts.).....................................................................................................................18 6 (Association Rules – FP Tree) 10 pts........................................................................................................22 7. Clustering – k Means (10 pts.)...............................................................................................................23 8. Decision Tree (10 pts)...........................................................................................................................25 9. Naïve Bayes (10 pts)...............................................................................................................................26 10. Evaluation (10 pts.)..............................................................................................................................27 Appendix...................................................................................................................................................28 2 |IS 665 Data Analysis for Information Systems Final Exam 1. The following is the meta-data of a call center database. It records information about all calls made by the customers to call center agents regarding certain products. The agents’ jobs are to take the calls, help customer figuring out what to do, and to take actions by directing customers to a certain web page where the agent and the customer could conduct online chat and run diagnostic sessions. (10 pts) a. Identify the measures and constraints in the following business question: Report how often agents in different positions access web pages of each page type to perform customer support tasks for customers from each state in each month. Use attributes from the meta data below to serve as the constraints. For example, the constraint “customer state” should be expressed as the attribute “Customer.State” (10 pts) Measures: Number of Agent Clicks COUNT(Agent_Click.TID) Constraints: i. Agent.Position ii. WebPage.PageType iii. Customer.State iv. Agent_Click.Entry_Time , Filter: Month; 3 |IS 665 Data Analysis for Information Systems Final Exam b. Given the meta data below, design a star schema that helps you answer question a. All attributes in your star schema must come from the meta data table blow. (5 pts) 4 | Visit_Fact #TID #Position #PageType #State #Entry_Time Task #TID TC_Name Agent #Postion AID AName Agender Abranch Experience_Level Hiring_Date Manager_IDHiring _Date Manager_ID Customer #State CustomerKey CID Cname Gender City County Income_level Education_level Internet_Usage _Level Year_Number Agent_Click #TID #Entry_Time PageURL Action # PageType PageURL PageURL [Show More]

Last updated: 1 year ago

Preview 1 out of 29 pages