Amazon QuickSight now supports joining across different data sources, which allows you to connect to multiple data sources and join data across these sources in QuickSight directly to create data sets used to build dashboards. For example, you can join transactional data in Amazon Redshift that contains customer IDs with Salesforce tables that contain customer profile data to create an interactive dashboard with order and customer details. You can then slice and dice transactional data by various customer dimensional data such as segment, geographic, or demographic without first pulling the data to a single source outside Amazon QuickSight. To learn more about cross data source joins, see here.
With this launch, you can now use relative date filters to filter by any arbitrary number of periods ahead of the current date period. You can set a constant arbitrary period or dynamically change it using controls on screen. Further, you can set a custom date (anchor date) to filter relatively from this date. To learn more about these relative date enhancements, see here.
All these features are now available in Enterprise Edition and Standard Editions in all QuickSight regions – US East (N. Virginia and Ohio), US West (Oregon), EU (Frankfurt, Ireland and London), and Asia Pacific (Seoul, Singapore, Sydney and Tokyo)