Programmatic Export to Excel Using the New Snapshot APIs: 2023 Amazon QuickSight Learning Series
Recent updates to QuickSight Enterprise Edition include scheduled and programmatic export to Excel. These features aim to improve data sharing, enhance automation, and better align QuickSight with the business ecosystem that frequently depends on Excel for advanced analytics and reporting. You can now export content to Excel workbooks by selecting multiple tables and pivot table visuals from any sheet of a dashboard on the QuickSight console via schedules or programmatically via a set of new Snapshot Export APIs. This learning series focuses on the programmatic export to Excel using the new Snapshot Export APIs.
**************************************************************************************************
Sign up for our Community! https://community.amazonquicksight.com
Learning Center: https://community.amazonquicksight.co...
New Enhancements in Amazon QuickSight - Programmatic Export to Excel Format
https://aws.amazon.com/blogs/business...
Working with Paginated Reports in Amazon QuickSight
https://docs.aws.amazon.com/quicksigh...
AWS CLI Command Reference
https://awscli.amazonaws.com/v2/docum...
Automate Financial Statemenets Using Amazon QuickSight Snapshot Export APIs
https://aws.amazon.com/blogs/business...
DemoCentral Dashboard for Excel Export
https://democentral.learnquicksight.o...
Amazon QuickSight What’s New
https://aws.amazon.com/new/?whats-new...
Amazon QuickSight Paginated Reports Workshop
https://catalog.workshops.aws/quicksi...
Chapters:
00:00 Session Introduction
00:33 Agenda
01:10 Introduction to Amazon QuickSight
04:22 Paginated Reporting in the Cloud
05:31 Paginated Report Example
06:15 Three Snapshot Reporting APIs -Overview
07:46 Executing New Snapshot Export APIs
09:02 API Output Overview
09:43 Key Benefits of Exporting to Excel
10:57 API Pre-requisites
11:42 Exporting One Visual
13:12 Exporting Multiple Visuals from the Same Sheet
13:12 Exporting Multiple Visuals from Multiple Sheets
15:37 Output Delivery Options
18:08 Other Configuration Settings (tag-based or parameters)
19:20 Demo
28:36 References