Difference between revisions of "1718t1is428T12"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 41: Line 41:
  
 
<!--Content-->
 
<!--Content-->
−
==<div style="background: #F6B419; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Trebuchet MS; "><font color= #5E2705>Coming Soon!</font></div>==
+
==<div style="background: #F6B419; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Trebuchet MS; "><font color= #5E2705>Introduction & Motivation</font></div>==
 
<div style="font-size: 15px; padding-top: 15px; padding-bottom: 30px; padding-left: 15px; padding-right: 15px;">
 
<div style="font-size: 15px; padding-top: 15px; padding-bottom: 30px; padding-left: 15px; padding-right: 15px;">
 +
[[File:Panama_intro_photo.jpg|center|500px|link=]]
 +
<br>
 +
The Panama Papers (2016) are a huge leak — 11.5 million (approximately 2.6 TB) — of financial documents that reveal the financial holdings of the rich and powerful. The global investigation into the secretive industry of offshore companies expose how politicians, celebrities, sportsmen and high-net-worth individuals set up front companies in remote jurisdictions to protect their cash from higher taxes, and facilitate bribery, arms deals, financial fraud and drug trafficking. Laying within the trove of leaked files are also the names of the rich and powerful in the Asia-Pacific (APAC) region, overshadowed by the media’s interest of more prominent names of the West.
 +
</div>
 +
 +
==<div style="background: #F6B419; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Trebuchet MS; "><font color= #5E2705>Objectives</font></div>==
 +
<div style="font-size: 15px; padding-top: 15px; padding-bottom: 30px; padding-left: 15px; padding-right: 15px;">
 +
As news coverage, even in Singapore, was focused mainly on the West, attention is diverted from what may be more important, which are details of individuals and businesses in APAC that are also found in the leaked documents. This results in a lack of information and coverage on the APAC region.
 +
 +
Our goal is the shed light on the individuals and business involved in the APAC region in the following ways:
 +
# To present the '''complexity''' and '''structure of relationships''' between entities and individuals in each country in the APAC region.
 +
# Identify '''key parties''' in the offshore investments.
 +
</div>
 +
 +
==<div style="background: #F6B419; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Trebuchet MS; "><font color= #5E2705>Background Survey of Related Works</font></div>==
 +
<div style="font-size: 13px; padding-top: 15px; padding-bottom: 30px; padding-left: 15px; padding-right: 15px;">
 +
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 +
|-
 +
! style="font-weight: bold;background: #5E2705;color:#fff;width: 50%;" | Visualizations
 +
! style="font-weight: bold;background: #5E2705;color:#fff;" | Explanation
 +
|-
 +
| [[Image:|550px|center]]
 +
<br>
 +
<center>Data source: </center>
 +
||
 +
 +
|-
 +
| [[Image:|550px|center]]
 +
<br>
 +
<center>Data source: </center>
 +
||
 +
 +
|-
 +
| [[Image:|550px|center]]
 +
<br>
 +
<center>Data source: </center>
 +
||
 +
 +
|}
 +
</div>
 +
 +
==<div style="background: #F6B419; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Trebuchet MS; "><font color= #5E2705>Datasets</font></div>==
 +
<div style="font-size: 13px; padding-top: 15px; padding-bottom: 30px; padding-left: 15px; padding-right: 15px;">
 +
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 +
|-
 +
! style="font-weight: bold;background: #5E2705;color:#fff;width: 50%;" | Data Source
 +
! style="font-weight: bold;background: #5E2705;color:#fff;" | Attributes
 +
|-
 +
|
 +
<center>
 +
==== '''Offshore Leaks Database by The International Consortium of Investigative Journalists''' ====
 +
Data source: https://offshoreleaks.icij.org/pages/database
 +
</center>
 +
||
 +
|-
 +
|
 +
<center>
 +
==== '''Paradise-Panama-Papers: Data Scientists United Against Corruption dataset''' ====
 +
Data source: https://www.kaggle.com/zusmani/paradisepanamapapers/data
 +
</center>
 +
||
 +
|}
 +
</div>
 +
 +
==<div style="background: #F6B419; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Trebuchet MS; "><font color= #5E2705>Tools / Libraries</font></div>==
 +
<div style="font-size: 15px; padding-top: 15px; padding-bottom: 30px; padding-left: 15px; padding-right: 15px;">
 +
*Tableau
 +
*Github
 +
*Microsoft Excel
 +
*Adobe Creative Suite
 +
*Sketch
 +
*Neo4j
 +
*D3.js
 +
*Python
 +
</div>
 +
 +
==<div style="background: #F6B419; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Trebuchet MS; "><font color= #5E2705>Technical Challenges</font></div>==
 +
<div style="font-size: 13px; padding-top: 15px; padding-bottom: 30px; padding-left: 15px; padding-right: 15px;">
 +
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 +
|-
 +
