Effective Business Intelligence with QuickSight

Enriching your data

One of the exciting features of SPICE is the ability to transform data and also create additional derived fields. Let's look at this feature with an example; follow these steps to add a new derived field to the dataset we just created:

1. From the QuickSight home page, click on Manage data.
2. Select the usasalarybyzipandcity that was created in the previous Joining data in SPICE section and then click on Edit data set.
3. Select New Field and then follow the wizard on the right to create a new derived field.
4. In this example, we are going to use the toUppper function in the formula and convert the statement name to uppercase.
   

   Figure 3.10: ...