Difference between revisions of "IS428 AY2019-20T1 Assign Chua Xuan Ni, Rachel DATA TRANSFORMATION"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 30: Line 30:
 
== Dataset Analysis & Transformation Process ==
 
== Dataset Analysis & Transformation Process ==
  
−
'''Issue 1:'''
+
{| class="wikitable"
−
<br><br>
+
|-
−
In the current dataset, “mc1-reports-data.csv”. The different categories of damage are a column by itself, making it difficult to compare the damage by the categories.
+
! Issue !! Solution !! Resolution
−
<br><br>
+
|-
−
Solution: Pivot the different categories of damage – sewer_and_water, power, roads_and_bridges, medical and buildings into a new column, “Damage Area”, with their respective damage level in a new column, “Damage Level (0-10)”.
+
| In the current dataset, “mc1-reports-data.csv”. The different categories of damage are a column by itself, making it difficult to compare the damage by the categories. || Pivot the different categories of damage – sewer_and_water, power, roads_and_bridges, medical and buildings into a new column, “Damage Area”, with their respective damage level in a new column, “Damage Level (0-10)”. || To do this, I used Tableau Prep’s “Pivot function” to make the changes. After applying the pivot function, you can see that I now have 2 new columns containing the data from sewer_and_water, power, roads_and_bridges, medical and buildings merged as one.
−
<br><br>
+
|-
−
To do this, I used Tableau Prep’s “Pivot function” to make the changes. After applying the pivot function, you can see that I now have 2 new columns containing the data from sewer_and_water, power, roads_and_bridges, medical and buildings merged as one.
+
| Example || Example || Example
 +
|-
 +
| Example || Example || Example
 +
|-
 +
| Example || Example || Example
 +
|-
 +
| Example || Example || Example
 +
|}
  
 
== Dataset Import Structure & Process ==
 
== Dataset Import Structure & Process ==

Revision as of 19:18, 11 October 2019

MC1-2019.jpg IS428 VAST 2019 Mini Challenge 1

PROBLEM & MOTIVATION

DATA TRANSFORMATION

INTERACTIVE VISUALIZATION

DASHBOARDS

TASK & QUESTION

 

Dataset Analysis & Transformation Process

Issue Solution Resolution
In the current dataset, “mc1-reports-data.csv”. The different categories of damage are a column by itself, making it difficult to compare the damage by the categories. Pivot the different categories of damage – sewer_and_water, power, roads_and_bridges, medical and buildings into a new column, “Damage Area”, with their respective damage level in a new column, “Damage Level (0-10)”. To do this, I used Tableau Prep’s “Pivot function” to make the changes. After applying the pivot function, you can see that I now have 2 new columns containing the data from sewer_and_water, power, roads_and_bridges, medical and buildings merged as one.
Example Example Example
Example Example Example
Example Example Example
Example Example Example

Dataset Import Structure & Process

Retrieved from ‘https://wiki.smu.edu.sg/1920t1is428g1/index.php?title=IS428_AY2019-20T1_Assign_Chua_Xuan_Ni,_Rachel_DATA_TRANSFORMATION&oldid=2727’