! style="font-weight: bold;background: #5E2705;color:#FFFFFF; width: 40%;" | Key Technical Challenges
 +
! style="font-weight: bold;background: #5E2705;color:#FFFFFF; width: 30%;" | Detailed Description
 +
! style="font-weight: bold;background: #5E2705;color:#FFFFFF; width: 30%;" | Proposed Solution
 +
|-
 +
| <center> Unfamiliar with D3.js libraries </center> ||
 +
D3.js is a JavaScript library for producing dynamic, interactive data visualizations in web browsers.
 +
||
 +
*Go for the d3 workshop
 +
*Self learning
 +
*Peer Learning
 +
|-
 +
| <center> Data Cleaning and Transformation </center> ||
 +
The data set are in text format and many other different format. Integration are challenging as there are a lot of manual work to be done.
 +
||
 +
* Delegate workload for cleaning datasets
 +
|-
 +
| <center> Determining the Most Optimal Interactive Elements </center> ||
 +
In order to enable users to understand the data sets, interactive elements needs to be suitable for this project
 +
||
 +
*Develop storyboard
 +
*Research on network graph visualization
 +
|}
 +
</div>
 +
 +
==<div style="background: #F6B419; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Trebuchet MS; "><font color= #5E2705>Project Timeline & Task Assignments</font></div>==
 +
<div style="font-size: 15px; padding-top: 15px; padding-bottom: 30px;">
 +
[[Image: projecttimeline_team12_v2.png |1020px|center]]
 +
</div>
 +
 +
==<div style="background: #F6B419; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Trebuchet MS; "><font color= #5E2705>References</font></div>==
 +
<div style="font-size: 15px; padding-top: 15px; padding-bottom: 30px; padding-left: 15px; padding-right: 15px;">
 +
*Databases: https://offshoreleaks.icij.org/pages/database
 +
*Kaggle Dataset: https://www.kaggle.com/zusmani/paradisepanamapapers/data
 +
*D3.js: https://d3js.org/
 +
*Neo4j: https://neo4j.com/
 
</div>
 
</div>
  

Revision as of 00:10, 20 November 2017

Los tres mascatero logo.png


Home

Proposal

Team

Poster

Application

Research Paper

Version 1 Version 2

Introduction & Motivation

Panama intro photo.jpg


The Panama Papers (2016) are a huge leak — 11.5 million (approximately 2.6 TB) — of financial documents that reveal the financial holdings of the rich and powerful. The global investigation into the secretive industry of offshore companies expose how politicians, celebrities, sportsmen and high-net-worth individuals set up front companies in remote jurisdictions to protect their cash from higher taxes, and facilitate bribery, arms deals, financial fraud and drug trafficking. Laying within the trove of leaked files are also the names of the rich and powerful in the Asia-Pacific (APAC) region, overshadowed by the media’s interest of more prominent names of the West.

Objectives

As news coverage, even in Singapore, was focused mainly on the West, attention is diverted from what may be more important, which are details of individuals and businesses in APAC that are also found in the leaked documents. This results in a lack of information and coverage on the APAC region.

Our goal is the shed light on the individuals and business involved in the APAC region in the following ways:

  1. To present the complexity and structure of relationships between entities and individuals in each country in the APAC region.
  2. Identify key parties in the offshore investments.

Background Survey of Related Works

Visualizations Explanation
[[Image:|550px|center]]


Data source:
[[Image:|550px|center]]


Data source:
[[Image:|550px|center]]


Data source:

Datasets

Data Source Attributes

Offshore Leaks Database by The International Consortium of Investigative Journalists

Data source: https://offshoreleaks.icij.org/pages/database

Paradise-Panama-Papers: Data Scientists United Against Corruption dataset

Data source: https://www.kaggle.com/zusmani/paradisepanamapapers/data

Tools / Libraries

  • Tableau
  • Github
  • Microsoft Excel
  • Adobe Creative Suite
  • Sketch
  • Neo4j
  • D3.js
  • Python

Technical Challenges

Key Technical Challenges Detailed Description Proposed Solution
Unfamiliar with D3.js libraries

D3.js is a JavaScript library for producing dynamic, interactive data visualizations in web browsers.

  • Go for the d3 workshop
  • Self learning
  • Peer Learning
Data Cleaning and Transformation

The data set are in text format and many other different format. Integration are challenging as there are a lot of manual work to be done.

  • Delegate workload for cleaning datasets
Determining the Most Optimal Interactive Elements

In order to enable users to understand the data sets, interactive elements needs to be suitable for this project

  • Develop storyboard
  • Research on network graph visualization

Project Timeline & Task Assignments

Projecttimeline team12 v2.png

References

Comments

Please leave comments here.


Retrieved from ‘https://wiki.smu.edu.sg/1718t1is428g1/index.php?title=1718t1is428T12&oldid=4741’