From Visual Analytics for Business Intelligence
Jump to navigation
Jump to search
IS428 VAST 2019 Mini Challenge 1
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