辅导案例-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
51作业君 51作业君

扫码添加客服微信

添加客服微信: IT_51zuoyejun