Difference between revisions of "1718t1is428T8"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 18: Line 18:
 
<div style="background: black; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#e62b1e face="Century Gothic">Introduction</font></div>
 
<div style="background: black; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#e62b1e face="Century Gothic">Introduction</font></div>
 
<p align="justify">
 
<p align="justify">
DOTA 2 (Defense Of The Ancients 2) is a game where you play as one side of the ultimate struggle between the Radiant and the Dire. Each side consists of 5 players and the objective is to destroy the opponent's key structure and defending your own.
+
The international exports and imports of services has played an increasingly important role in Singapore over the last decade, with 70% of the nation’s GDP comprising of service industries such as finance, insurance and wholesale retail trade, up from 64% 10 years ago.
 
<br/><br/>
 
<br/><br/>
As of 13th October 2017, there are 112 heroes to be chosen for play. Heroes are the essential element of DOTA 2, as the course of the match is dependent on their intervention. During a match, two opposing teams select 5 out of 112 heroes that accumulate experience and gold to grow stronger and gain new abilities in order to destroy the opponent's key structure. Most heroes have a distinct role that defines how they affect the battlefield, though many heroes can perform multiple roles.  
+
As government bodies such as the Ministry of Trade and Industry (MTI ) and Innovation and Enterprise (IE) Singapore focus more on these industries in their development plans, there comes the need to continuously view the trends and components of our services exports. This will allow us to understand the growth trends of this critical aspect of Singapore’s economy, its individual components and the countries that contribute to it and finally to monitor the effects of existing initiatives from various government agencies.  
<br/><br/>
+
 
DOTA 2 is now not just some any other game being played for purely personal entertainment. Every year for the past 6 years, DOTA 2 tournaments has broken the record for the biggest prize pool in e-sports history. The tournament started off with an initial prize money of USD$1.6 million in 2011 before rising to USD$10 million by 2014, past USD$20 million in 2016, and recently close to USD$25 million in 2017. These eight-figure prizes have attracted the eye of mainstream media, and DOTA 2 made it to the front page of The New York Times. With that much money on the line, professional teams recognize the importance of hero selection.
 
 
</p>
 
</p>
  
 
<br/>
 
<br/>
<div style="background: black; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#e62b1e face="Century Gothic">Problem</font></div>
+
<div style="background: black; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#e62b1e face="Century Gothic">Problem and Motivation</font></div>
  
 
<p align="justify">
 
<p align="justify">
The problem here is that with the ever increasing prize pool for the tournaments, there are professional DOTA 2 players joining in aiming for the top prize money. In order to increase their chances to get into the finals and eventually win the top prize money, on top of possessing skill and techniques, they have to pick the 5 best heroes out of the 112 available heroes to play as a team. Some matches even took up to ten minutes for both teams to select their heroes.
+
From the existing reports prepared by MTI, we’ve identified the following areas in which we plan our visualization to value-add:
 +
<br/><br/>
 +
1) Interactivity and Customisability  - By allowing the reader to interact with the graph to filter periods to view as well as the level of detail. This will facilitate user-led investigation and exploration of the data without any data processing tools.
 
<br/><br/>
 
<br/><br/>
However, finding this 'dream team' is proven to be extremely time consuming as there are about 134 million hero combinations. No team can afford the time to play multiple matches of all these 134 million hero teams just to find out the 'dream team', not to even mention spending time playing thousands of matches to improve the overall teamwork and synergy to prepare for the tournament.
+
2) Professional and ready to use format – This will save stakeholders such as MTI and SPH time in the preparation of graphs, especially when graph formatting is necessary before release to the public.
 +
 
 
<br/><br/>
 
<br/><br/>
Even so, putting all the eggs into 1 basket can be pretty undesirable as during the actual tournament, any heroes in the 'dream team' could be picked by the opponent team or even banned for play in the match. Teams will usually specialize in a few heroes to prevent being placed in such difficult situation but different heroes having differing abilities will disrupt the synergy between the team.  
+
This will provide a one stop visualization for stakeholders in the services industry in Singapore, to quickly consume the aspects of this data that is relevant to them, in an aesthetically pleasing and intuitive manner.
 
</p>
 
</p>
 
<br/>
 
<div style="background: black; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#e62b1e face="Century Gothic">Objectives</font></div>
 
In this project, we would like to use data from past matches to create a visualization that helps users increase the chances of winning a match by determining:
 
* What are the main factors that should be focused on in order to win a match?
 
* Which heroes are best to be played with a specific chosen hero?
 
  
 
