Difference between revisions of "ANLY482 AY2017-18 T2 Group15 Data Analysis"
Jump to navigation
Jump to search
| Line 29: | Line 29: | ||
<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. | ||
| + | |||
| + | [[File:example.jpg|thumb|caption]] | ||
Revision as of 18:52, 24 February 2018
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.
