Difference between revisions of "ANLY482 AY2017-18 T2 Group15 Data Analysis"
Jump to navigation
Jump to search
| Line 31: | Line 31: | ||
::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. | ::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: | + | ::::::::::::::::Figure 1: Format of sales data before cleaning |
| + | [[File:RawSales.jpg|center|400px|Figure 1: Format of sales data before cleaning]] | ||
Revision as of 19:03, 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.
- Figure 1: Format of sales data before cleaning