<br/>
 
<br/>
 
<div style="background: black; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#e62b1e face="Century Gothic">Data Source</font></div>
 
<div style="background: black; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.08em;font-size:20px"><font color=#e62b1e face="Century Gothic">Data Source</font></div>
  
We are using the [https://www.kaggle.com/jraramirez/dota-2-matches-dataset Dota 2 Matches Dataset] from Kaggle.  
+
We are using the following two datasets from the Singapore Department of Statistics:
 
+
<br/><br/> [http://www.tablebuilder.singstat.gov.sg/publicfacing/createDataTable.action?refId=6810 Exports Of Services By Major Trading Partner And Services Category, Annual Dataset]
 +
<br/><br/>
 +
[http://www.tablebuilder.singstat.gov.sg/publicfacing/createDataTable.action?refId=6816 Imports Of Services By Major Trading Partner And Services Category, Annual Dataset]
  
 
The dataset consists of the following columns:
 
The dataset consists of the following columns:

Revision as of 17:22, 4 November 2017

DOTA.png



Introduction

The international exports and imports of services has played an increasingly important role in Singapore over the last decade, with 70% of the nation’s GDP comprising of service industries such as finance, insurance and wholesale retail trade, up from 64% 10 years ago.

As government bodies such as the Ministry of Trade and Industry (MTI ) and Innovation and Enterprise (IE) Singapore focus more on these industries in their development plans, there comes the need to continuously view the trends and components of our services exports. This will allow us to understand the growth trends of this critical aspect of Singapore’s economy, its individual components and the countries that contribute to it and finally to monitor the effects of existing initiatives from various government agencies.


Problem and Motivation

From the existing reports prepared by MTI, we’ve identified the following areas in which we plan our visualization to value-add:

1) Interactivity and Customisability - By allowing the reader to interact with the graph to filter periods to view as well as the level of detail. This will facilitate user-led investigation and exploration of the data without any data processing tools.

2) Professional and ready to use format – This will save stakeholders such as MTI and SPH time in the preparation of graphs, especially when graph formatting is necessary before release to the public.

This will provide a one stop visualization for stakeholders in the services industry in Singapore, to quickly consume the aspects of this data that is relevant to them, in an aesthetically pleasing and intuitive manner.


Data Source

We are using the following two datasets from the Singapore Department of Statistics:

Exports Of Services By Major Trading Partner And Services Category, Annual Dataset

Imports Of Services By Major Trading Partner And Services Category, Annual Dataset

The dataset consists of the following columns:

  • match_id - INTEGER, unique match id
  • match_seq_num - INTEGER, match sequence number
  • radiant_win - STRING, boolean variable than indicates if radiant won or not in the match
  • start_time - INTEGER, start time of the match
  • duration - INTEGER, duration of the match
  • tower_status_radiant - INTEGER, remaining health of the towers of the radiant side
  • tower_status_dire - INTEGER, remaining health of the towers of the dire side
  • barracks_status_radiant - INTEGER, remaining health of the barracks of the radiant side
  • barracks_status_dire - INTEGER , remaining health of the towers of the direside
  • cluster - INTEGER,
  • first_blood_time - INTEGER, time when the first blood occured in the match
  • lobby_type - INTEGER, type of the looby of the match
  • human_players - INTEGER, number of human players in the match leagueid - INTEGER, league id
  • positive_votes - INTEGER, number of positive votes
  • negative_votes - INTEGER, number of negative votes
  • game_mode - INTEGER, game mode
  • engine - INTEGER, engine
  • picks_bans - STRING, picks and bans
  • parse_status - INTEGER, parse status
  • item - STRING, a complex JSON that also include all the columns mentioned but may need more processing since the more interesting data are found here (e.g. chats, teamfights, purchase logs, etc. )


Key Technical Challenges

The following are some of the key technical challenges that we may face throughout the course of the project:

Key Technical Challenges Plans to resolve these issues
Data Cleaning & Transformation
  • Understanding the data
  • Cleaning and Transforming the data together
Unfamiliarity in Javascript, especially D3 Libraries
  • Attending D3 Programming Workshop
  • Research on different types of charts
  • Independent Learning on D3 Libraries
  • Asking questions on sites like StackOverflow to seek help


Project Timeline

The timeline for this project until its completion is as follows:

T8 Timeline.png


Tools & Technologies

The tools and technologies we will be using for this project:

  • Data Cleaning
    • Excel
    • JMP
    • R
  • Data Visualization
    • D3.js


Comments

Please give us feedbacks! Thank you!