Difference between revisions of "ISSS608 2017-18 T3 Assign Vigneshwar Ramachandran Vadivel Approach"

From Visual Analytics and Applications
Jump to navigation Jump to search
(Created page with " <!------- Main Navigation Bar----> <center> {| style="background-color:#ffffff ; margin: 3px 10px 3px 10px; width="80%"| | style="font-family:Open Sans, Arial, sans-serif; fo...")
 
Line 48: Line 48:
  
 
=Tools Used=
 
=Tools Used=
For this analysis, I mainly used the following tools:
 
  
<b>Tableau</b>- for data cleaning and data visualisations
+
<li>Tableau Prep- Data cleaning and generation of nodes and edges </li>
  
<b>Gephi</b>- to create network graphs as visualisations, with the use of nodes and edges
+
<li>Gephi - Network analysis, using communication data</li>
  
<b>Tableau</b>- for other data visualizations
+
<li>Tableau - Preliminary data visualizations </li>
  
<b>Excel</b>- for initial data exploration
+
<li>Excel and Python - Initial data exploration and data cleaning </li>

Revision as of 15:12, 26 June 2018

Intro

Approach

Findings

Conclusion

Main Page

Data Cleaning

Data Organisation

Data Exploration

Data Set

The Kasios Insider has provided communication data across the company, includes call records, emails, purchases, and meetings. The data is limited to only the source, the recipient and the time of the transaction and don’t includes the content of the communication. All of the provided data files have the same format. The data are provided in comma-separated format with four columns:


  • Source (company ID# for the person who initiated the communication)
  • Etype (number designating type of connection)
  • Destination (company ID# for the person who receives communication)
  • Time stamp – Unix epoch format starts at May 11, 2015 at 14:00

Tools Used

  • Tableau Prep- Data cleaning and generation of nodes and edges
  • Gephi - Network analysis, using communication data
  • Tableau - Preliminary data visualizations
  • Excel and Python - Initial data exploration and data cleaning