QuickSight FAQ

All visual types except pivot tables offer the ability to create a hierarchy of fields to add drill downs to visual elements. Click visual -> Click Field Wells -> Drag a field to Field Wells and make sure it says “Add Drill-down layer.” You’ll notice the field active has a filled-in color while the drill-down fields are white:

QuickSight Drilldown

Lear more about Drill-downs here: https://docs.aws.amazon.com/quicksight/latest/user/adding-drill-downs.html

Or watch the video below:

QuickSight and Tableau are both great data visualization (Dashboarding) products. QuickSight was launched by AWS in 2015 and Tableau was founded in California in 2003 and acquired by Salesforce in 2019. As it was founded earlier, Tableau has an installed software heritage and only more recently develop cloud versions of the product. QuickSight is a cloud-native solution without any desktop app. Quick differences include:

Differentiators
QuickSight: Super-fast in-memory data storage and calculation engine called SPICE; Lower, usage-based pricing; Fully-SaaS so that data does not need to be managed on desktop applications making it more secure. 

Tableau: Well-established in market; Leading UI tools for designing beautiful visualizations. 

Pricing
QuickSight:

  • Individuals cost user $9 per month, $96per year.
  • Organization cost divided into 2 types.
  • Authors:The cost per user is $18 per user per month billed annually or $24 per user per month when paying month-to-month.
  • Readers: AWS describes this as pay-per-session and the cost is $.30 per session up to $5 a month per user

Tableau:
A typical Individual license costs $70 per month, $840 per year. Organization costs are divided into 3 types:

  • Tableau Creator: $3 per month per user. If add-ons are needed, additional $8.50 per month per user.
  • Tableau Explorer: $35 per user per month.
  • Tableau Viewer: $12 per month per user.

In your analysis, choose Add at top left, and then choose Add calculated field.

In the calculations editor that opens, do the following:

1.upload csv files to QuickSight,select the ‘orders’ sheet, go to edit/preview data page where your data set details appears.
2.From the top menu, choose Add data.A pop-up window appears with the option to either switch data sources or upload a new CSV to join with the current data set. The window also shown has existing source.
3.Choose Upload a file and upload the ‘returns’ CSV file.After uploading the file, you can see sheet names for both the CSVs. The following screenshot shows orders and returns.
4.Choose the two circles between the files.This step allows you to edit the join configuration between the two CSVs. In the Join configuration section, you can select the join type (inner, left, right, or full) and also select the column on which to apply the join. This post uses an inner join.
5.choose Join type, Join classes,
6.Apply

SPICE (Super-fast, Parallel, In-memory Calculation Engine) is the robust in-memory engine that Amazon QuickSight uses. It’s engineered to rapidly perform advanced calculations and serve data. If the data is not imported through SQL, the data would be transformed into SPICE format.

-Fields: After the uploading of the dataset, Click the ellipsis
(“…”), can edit the dataset by droping, renaming, changing the type of the column. Besides, the whole column could be changed with functions by clicking “Add calculation”.
-Filtering: by clicking “Edit Filter”, the dataset would left with the data that meets the desired conditions.

 

-Click “Add” on the top right of the website, and choose “Add Calculation Field”.
-Name the Calculation Field’s name.
-Type the “sum()” and include the column that you want to find the total sum.
-Save it and will see find the sum in the field list.

QuickSight visuals can be controlled by Themes in the left navigation of your Analysis.