辅导案例-ALYTICS 2019
CA 50% BUSINESS ANALYTICS 2019 INTRODUCTION • FOR THIS ASSIGNMENT YOU ARE REQUIRED TO: 1. PREPARE, ANALYSE AND PRESENT THE DATA IN THE NCT-FAILURES.XLSX WORKBOOK. (35%) 2. WRITE A SUMMARY REPORT DETAILING THE WORK COMPLETED. (15%) • THE SKILLS TO BE DEMONSTRATED WILL BE BASED ON BOTH LECTURES AND LABS AS WELL AS SELF DIRECTED LEARNING. THE DATASET • THE DATA RELATES TO VEHICLE MAKE AND MODEL NCT FAILURES IN 2015 • IT IS PUBLICALLY AVAILABLE DATA: HTTPS://DATA.GOV.IE/DATASET/2015-MAKE-MODEL-YEAR-FAILURES- AT-NCT • A VEHICLE FAILS THE TEST BASED ON SAFETY CRITERIA. THE DATAFILE GIVES DETAILS ON THE NUMBER OF EACH MAKE AND MODEL VEHICLE, AND THE CRITERIA THEY FAILED ON. THE DATASET • 7749 ROWS • 36 COLUMNS • ADDITIONAL INFORMATION AVAILABLE ON RSA.IE CODEBOOK EACH RECORD HOLDS DETAILS OF A SINGLE VEHICLE MAKE, MODEL AND YEAR, HOW MANY OF THAT MAKE MODEL YEAR FAILED THE NCT TEST AND IN WHICH CRITERIA. FAIL ITEMS INCLUDE: SAFETY, LIGHTING, BRAKES, STEERING, ENGINE, CHASSIS ETC GENERAL REQUIREMENTS • USE OF NCT FAILURE DATA • DATA PREP AND ANALYSIS, DESCRIPTIVE STATISTICS, AND GRAPHICAL PRESENTATION OF THE FINDINGS • SUMMARY REPORT • ALL YOUR OWN WORK. RESEARCH QUESTION? • WHAT DO YOU WANT TO DISCOVER FROM THIS DATASET? • WHAT QUESTIONS WOULD YOU LIKE TO TRY TO ANSWER? DATA PREP AND ANALYSIS • THE DATA REQUIRES CLEANING PRIOR TO BEING ANALYSED. • YOU MUST FIRST FAMILIARISE YOURSELF WITH THE DATASET, THERE MAY BE MISSING VALUES, UNUSABLE DATA, INCONSISTENT VALUES, AND INCONSISTENT FORMATS. • CONSIDER THE QUESTION(S) YOU WANT THE DATA TO ANSWER? • UNDERSTAND THE DATA AND THEN CHOOSE THE DATA WHICH IS SUITABLE FOR RESEARCH QUESTION. • YOU MAY CHOOSE A SUBSET OF THE DATA ON WHICH TO PERFORM YOUR ANALYSIS. • YOU MAY CHOOSE TO ADD TO THE DATASET. DATA PREP AND ANALYSIS • USING EXCEL: • THE ANALYSIS SHOULD PROVIDE A HIGH LEVEL OVERVIEW OF THE DATA (INCLUDING SUMMARY STATISTICS). • THE ANALYSIS SHOULD PRODUCE DETAILED PRESENTATION OF THE DATA IN VISUAL FORM (CHARTS, BOX PLOTS, SCATTER ETC) APPROPRIATE TO YOUR RESEARCH QUESTION(S). • THIS DATA PREPARATION AND ANALYSIS IS TO BE YOUR OWN WORK AND REPORTED IN THE FINAL DOCUMENT. PRESENTATION • VISUAL PRESENTATION OF YOUR FINDINGS SHOULD BE INCLUDED IN THE EXCEL WORKBOOK YOU SUBMIT. • SOME VISUAL PRESENTATION OF FINDINGS WILL ALSO BE SUITABLE TO INCLUDE IN YOUR SUMMARY REPORT. • THIS MAY BE IN THE FORM OF CHARTS, HISTOGRAMS, BOXPLOTS, LINE GRAPHS, PIE CHARTS ETC. • YOU MAY COMBINE THESE INTO A COHERENT DASHBOARD SUITABLE FOR YOUR RESEARCH QUESTION(S). SUMMARY REPORT • A SUMMARY REPORT THAT DETAILS THE DATA ANALYTICS PROCESS UNDERTAKEN. • THE REPORT SHOULD INCLUDE DETAILS ON: • IDENTIFICATION OF RESEARCH QUESTION(S) • DATA PREPARATION (ENSURING GOOD QUALITY DATA) • DATA DISCOVERY (FAMILIARISATION WITH THE DATASET, DESCRIPTIVE STATISTICS, CHARTS ETC) • EXPLORATION AND ANALYSIS OF DATA • PRESENTATION OF THE FINDINGS USING APPROPRIATE GRAPHICAL MEANS • THE REPORT SHOULD INCLUDE ALL SUMMARY STATISTICS AND DATA ANALYSIS CONDUCTED DURING THE DATA DISCOVERY AND PREPARATION STAGES IN RELATION TO YOUR RESEARCH QUESTION(S). GRADING SPECTRUM Data Preparation Data Analysis Data Presentation Report Basic cleaning Basic analysis conducted Simple charts and descriptive statistics Outline of work conducted Complete data discovery and data prep suitable for research question(s) Complete analysis using method taught Well thought out use of various appropriate charts Detailed report Additional transformations and data created Additional data used, advanced analysis with some new methods Clear, complete and appropriate presentation using new methods Complete, well written report with rationale for approach Data discovery and data prep to very high standard, with additional data source added. Advanced analysis demonstrating self directed learning, identification of valuable insights in the data Advanced presentation of findings As above MARKING SCHEME • <40% (FAIL): POOR DATA PREP AND ANALYSIS CONDUCTED. VERY FEW ANALYSIS TECHNIQUES HAVE BEEN IMPLEMENTED. THE DATA CLEANING IS LIMITED AND NO NEW DATA CREATED. POOR IDENTIFICATION OF RESEARCH QUESTION(S). WEAK SUMMARY REPORT. • 40 - 50%: SUMMARY REPORT CONTAINS ADEQUATE DETAILS ON WORK COMPLETED. SUFFICIENT DATA PREP AND ANALYSIS CONDUCTED TO PRESENT FOR THE RESEARCH QUESTION(S) CHOSEN. STUDENTS HAVE IMPLEMENTED SOME OF THE ANALYSIS REQUESTED. • 50-69%: SUMMARY REPORT WELL WRITTEN WITH DETAILS ON EACH STAGE OF THE PROCESS. VERY GOOD DATA PREP AND ANALYSIS CONDUCTED AND DOCUMENTED WITH APPROPRIATE GRAPHICAL PRESENTATION OF THE WORK (USING SOME NEW METHODS). • 70% OR MORE: SUMMARY REPORT VERY WELL WRITTEN WITH ADDITIONAL MATERIAL INCLUDED AND RESEARCH CONDUCTED. STUDENTS HAVE DEMONSTRATED ALL THE ABOVE TO A HIGH LEVEL OF PROFICIENCY (E.G., VISUAL AND TECHNICAL QUALITY). IN ADDITION THE STUDENT HAS DEMONSTRATED INDEPENDENT LEARNING BY ADDING SOME DATA AND TECHNIQUES THAT HAVE NOT BEEN COVERED DURING THE CLASSES OR LABS PROJECT : ORIGINALITY • THE PROJECT MUST BE YOUR OWN WORK AND I WILL VERIFY THE ORIGINALITY OF THE WORK AGAINST THE WEB + OTHER STUDENT SUBMISSIONS. • IF YOU DO RE-USE TECHNIQUES SOURCED EXTERNALLY, I EXPECT • YOU TO UNDERSTAND THESE TECHNIQUES • SPECIFICALLY INCLUDE A REFERENCE TO THE SOURCE OF THE TECHNIQUE (FAILURE TO ATTRIBUTE IS CONSIDERED PLAGARISM) 14 http://www.wit.ie/images/uploads/Policies_PDF/Academic_Regulations.pdf Page 69 PROJECT ONE: SUBMISSION • THE PROJECT NEEDS TO BE SUBMITTED ON OR BEFORE THE DEADLINE • LATE SUBMISSION WILL RESULT IN A REDUCED MARK OF 5% FOR EACH DAY LATE. • THE ASSIGNMENT NEEDS TO BE SUBMITTED VIA MOODLE USING THE DEDICATED SUBMISSION FOLDER • ALL CONTENT NEEDS TO BE INCLUDED IN A ZIPPED FOLDER LABELED WITH YOUR STUDENT NUMBER. THE ZIPPED SUBMISSION SHOULD INCLUDE: • EXCEL DATA FILE AFTER DATA PREP WAS CONDUCTED • SUMMARY REPORT • DUE DATE FOR HANDUP IS SUNDAY 17TH NOV BY 11:00PM USING ASSIGNMENT DROPBOX ON MOODLE IN THE MODULE ASSESSMENT AND RESOURCES TOPIC AREA. 15