Tutorial: Create a Prepared Data Set - Amazon QuickSight

Tutorial: Create a Prepared Data Set

Use the following procedure to prepare the Marketing data set and create an analysis. If you don't see the Web and Social Media Analytics sample data already in Amazon QuickSight, you can download it: web-and-social-analytics.csv.zip.

  1. On the Amazon QuickSight start page, choose Manage data.

  2. On the Your data sets page, choose New data set.

  3. In the FROM EXISTING DATA SOURCES section of the Create a Data Set page, choose the Web and Social Media Analytics Amazon S3 data source and then choose Edit/Preview data.

    Amazon QuickSight opens the data preparation page.

  4. Name the data set.

    Highlight Group 1 in the data set name box, and type Marketing Sample.

  5. Change the field selection to remove some fields we won't be working with.

    In the Fields pane, unselect the Twitter followers cumulative and Mailing list cumulative fields.

  6. Rename a field.

    In the data preview pane, scroll to the Website Pageviews field and choose the edit icon.

    Highlight the field name, type Website page views, and then choose Apply.

  7. Add a calculated field that substitutes a text string for any 0-length string value in the Events field.

    1. On the data preparation page, expand the Fields pane, and then choose New Field.

    2. In the New calculated field pane, highlight the value in Calculated field name, and then type populated_event.

    3. Choose the ifelse function from the Function list and then choose Add. This adds the function to the calculated field formula.

    4. Scroll down in the Field list, choose the Events field, and then choose Add. This adds the field to the calculated field formula.

    5. In Formula, type the additional functions and parameters required, highlighted following:

    6. Choose Create.

      The new calculated field is created, and appears in the Calculated fields section at the top of the Fields pane.

  8. Choose Save.

Next Steps

Create an analysis by using the procedure in Tutorial: Create an Analysis.