Posted On: May 5, 2023
We are introducing a new kind of parameter in Amazon QuickSight that will help users create interactive experiences in their dashboards. With Dataset Parameters, authors can optimize the experience and load time of dashboards that are connected-live to external SQL-based sources. When readers interact with their data, the selection and actions they make in controls, filters and visuals can be propagated to the data sources via live, custom, parameterized SQL queries. By mapping multiple Dataset Parameters to Analysis parameters, users can create a wide variety of experiences using controls, user actions, parameterized URLs, and calculated fields, as well as create dynamic visuals’ titles, descriptions, bookmarks, emails and PDF reports.
This feature is sought after by many enterprise BI teams who are looking for cloud modernization and migration of their legacy reports. BI developers can now reduce the migration effort of legacy reports that have parameterized SQL queries. Now, these SQL queries can be passed along their parameters to QuickSight datasets via automations. BI teams can benefit from Dataset Parameters and reuse datasets to analyze different slices of the same data such as different regions, products, or customers by industry segments.
Dataset Parameters are now available in Amazon QuickSight Enterprise and Standard Editions in all QuickSight regions - US East (N. Virginia and Ohio), US West (Oregon), Canada, Sao Paulo, Europe (Frankfurt, Ireland and London), Asia Pacific (Mumbai, Seoul, Singapore, Sydney and Tokyo), and the AWS GovCloud (US-West).
For further details, visit here.