Difference between revisions of "ANLY482 AY2017-18 T2 Group15 Data Visualization Platforms"

From Analytics Practicum
Jump to navigation Jump to search
(Created page with " <font face="Helvetica"> {| style="background-color:#FFFFFF; color:#ffcc16 padding: 5px 0 0 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | | style...")
 
Line 44: Line 44:
 
<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">DATA CLEANING</font></div>
 
<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">DATA CLEANING</font></div>
 
<br/>
 
<br/>
−
::To create a dashboard for Company X on Tableau and Qlik Sense, the team had to clean and check the data for consistency. Initially, the data was not in relational format and there were null and negative values. For example, the sales data was given to us in the format as shown in Figure 1. Since the data needs to be in relational format for Tableau and Qlik Sense to generate dashboards, we changed the format by transposing the data in excel. The format of the sales data was thus changed, as seen in Figure 2.  
+
::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.  
  
−
::::::::::::::::Figure 1: Format of sales data before cleaning
+
:: All charts presented in this wikipage has been created using randomised substitute data to protect our client's confidentiality.
−
[[File:RawSales.jpg|center|400px|Figure 1: Format of sales data before cleaning]]
+
 
 +
[[File:DVlogos.png|center|500px|Data Visualization Platforms Used]]
 
<br/>
 
<br/>
−
::::::::::::::::Figure 2: Format of sales data after cleaning
 
−
[[File:CleanSales.jpg|center|400px|Figure 2: Format of sales data after cleaning]]
 

Revision as of 23:23, 10 April 2018

HOME

PROJECT OVERVIEW

DATA ANALYSIS

DOCUMENTATION

REFLECTION

ABOUT US

BACK TO MAIN ANLY82


 

DATA CLEANING


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 has been created using randomised substitute data to protect our client's confidentiality.
Data Visualization Platforms Used
Retrieved from ‘https://wiki.smu.edu.sg/ANLY482/index.php?title=ANLY482_AY2017-18_T2_Group15_Data_Visualization_Platforms&oldid=22953’