Quick Start: Create an Analysis with a Single Visual Using Sample Data - Amazon QuickSight

Quick Start: Create an Analysis with a Single Visual Using Sample Data

Use the following procedure to use the Web and Social Media Analytics sample data set to create an analysis containing a line chart visual. This visual shows the count by month of people that have added themselves to the mailing list.

  1. On the Amazon QuickSight start page, choose New analysis. If you don't have the sample data, you can download it here: web-and-social-analytics.csv.zip. Unzip the file so you can use the .CSV file.

    To upload the sample data, use the following steps:

    1. Choose New dataset from the New analysis screen. (Or, choose Datasets at left, and then choose New dataset.)

    2. Choose Upload a file.

    3. Choose the sample file, web-and-social-analytics.csv, from your drive. If you don't see it, check that you unzipped the web-and-social-analytics.csv.zip file.

    4. Confirm file upload settings by choosing Next on the Confirm file upload settings screen.

    5. Choose Visualize on the Data source details screen.

    6. Skip the next step. Choosing Visualize brings you to the same screen as the process in Step 2.

  2. On the Datasets page, choose the Web and Social Media Analytics data set, and then choose Create Analysis.

  3. In the Fields list pane, choose Date, and then choose Mailing list adds.

    Amazon QuickSight uses AutoGraph to create the visual, selecting the visual type that it determines is most compatible with those fields. In this case, it selects a line chart that shows mailing list adds by day, which is the date granularity default.

  4. Expand the Field wells pane by choosing the expand icon.

  5. Choose the X axis field well, choose Aggregate, and then choose Month.

    The line chart updates to show mailing list adds by month, rather than by the default of by year.