Step 8 - QuickSight

AmazonQuickSight

EcommCo’s Data Lake leverages AWS QuickSight for visualizations of published data. QuickSight presents compelling data stories that are consumable by business users.

The diagram below illustrates QuickSight dashboards, which tell compelling data stories to ECommCo’s business users

a. Publish Data to Published Data S3 Bucket

{% include 'error_box.html' %}

When you click this button, the following steps will be performed within your AWS account:

  • Curated Datasets derived from Analytics are copied from Redshift to Published Data S3 Bucket
  • Manifest files, which serve for registration of the Data Source in Amazon QuickSight are generated and copied to Published Data S3 Bucket

b. Create visualizations

  1. In order to develop QuickSight dashboards, you will need to create a QuickSight account (note: this is different from your AWS IAM account). Please follow instructions described here.
  2. Allow QuickSight to access the Published Data S3 Bucket {{ published_bucket_name }} in the QuickSight UI here.
  3. Follow the steps described below to create the following dashboards.

Product category dataset consists of records with columns: product_category, orders_count
Use the following procedure to create visualization from it:

  1. Create an analysis from published data in S3 using instructions from here.
    Manifest file was generated for you and is available in S3:
    https://s3.amazonaws.com/{{ published_bucket_name }}/products/manifest/product_category_distribution.mf
  2. Create Pie chart visual with product_category as Value and orders_count as Group/Color
  3. The result should look like this:

Spend distribution dataset consists of records with columns: customer_id, spend, marital_status, education_level
Use the following procedure to create visualization from it:

  1. Create an analysis from published data in S3 using instructions from here.
    Manifest file was generated for you and is available in S3:
    https://s3.amazonaws.com/{{ published_bucket_name }}/spend/manifest/spend_distribution.mf
  2. Create Vertical Bar Chart visual with spend as Value and any other column as X axis.
  3. Change aggregation method from SUM to AVERAGE on spend column using instructions from here.
  4. The result should look like this:

Customer lifetime value dataset consists of records with columns: segment, segment_spend
Use the following procedure to create visualization from it:

  1. Create an analysis from published data in S3 using instructions from here.
    Manifest file was generated for you and is available in S3:
    https://s3.amazonaws.com/{{ published_bucket_name }}/customer/manifest/customer_lifetime_value.mf
  2. Create Vertical Bar Chart visual with segment_spend as Value and segment as X axis.
  3. The result should look like this:

SKU distribution dataset consists of records with columns: product_category, sku, sku_count
Use the following procedure to create visualization from it:

  1. Create an analysis from published data in S3 using instructions from here.
    Manifest file was generated for you and is available in S3:
    https://s3.amazonaws.com/{{ published_bucket_name }}/sku/manifest/sku_distribution.mf
  2. Create Vertical Stacked Bar Chart visual with product_category as X axis, sku_count as Value and sku as Group/Color.
  3. The result should look like this:

State population dataset consists of records with columns: state, population
Use the following procedure to create visualization from it:

  1. Create an analysis from published data in S3 using instructions from here.
    Manifest file was generated for you and is available in S3:
    https://s3.amazonaws.com/{{ published_bucket_name }}/state/manifest/state_population.mf
  2. Create Horizontal Bar Chart visual with state as Y axis and population as Value.
  3. The result should look like this:

Orders by month dataset consists of records with columns: month_date, married_orders, single_orders, total_orders
Use the following procedure to create visualization from it:

  1. Create an analysis from published data in S3 using instructions from here.
    Manifest file was generated for you and is available in S3:
    https://s3.amazonaws.com/{{ published_bucket_name }}/orders/manifest/orders_by_month.mf
  2. Create Line Chart visual with month_date as X axis and married_orders, single_orders as Values.
  3. Change aggregation on X axis to MONTH using instructions from here.
  4. The result should look like this: