Setup Quicksight

Setup QuickSight

  1. Open the QuickSight Console.
  2. Choose Sign up for QuickSight.
  3. Choose Standard edition.
  4. Choose Continue.
Create your QuickSight account
  1. Choose a region, where you deployed resources with Amplify, e.g. US West (Oregon)
  2. Set QuickSight account name, e.g. traveldeals
  3. Set Notification email address.
  4. Check Amazon Athena box.
  5. Check Amazon S3 box.
  6. Select Choose S3 bucket.
    1. Select the bucket, which was set as a destination for Kinesis Delivery Stream, e.g.: traveldeals-12142020-kdf
    2. Choose Finish.
  7. Choose Finish.
Create a new QuickSight account

After account is created, choose Go to Amazon QuickSight:

Account creation complete

Add Dataset

  1. In the navigation pane, choose Datasets
  2. Choose New dataset.
List of Datasets
Create a Data Set
  • Select Athena as a data source.
List of available data source types
New Athena data source
  1. Set Data source name, e.g. traveldeals-datasource
  2. (optional) Choose Validate connection to validate connection.
  3. Choose Create data source.
Configure a new Athena data source
Choose your table
  1. Choose created database, e.g. traveldealsdb
  2. Choose created table, e.g. dealviews
  3. Choose Select.
Choose a table
Finish data set creation
  • Choose Visualize.
Finish data set creation

Creat QuickSight Dashboard

Let’s record some events to show them on Dashboard later. In your Web Application you can log in as different users and perform different actions on their behalf:

  • Browse Deals and open individual Deals
  • Open Deals from recommended section
  • Copy URL and open deal by URL

Glue crawler was set up to run On Demand. As soon as you are done with generating events, run a Glue Crawler from Glue Console, as was described in Run Glue Crawler section. In production environment you can set up Time-Based Schedules for Jobs and Crawlers.

Now we are ready to create visualizations.

Count of Deals by Category

  1. For Visual Types, choose Pie Chart.
  2. Set Group/Color to itemcategory
  3. Set Value to itemid
Count of Deals by Category visualization

Count of Event records by Deal name and Pageview origin

  1. Choose + Add top menu item.
  2. Choose Add visual.
  3. Under Visual Types, choose Vertical stacked bar chart.
  4. Set X axis to itemname
  5. Set Group/Color to pagevieworigin
Count of Event records by Deal name and Pageview origin visualization

Count of Deals by Timestamp and Pageview origin

  1. Choose + Add top menu item.
  2. Choose Add visual.
  3. Under Visual Types, choose Line chart.
  4. Set Group/Color to pagevieworigin
  5. Set X axis to timestamp
  6. Under context menu for timestamp, set Aggregate to minute
Count of Deals by Timestamp and Pageview origin visualization

Count of Events by Pageview origin and Userid

  1. Choose + Add top menu item.
  2. Choose Add visual.
  3. Under Visual Types, choose Vertical stacked bar chart.
  4. Set X axis to userid
  5. Set Group/Color to pagevieworigin
Count of Events by Pageview origin and Userid visualization

Complete Dashboard

Complete dashboard with all visuals