Difference between revisions of "ISSS608 2017-18 T3 Assign Jyoti Bukkapatil Methodology & Dashboard Design"
Line 23: | Line 23: | ||
<center style="font-size:13px;"> <u> Figure 3</u> </center> | <center style="font-size:13px;"> <u> Figure 3</u> </center> | ||
</div> | </div> | ||
+ | |||
+ | Hourly Time series was created to with single vertical axis. This was later added to the tooltip of the calendar view. Below is the combined hourly graph for all four transactions. | ||
+ | |||
+ | [[Image:ISSS608_2018_Jyoti_Bukkapatil_Methodology_4.jpg|600px|center|border]] | ||
+ | <center style="font-size:13px;"> <u>Figure 4</u> </center> | ||
+ | |||
+ | To make the above plot, the fields added to Tableau rows and columns and the filters applied are shown below: | ||
+ | <div style="float:left;;width:60%;"><br/><br/> | ||
+ | [[Image:ISSS608_2018_Jyoti_Bukkapatil_Methodology_5.jpg|500px|center|border]]<br/> | ||
+ | <center style="font-size:13px;"> <u>Figure 2</u> </center> | ||
+ | </div> | ||
+ | <div style="float:left;;width:40%;> | ||
+ | [[Image:ISSS608_2018_Jyoti_Bukkapatil_Methodology_6.jpg|150px|center|border]]<br/> | ||
+ | <center style="font-size:13px;"> <u> Figure 3</u> </center> | ||
+ | </div> | ||
+ | |||
+ | |||
+ | Tooltip filter in Figer 6 is automatically generated tooltip because this graph is used in the tooltip of the calendar view. |
Revision as of 10:06, 8 July 2018
Tools Used
I have used below four tools for data analysis and visualization.
- JMP Pro 13 - Used for Data Preparation
- Tableau 2018.1 - Used to create a Calendar View and Timer Series Graph for All transactions in company
- Gephi 0.9.2 - Used to create Network Graph
- Microsoft Excel - Used to map Employee ID with Name
Methodology
- Time Series Graph :
Time series graph was created for four big data files to visualize monthly and hourly pattern of the company's communication and purchase habits. I have used Tableau to create time series patterns. To make the above plot, the fields added to Tableau rows and columns and the filters applied are shown below:
Hourly Time series was created to with single vertical axis. This was later added to the tooltip of the calendar view. Below is the combined hourly graph for all four transactions.
To make the above plot, the fields added to Tableau rows and columns and the filters applied are shown below:
Tooltip filter in Figer 6 is automatically generated tooltip because this graph is used in the tooltip of the calendar view.