ANLY482 AY2017-18 T2 Group15 Data Visualization Platforms
Revision as of 23:31, 14 April 2018 by Amanda.lim.2014 (talk | contribs)
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
|
THE CURRENT DASHBOARD
- Figure 3 is a snapshot of the client’s current dashboard for one of its main product brands, which was generated using their original data structure.
- This dashboard is split into two graph segments, namely the input graphs and the output graphs. The two input graphs on the left are of pre-sales data and include the distribution of brands across the various distribution channels, and the prices of their products across those channels. The four output graphs on the right are of post-sales data and include the equity and imageries of the brand as provided by customers, the awareness, penetration and usage of the brand among customers, and the sales performance plotted against the sales volume.
- This method of data visualization may not be ideal for several reasons.
- As the data was neither in Relational nor Flat Table format, it is not possible to automatically load the files into visualization platforms requires the data to be input manually, which takes unnecessary time and effort.
- The resulting visualizations are highly static and lack filter options, making it difficult for users to slice and dice, to view a specific segment of data – a function which is readily available in other visualization platforms.
- Monthly addition of new data into the dashboard will be a time-consuming process due to the manual input method required.
- This method of data visualization may not be ideal for several reasons.