Difference between revisions of "1718t1is428T9"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 32: Line 32:
 
<!--/Header-->
 
<!--/Header-->
  
==<div style="background: #061935; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:helvetica"><font color= #ffffff>Introduction</font></div>==
+
==<div style="background: #061935; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:helvetica"><font color= #ffffff>PROBLEM & MOTIVATION</font></div>==
  
While harmful and underage drinking are significant public health problems, and they exact an enormous toll on the intellectual and social lives of students. With the uptrend of student having drinking habits, many other problems arise as well, namely the number of crimes offended by students, poor academic performance, as well as relationship issues with family and friends. This problem has been significant over the past few years and soon it will become a social problem.
+
Flight delays has been a very common problem for travelers, the delay can be attributable to various problems, such as, aircraft issues, weather issues at origin airport or/and destination airport. The delay has no doubts will disappoint air travelers and affect their flight experience greatly. Thus, in this project, our team aims to investigate the performance of different airlines and flight delays in detail.  
  
In consideration of a range of risks and negative consequences posed by the underage drinking, it's necessary to identify what are the causes leading to this behavior. In this study, we will work on analyzing the relationship between students' alcohol consumption and various factors, finding out how alcohol consumption affect students general well-being and finally, what are the countermeasure we can do.
+
In addition, airport network is a very critical and complex transportation infrastructure for a nation, it is increasingly important for public policy considerations. The disruptions of the airport network, caused by terrorist attack, disease transmission or other reasons, can lead to huge economic loss. Thus, the study on the airport network can assist us better understand the relationship between different airports, for example, identify most critical airport, and take proactive measures to prevent occurrence of disruptions.  
  
==<div style="background: #061935; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:helvetica"><font color= #ffffff>Objective</font></div>==
 
  
The aim of this project is to visually analyze the factors related to underage drinking and how alcohol affect students general well-being, the area we are going to specify are:
+
==<div style="background: #061935; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:helvetica"><font color= #ffffff>OBJECTIVES</font></div>==
 +
 
 +
In this project, we will adopt visualization techniques to:
 +
 
 
<ul>
 
<ul>
<li>Demographics of student alcohol consumption</li>
+
<li>Demographics of student alcohol consumptionAnalyse airport network connectivity</li>
<li>Relationship with family</li>
+
<li>Analyse flight delays for different airlines</li>
<li>How alcohol affects their academic standing</li>
+
<li>Evaluate on-time performance for airlines and aircrafts</li>
 
</ul>
 
</ul>
  
==<div style="background: #061935; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:helvetica"><font color= #ffffff>Data Source</font></div>==
+
==<div style="background: #061935; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:helvetica"><font color= #ffffff>SELECTED DATASET</font></div>==
  
 
We have obtained the 2014 from Kaggle, which can be download from https://www.kaggle.com/uciml/student-alcohol-consumption
 
We have obtained the 2014 from Kaggle, which can be download from https://www.kaggle.com/uciml/student-alcohol-consumption

Revision as of 15:18, 7 November 2017

1718T9G1 Logo.jpg


HOME

 

PROPOSAL

 

POSTER

 

APPLICATION

 

RESEARCH PAPER


PROBLEM & MOTIVATION

Flight delays has been a very common problem for travelers, the delay can be attributable to various problems, such as, aircraft issues, weather issues at origin airport or/and destination airport. The delay has no doubts will disappoint air travelers and affect their flight experience greatly. Thus, in this project, our team aims to investigate the performance of different airlines and flight delays in detail.

In addition, airport network is a very critical and complex transportation infrastructure for a nation, it is increasingly important for public policy considerations. The disruptions of the airport network, caused by terrorist attack, disease transmission or other reasons, can lead to huge economic loss. Thus, the study on the airport network can assist us better understand the relationship between different airports, for example, identify most critical airport, and take proactive measures to prevent occurrence of disruptions.


OBJECTIVES

In this project, we will adopt visualization techniques to:

  • Demographics of student alcohol consumptionAnalyse airport network connectivity
  • Analyse flight delays for different airlines
  • Evaluate on-time performance for airlines and aircrafts

SELECTED DATASET

We have obtained the 2014 from Kaggle, which can be download from https://www.kaggle.com/uciml/student-alcohol-consumption

The information provided are very extensive and comprehensive, it includes

  1. school - student's school (binary: 'GP' - Gabriel Pereira or 'MS' - Mousinho da Silveira)
  2. sex - student's sex (binary: 'F' - female or 'M' - male)
  3. age - student's age (numeric: from 15 to 22)
  4. address - student's home address type (binary: 'U' - urban or 'R' - rural)
  5. famsize - family size (binary: 'LE3' - less or equal to 3 or 'GT3' - greater than 3)
  6. Pstatus - parent's cohabitation status (binary: 'T' - living together or 'A' - apart)
  7. Medu - mother's education (numeric: 0 - none, 1 - primary education (4th grade), 2 – 5th to 9th grade, 3 – secondary education or 4 – higher education)
  8. Fedu - father's education (numeric: 0 - none, 1 - primary education (4th grade), 2 – 5th to 9th grade, 3 – secondary education or 4 – higher education)
  9. Mjob - mother's job (nominal: 'teacher', 'health' care related, civil 'services' (e.g. administrative or police), 'at_home' or 'other')
  10. Fjob - father's job (nominal: 'teacher', 'health' care related, civil 'services' (e.g. administrative or police), 'at_home' or 'other')
  11. reason - reason to choose this school (nominal: close to 'home', school 'reputation', 'course' preference or 'other')
  12. guardian - student's guardian (nominal: 'mother', 'father' or 'other')
  13. traveltime - home to school travel time (numeric: 1 - <15 min., 2 - 15 to 30 min., 3 - 30 min. to 1 hour, or 4 - >1 hour)
  14. studytime - weekly study time (numeric: 1 - <2 hours, 2 - 2 to 5 hours, 3 - 5 to 10 hours, or 4 - >10 hours)
  15. failures - number of past class failures (numeric: n if 1<=n<3, else 4)
  16. schoolsup - extra educational support (binary: yes or no)
  17. famsup - family educational support (binary: yes or no)
  18. paid - extra paid classes within the course subject (Math or Portuguese) (binary: yes or no)
  19. activities - extra-curricular activities (binary: yes or no)
  20. nursery - attended nursery school (binary: yes or no)
  21. higher - wants to take higher education (binary: yes or no)
  22. internet - Internet access at home (binary: yes or no)
  23. romantic - with a romantic relationship (binary: yes or no)
  24. famrel - quality of family relationships (numeric: from 1 - very bad to 5 - excellent)
  25. freetime - free time after school (numeric: from 1 - very low to 5 - very high)
  26. goout - going out with friends (numeric: from 1 - very low to 5 - very high)
  27. Dalc - workday alcohol consumption (numeric: from 1 - very low to 5 - very high)
  28. Walc - weekend alcohol consumption (numeric: from 1 - very low to 5 - very high)
  29. health - current health status (numeric: from 1 - very bad to 5 - very good)
  30. absences - number of school absences (numeric: from 0 to 93)

Technical Complexity

Below are the list of technical challenges that team may be faced with when developing the visualization application.

Technical Challenges How To Resolve
Unfamiliar with D3.js libraries
  • Attend D3.js workshop
  • Peer Learning
Lack of knowledge on building D3 application
  • Research on how to build D3 application
  • Knowledge sharing and discussion
Data Cleaning and data Transformation
  • Understand data and its metadata
  • Identify required formats for data cleaning and transformation

Tools/Technology

  • Excel
  • Tableau
  • D3.js

Project Milestones

1718g1t9 milestones.png

References

Comments