ISSS608 2017-18 T3 Assign Vigneshwar Ramachandran Vadivel Approach

From Visual Analytics and Applications
Jump to navigation Jump to search
MC3 Banner.png

Intro

Approach

Findings

Conclusion

Main Page

Data Cleaning

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.

A1 MC3 Data Table.PNG

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)
    • 0 is for calls
    • 1 is for emails
    • 2 is for purchases
    • 3 is for meetings
  • 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