Amazon QuickSight November 2018 Update
Released on November 27th, 2018
Support for Top N Filters, Cascading Parameter Controls, and JSON Parsing
Amazon QuickSight now allows you to create Top N and Bottom N filters to see the highest or lowest performers on a given metric. This feature allows dashboard authors to create charts, tables, and other visualizations that will dynamically show only the top or bottom N members of a dimension regardless of how many members there are or how frequently they may change. The Top N and Bottom N options can be used with text, date, and numeric filters. See here to learn more.
QuickSight now also allows you to configure on-screen parameter controls to only display relevant options based on choices made by the user. The user’s selections on a parameter control cascades to filter out irrelevant options in subsequent linked controls, providing an intuitive and guided experience for the end user. See here to learn more.
Lastly, you can now parse JSON objects while reading data into QuickSight. JSON parsing allows you to create columns in a data set with values derived from key-value pairs within the JSON object. See here to learn more.
These features are now available in all QuickSight regions - US East (N. Virginia and Ohio), US West (Oregon), EU (Ireland), and Asia Pacific (Singapore, Sydney, and Tokyo).
Support for Dashboard Embedding and APIs
Amazon QuickSight dashboards can now be embedded in applications. As an application developer, you can now create rich, interactive dashboards in QuickSight and embed them into your application portals and websites, without having to investigate charting libraries, add specialized analytics know-how to their teams, or set up, manage and optimize servers to scale to your growing userbase.
Embedded dashboards extend QuickSight’s serverless architecture to scale your insights to all your users while ensuring that you only pay for usage with QuickSight’s unique pay-per-session pricing model. Viewers of embedded dashboards are authenticated via Federated Single Sign-On (SAML, OpenID Connect or AWS IAM Federation), ensuring that every user receives a secure, personalized dashboard, while requiring no user-facing QuickSight-specific authentication.
Dashboard embedding is available in Amazon QuickSight Enterprise Edition in all QuickSight regions - US East (N. Virginia and Ohio), US West (Oregon), EU (Ireland), and Asia Pacific (Singapore, Sydney, and Tokyo). User APIs are available for both Standard and Enterprise Editions; group APIs are available in Enterprise Edition.
Introducing ML Insights (Preview)
Amazon announced the preview availability of ML Insights for Amazon QuickSight. ML Insights allows customers to discover hidden trends and outliers, identify key business drivers, forecast future results, and summarize their data in easy-to-understand, natural language narratives, without spending countless hours on manual analysis and investigation. With ML-powered anomaly detection, customers can continuously analyze their data across billions of data points to uncover hidden insights that are often buried in aggregates, not visible in plain sight, and are not scalable with manual analysis. With ML-powered forecasting, non-technical business users can now predict their key business metrics with point and click simplicity. Auto-narratives functionality was also announced, a new feature that automatically delivers insights in plain language, embedded contextually in the dashboard, allowing customers to create a shared understanding of data across the organization, without interpreting complex visualizations. You don't need any ML, excel modeling, or domain expertise to use these features.