Difference between revisions of "ANLY482 AY2017-18 T2 Group15 Data Visualization Platforms"
Jump to navigation
Jump to search
Line 55: | Line 55: | ||
|style="vertical-align:top;width:34%;" | <div style="background: #ffebba; padding: 12px; font-weight: bold; text-align:center; line-height: wrap_content; text-indent: 15px; border-left: #ffcc16 solid 10px; font-size:15px; font-family:helvetica"><font color= #3f3d3d>EXCEL</font></div> | |style="vertical-align:top;width:34%;" | <div style="background: #ffebba; padding: 12px; font-weight: bold; text-align:center; line-height: wrap_content; text-indent: 15px; border-left: #ffcc16 solid 10px; font-size:15px; font-family:helvetica"><font color= #3f3d3d>EXCEL</font></div> | ||
<br/> | <br/> | ||
− | + | ::Microsoft Excel has been the most widely used data and spreadsheet modelling tool since its creation. Its interface and functions are familiar to most users including our client, hence it is one of our recommended dashboard tools. | |
− | + | ||
|style="vertical-align:top;width:34%;" | <div style="background: #ffebba; padding: 12px; font-weight: bold; text-align:center; line-height: wrap_content; text-indent: 15px; font-size:15px; font-family:helvetica"><font color= #3f3d3d>QLIK</font></div> | |style="vertical-align:top;width:34%;" | <div style="background: #ffebba; padding: 12px; font-weight: bold; text-align:center; line-height: wrap_content; text-indent: 15px; font-size:15px; font-family:helvetica"><font color= #3f3d3d>QLIK</font></div> | ||
<br/> | <br/> | ||
− | + | ::Our second recommendation for a visualization tool is Qlik Sense. Qlik ranks as one of the top data visualization platforms and a choice solution for many large Multinational Corporations (MNCs), offering improved aesthetics and more user-friendly design processes than primitive visualization software. | |
− | + | ||
|style="vertical-align:top;width:34%;" | <div style="background: #ffebba; padding: 12px; font-weight: bold; text-align:center; line-height: wrap_content; text-indent: 15px; border-right: #ffcc16 solid 10px; font-size:15px; font-family:helvetica"><font color= #3f3d3d>TABLEAU</font></div> | |style="vertical-align:top;width:34%;" | <div style="background: #ffebba; padding: 12px; font-weight: bold; text-align:center; line-height: wrap_content; text-indent: 15px; border-right: #ffcc16 solid 10px; font-size:15px; font-family:helvetica"><font color= #3f3d3d>TABLEAU</font></div> | ||
<br/> | <br/> | ||
− | + | ::Tableau is a popular beginner-friendly visualization software which is similar to Qlik but holds additional advantages for our client. | |
− | |||
|} | |} | ||
Line 70: | Line 69: | ||
<br/> | <br/> | ||
<div align="left"> | <div align="left"> | ||
− | <div style="background: #ffebba; padding: 12px;font-family:Helvetica; font-size: 15px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #ffcc16 solid 10px; border-right: #ffcc16 solid 10px; text-align:center "><font color="#3f3d3d"> | + | <div style="background: #ffebba; padding: 12px;font-family:Helvetica; font-size: 15px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #ffcc16 solid 10px; border-right: #ffcc16 solid 10px; text-align:center "><font color="#3f3d3d">EXCEL PIVOT TABLE</font></div> |
<br/> | <br/> |
Revision as of 14:15, 14 April 2018
DATA VISUALIZATION PLATFORMS USED
- Using the data which had been reformatted into Flat Table format, dashboards were created using three data visualization platforms - Excel Pivot Tables, Qlik Sense and Tableau. These platforms were chosen as they were suitable for the client's needs.
- All charts presented in this wikipage have been created using randomised substitute data to protect our client's confidentiality.
EXCEL
|
QLIK
|
TABLEAU
|
EXCEL PIVOT TABLE