Domain 5: Visualization Flashcards
What is SPICE?
Super Fast, Parallel, In-memory, Calculation, Engine
Used for accelerating queries on large datasets
How much SPICE data is provided per user?
10GB
Is SPICE serverless?
Yes
What are QuickSight anti-patterns?
Highly formatted reports, ETL processing
What are some of QuickSight’s security options
MFA, RLS, private VPC access via Elastic Network Interface,
Can QuickSight connect to on-premises data?
Yes, via Direct Connect
How are users defined in QuickSight?
IAM, email signup, or active directory
What is the annual subscription pricing with QuickSight
Standard: $9/user/month; Enterprise: $18/user/month
How much is Extra SPICE on Quicksight?
Standard: $.25/GB/month; Enterprise: $.38/GB/month
What is the monthly subscription pricing with QuickSight?
Standard: 12; Enterprise: 24
What are the benefits of Enterprise Quicksight?
Encryption at rest, active directory integration
What are some features of QuickSight Machine Learning insights?
- Anomaly detection using RANDOM_CUT_FOREST
- Forecasting using RANDOM_CUT_FOREST; excludes outliers and imputes missing values
- Autonarratives adds stories of data to dashboards
- “Insights” tab with automated visualizations
What are bar charts used for?
Comparison and distribution (histograms)
What are line graphs used for?
Changes over time
What are Scatter plots, heat maps used for?
Correlation