ANLY482 AY2017-18 T2 Group15 Data Structures
Revision as of 22:39, 10 April 2018 by Amanda.lim.2014 (talk | contribs) (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...")
DATA CLEANING
- 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.
- Figure 1: Format of sales data before cleaning
- Figure 2: Format of sales data after cleaning