New — Create and Share Operational Reports at Scale with Amazon QuickSight Paginated Reports

海外精选
re:Invent
Amazon QuickSight
海外精选的内容汇集了全球优质的亚马逊云科技相关技术内容。同时,内容中提到的“AWS” 是 “Amazon Web Services” 的缩写,在此网站不作为商标展示。
0
0
{"value":"There are various ways to report on data insights, and paginated reports is one of them. Paginated reports are essential documents that contain critical business information for end-users. For decades, paginated reports have been the standard business reporting format. The following are examples of paginated reports. On the left shows the report for income statement and on the right is the yearly summary corporate statement:\n\n![image.png](https://dev-media.amazoncloud.cn/57972e30a399494d998a47204821cbbd_image.png)\n\nAs the example shows, paginated reports contain various highly formatted insights and are designed to be printable, in landscape or portrait orientation, so they can be consumed easily by readers. It’s called paginated because it often spans tens of hundreds of pages of data.\n\nAlthough it may appear to be a simple task, generating paginated reports is heavily dependent on legacy data warehouses and legacy business intelligence tools, especially because modern business intelligence tools do not offer this capability. As a result, organizations typically have to maintain multiple business intelligence systems to have separate solutions for building critical operational reports and summarized dashboards. Each solution presents its set of challenges with data governance, security, and access management. This caused a disjointed experience for both authors and end users. Legacy BI systems also run on-premises infrastructure, which is expensive to maintain and upgrade.\n\n**++Introducing Amazon QuickSight Paginated Reports++**\nToday, I’m pleased to announce [Amazon QuickSight Paginated Reports](https://aws.amazon.com/quicksight/paginated-reports/). This feature allows customers to create and share highly formatted, personalized reports containing business-critical data to hundreds of thousands of end-users without any infrastructure setup or maintenance, up-front licensing, or long-term commitments.\n\nHere’s a quick look on how Amazon QuickSight Paginated Reports works:\n\n![quicklook.gif](https://dev-media.amazoncloud.cn/af8ffeccc0a143f4bd2ea0fda54df9a1_quicklook.gif)\n\nWith Amazon QuickSight Paginated Reports, customers can now create and share paginated reports to their users from the same familiar QuickSight interface that they use to create and consume interactive dashboards. They can use one single BI service to create and deliver interactive analytics in dashboards, format reports with paginated reports, or embed analytics in apps while also allowing end users to ask questions of the underlying data using machine learning (ML) powered natural language query with QuickSight Q. From ML powered interactive dashboard to generating and distributing operational reports, these benefits impact different stakeholder groups in an organization\n\n**For Readers** – Amazon QuickSight Paginated Reports makes it easy for readers to consume reports in a familiar and scheduled fashion, in highly formatted models in .pdf or .csv formats. Readers can access these reports via email, Amazon QuickSight web and mobile interfaces, mobile applications, or embedded portals.\n\n**For Authors** – This feature gives report authors the flexibility to create highly formatted reports with images, texts, charts, tables, and exact page sizes. They can create reports from the same data models as dashboards, reusing data models built up, using access permissions (RLS/CLS) setup, and publishing in the same dashboards where their users look for data. These dashboards are also available via API, allowing migration between accounts or programmatic creation and migration of these assets as needed.\n\nThe Amazon QuickSight Paginated Reports makes it easy to build reports without the need for separate training or investment in a dedicated application. With an easy-to-use web-based authoring interface, this feature allows report authors to create complex data models in the form of operational reports for hundreds of thousands of report readers and enables data-driven decision-making.\n\n**For IT Leaders** – This feature also provides IT leaders with benefits such as fully managed reporting capabilities consolidated within Amazon QuickSight. This reduces the time and resources required to set up and maintain reporting solutions, helping IT leaders to start looking at the cloud for their BI needs and transitioning legacy reporting to the cloud to save time and resources.\n\nAmazon QuickSight Paginated Reports also leverages existing QuickSight capabilities, such as user management, data preparation, advanced scheduling and audit logging. By inheriting the capabilities from QuickSight, it removes the need to manage any infrastructure or provisioning setup to deliver reports to hundreds of thousands of users.\n\n**++Get Started with Amazon QuickSight Paginated Reports++**\nLet’s see how to get started with Amazon QuickSight Paginated Reports. I will focus more on how authors can create, publish and deliver reports to readers.\n\n**For Authors: Creating a Report**\nFirst, I open the QuickSight console. Then, in the navigation section, I select the dataset that I will use for reporting purposes. \n\n![image.png](https://dev-media.amazoncloud.cn/83200d7e78754700b5161a6b45026139_image.png)\n\nAfter I check and confirm the dataset, I select Use in Analysis.\n\n![image.png](https://dev-media.amazoncloud.cn/ad122e439c8a4057a98c0324c48a7928_image.png)\n\nOn the next page, I have the option to select the sheet type, **Interactive sheet**, or **Paginated report**. I select **Paginated report**, and here I can configure the report for Paper size and either **Portrait** or **Landscape** orientation.\n\n![image.png](https://dev-media.amazoncloud.cn/456ee055971e4cc18b9224e9b5309368_image.png)\n\nNow I’m starting my report creation. The sheet area I can use is adjusted to the paper size option I defined in the previous step. In this reporting sheet, QuickSight provides me with **Header** and **Footer** areas.\n\n![image.png](https://dev-media.amazoncloud.cn/f5ecca6a614543bebac332b85f70e774_image.png)\n\nFirst, I want to add the title of this report in the header section. I select the Header area, and in the menu section, I select **Add text**.\n\n![image.png](https://dev-media.amazoncloud.cn/8c8fced1dbc246059477f25c20eceeae_image.png)\n\nNow, I can start entering the title of the report. I name this report “**Attendance Statistics**” and customize the header using the company logo. I can also use the text toolbar to format the text and add page numbers. For any changes I’ve made, I can also see the preview directly on this page.\n\n![image.png](https://dev-media.amazoncloud.cn/977900f2301c429488aa8e9a1261aa27_image.png)\n\nI can also add other visuals in any section by selecting **Add visual**.\n\n![image.png](https://dev-media.amazoncloud.cn/b6d5dc2201274d6dac1e665cc2e88695_image.png)\n\nFrom here, I can start building reports with the available visuals, just like I normally do on the Amazon QuickSight dashboard. For example, if I need to add a summary to the pie chart, I can add another text box and drag and drop to set the layout and resize the visuals as needed.\n\n![image.png](https://dev-media.amazoncloud.cn/d5a5770453474ee8b01ece5898db4d5a_image.png)\n\nIf I need to add another section, from the menu, I select **Add section**, and I can add other visuals or insights into this new section. As for visual tabular data, the visual will be generated across pages.\n\n![image.png](https://dev-media.amazoncloud.cn/61859a51bcce4ccbab456ebe94ffb1dc_image.png)\n\n**++For Author: Publish and Schedule Report++**\nOnce the analysis is completed, I need to publish this analysis as a dashboard by selecting **Share** and then **Publish dashboard**. Then I can choose to create a new dashboard by selecting **Publish new dashboard** or **Replace an existing dashboard**. I can also select the sheet(s) I want to publish.\n\n![image.png](https://dev-media.amazoncloud.cn/df105b80f87a495aa384aee446e186a5_image.png)\n\nAt this stage, I’m ready to set a schedule to deliver my reports to readers. To do that, I need to open the dashboard and define a schedule by selecting **Add schedule**.\n\n![image.png](https://dev-media.amazoncloud.cn/2f157067fa584bf3a6d26aff06129543_image.png)\n\nIn this menu, I can specify the schedule name and also the content format. In the **Content section**, I can choose either **PDF** or **CSV** format. For PDF format, I can select the sheet I want to use. For CSV format, I can select multiple visuals.\n\n![image.png](https://dev-media.amazoncloud.cn/24b2a342c6e74679ac1d3ee3a8bbfc89_image.png)\n\n\nAs for the delivery report schedule, I can define the schedule as **Daily, Weekly, Monthly**, or one-time delivery with **Do not repeat**. I can also specify the date and time of delivery, including the time zone.\n\n![image.png](https://dev-media.amazoncloud.cn/882be1e15b124e66b38467f291927471_image.png)\n\nThen, I specify the configuration of the email message. In the final section, I can also specify how readers access this report, by using **Download link** or **File attachment**. Once I’m done setting up the schedule, I can **Save** it or send this report according to the schedule by selecting **Save and run now**.\n\n![image.png](https://dev-media.amazoncloud.cn/9927d2d6cd4f493699d977da6da5cffb_image.png)\n\n**For Readers: Receiving and Accessing Reports**\nHere is an example email from the schedule that QuickSight has sent to me as a reader. I can download this report from the email attachment or from the dashboard. \n\n![image.png](https://dev-media.amazoncloud.cn/7320a15059b24381a9553c0987e925d0_image.png)\n\nI can also use the provided link in the email to view recent snapshots. The **Recent Snapshots** feature allows me to review previously generated reports.\n\n![image.png](https://dev-media.amazoncloud.cn/02f81eb48c564e14a54e0d232e0a42df_image.png)\n\n\n**Things to Know**\n**Programmatic API Access** – In addition to using the Amazon QuickSight console, customers can also use the Amazon Web Services API and SDK to interact programmatically with Amazon QuickSight Paginated Reports.\n\n**Amazon Web Services Partners** – To make it easier for customers to migrate their legacy BI solutions to Amazon QuickSight, customers can work with Amazon Web Services partners, Ironside Consulting and Data Terrain. Ironside and Data Terrain offerings are available in the Amazon Web Services Marketplace, with more details at [Amazon QuickSight Partners](https://aws.amazon.com/quicksight/partners/) page.\n\n**Availability and Pricing** – Amazon QuickSight Paginated Reports is available as an add-on to the existing Amazon QuickSight Enterprise or Enterprise enabled with Q in all supported Amazon Web Services Regions.\n\nVisit the [Amazon QuickSight Paginated Reports page](https://aws.amazon.com/quicksight/paginated-reports/) to learn more details on how to use this feature, learn how to get started, and understand the pricing.\n\nHappy building!\n— [Donnie](https://donnie.id/)\n\n![image.png](https://dev-media.amazoncloud.cn/fe1837a2f03c40599658edcdb76912dd_image.png)\n\nDonnie Prakoso\nDonnie Prakoso is a software engineer, self-proclaimed barista, and Principal Developer Advocate at Amazon Web Services. With more than 17 years of experience in the technology industry, from telecommunications, banking to startups. He is now focusing on helping the developers to understand varieties of technology to transform their ideas into execution. He loves coffee and any discussion of any topics from microservices to AI / ML.\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n","render":"<p>There are various ways to report on data insights, and paginated reports is one of them. Paginated reports are essential documents that contain critical business information for end-users. For decades, paginated reports have been the standard business reporting format. The following are examples of paginated reports. On the left shows the report for income statement and on the right is the yearly summary corporate statement:</p>\n<p><img src=\"https://dev-media.amazoncloud.cn/57972e30a399494d998a47204821cbbd_image.png\" alt=\"image.png\" /></p>\n<p>As the example shows, paginated reports contain various highly formatted insights and are designed to be printable, in landscape or portrait orientation, so they can be consumed easily by readers. It’s called paginated because it often spans tens of hundreds of pages of data.</p>\n<p>Although it may appear to be a simple task, generating paginated reports is heavily dependent on legacy data warehouses and legacy business intelligence tools, especially because modern business intelligence tools do not offer this capability. As a result, organizations typically have to maintain multiple business intelligence systems to have separate solutions for building critical operational reports and summarized dashboards. Each solution presents its set of challenges with data governance, security, and access management. This caused a disjointed experience for both authors and end users. Legacy BI systems also run on-premises infrastructure, which is expensive to maintain and upgrade.</p>\n<p><strong><ins>Introducing Amazon QuickSight Paginated Reports</ins></strong><br />\nToday, I’m pleased to announce <a href=\"https://aws.amazon.com/quicksight/paginated-reports/\" target=\"_blank\">Amazon QuickSight Paginated Reports</a>. This feature allows customers to create and share highly formatted, personalized reports containing business-critical data to hundreds of thousands of end-users without any infrastructure setup or maintenance, up-front licensing, or long-term commitments.</p>\n<p>Here’s a quick look on how Amazon QuickSight Paginated Reports works:</p>\n<p><img src=\"https://dev-media.amazoncloud.cn/af8ffeccc0a143f4bd2ea0fda54df9a1_quicklook.gif\" alt=\"quicklook.gif\" /></p>\n<p>With Amazon QuickSight Paginated Reports, customers can now create and share paginated reports to their users from the same familiar QuickSight interface that they use to create and consume interactive dashboards. They can use one single BI service to create and deliver interactive analytics in dashboards, format reports with paginated reports, or embed analytics in apps while also allowing end users to ask questions of the underlying data using machine learning (ML) powered natural language query with QuickSight Q. From ML powered interactive dashboard to generating and distributing operational reports, these benefits impact different stakeholder groups in an organization</p>\n<p><strong>For Readers</strong> – Amazon QuickSight Paginated Reports makes it easy for readers to consume reports in a familiar and scheduled fashion, in highly formatted models in .pdf or .csv formats. Readers can access these reports via email, Amazon QuickSight web and mobile interfaces, mobile applications, or embedded portals.</p>\n<p><strong>For Authors</strong> – This feature gives report authors the flexibility to create highly formatted reports with images, texts, charts, tables, and exact page sizes. They can create reports from the same data models as dashboards, reusing data models built up, using access permissions (RLS/CLS) setup, and publishing in the same dashboards where their users look for data. These dashboards are also available via API, allowing migration between accounts or programmatic creation and migration of these assets as needed.</p>\n<p>The Amazon QuickSight Paginated Reports makes it easy to build reports without the need for separate training or investment in a dedicated application. With an easy-to-use web-based authoring interface, this feature allows report authors to create complex data models in the form of operational reports for hundreds of thousands of report readers and enables data-driven decision-making.</p>\n<p><strong>For IT Leaders</strong> – This feature also provides IT leaders with benefits such as fully managed reporting capabilities consolidated within Amazon QuickSight. This reduces the time and resources required to set up and maintain reporting solutions, helping IT leaders to start looking at the cloud for their BI needs and transitioning legacy reporting to the cloud to save time and resources.</p>\n<p>Amazon QuickSight Paginated Reports also leverages existing QuickSight capabilities, such as user management, data preparation, advanced scheduling and audit logging. By inheriting the capabilities from QuickSight, it removes the need to manage any infrastructure or provisioning setup to deliver reports to hundreds of thousands of users.</p>\n<p><strong><ins>Get Started with Amazon QuickSight Paginated Reports</ins></strong><br />\nLet’s see how to get started with Amazon QuickSight Paginated Reports. I will focus more on how authors can create, publish and deliver reports to readers.</p>\n<p><strong>For Authors: Creating a Report</strong><br />\nFirst, I open the QuickSight console. Then, in the navigation section, I select the dataset that I will use for reporting purposes.</p>\n<p><img src=\"https://dev-media.amazoncloud.cn/83200d7e78754700b5161a6b45026139_image.png\" alt=\"image.png\" /></p>\n<p>After I check and confirm the dataset, I select Use in Analysis.</p>\n<p><img src=\"https://dev-media.amazoncloud.cn/ad122e439c8a4057a98c0324c48a7928_image.png\" alt=\"image.png\" /></p>\n<p>On the next page, I have the option to select the sheet type, <strong>Interactive sheet</strong>, or <strong>Paginated report</strong>. I select <strong>Paginated report</strong>, and here I can configure the report for Paper size and either <strong>Portrait</strong> or <strong>Landscape</strong> orientation.</p>\n<p><img src=\"https://dev-media.amazoncloud.cn/456ee055971e4cc18b9224e9b5309368_image.png\" alt=\"image.png\" /></p>\n<p>Now I’m starting my report creation. The sheet area I can use is adjusted to the paper size option I defined in the previous step. In this reporting sheet, QuickSight provides me with <strong>Header</strong> and <strong>Footer</strong> areas.</p>\n<p><img src=\"https://dev-media.amazoncloud.cn/f5ecca6a614543bebac332b85f70e774_image.png\" alt=\"image.png\" /></p>\n<p>First, I want to add the title of this report in the header section. I select the Header area, and in the menu section, I select <strong>Add text</strong>.</p>\n<p><img src=\"https://dev-media.amazoncloud.cn/8c8fced1dbc246059477f25c20eceeae_image.png\" alt=\"image.png\" /></p>\n<p>Now, I can start entering the title of the report. I name this report “<strong>Attendance Statistics</strong>” and customize the header using the company logo. I can also use the text toolbar to format the text and add page numbers. For any changes I’ve made, I can also see the preview directly on this page.</p>\n<p><img src=\"https://dev-media.amazoncloud.cn/977900f2301c429488aa8e9a1261aa27_image.png\" alt=\"image.png\" /></p>\n<p>I can also add other visuals in any section by selecting <strong>Add visual</strong>.</p>\n<p><img src=\"https://dev-media.amazoncloud.cn/b6d5dc2201274d6dac1e665cc2e88695_image.png\" alt=\"image.png\" /></p>\n<p>From here, I can start building reports with the available visuals, just like I normally do on the Amazon QuickSight dashboard. For example, if I need to add a summary to the pie chart, I can add another text box and drag and drop to set the layout and resize the visuals as needed.</p>\n<p><img src=\"https://dev-media.amazoncloud.cn/d5a5770453474ee8b01ece5898db4d5a_image.png\" alt=\"image.png\" /></p>\n<p>If I need to add another section, from the menu, I select <strong>Add section</strong>, and I can add other visuals or insights into this new section. As for visual tabular data, the visual will be generated across pages.</p>\n<p><img src=\"https://dev-media.amazoncloud.cn/61859a51bcce4ccbab456ebe94ffb1dc_image.png\" alt=\"image.png\" /></p>\n<p><strong><ins>For Author: Publish and Schedule Report</ins></strong><br />\nOnce the analysis is completed, I need to publish this analysis as a dashboard by selecting <strong>Share</strong> and then <strong>Publish dashboard</strong>. Then I can choose to create a new dashboard by selecting <strong>Publish new dashboard</strong> or <strong>Replace an existing dashboard</strong>. I can also select the sheet(s) I want to publish.</p>\n<p><img src=\"https://dev-media.amazoncloud.cn/df105b80f87a495aa384aee446e186a5_image.png\" alt=\"image.png\" /></p>\n<p>At this stage, I’m ready to set a schedule to deliver my reports to readers. To do that, I need to open the dashboard and define a schedule by selecting <strong>Add schedule</strong>.</p>\n<p><img src=\"https://dev-media.amazoncloud.cn/2f157067fa584bf3a6d26aff06129543_image.png\" alt=\"image.png\" /></p>\n<p>In this menu, I can specify the schedule name and also the content format. In the <strong>Content section</strong>, I can choose either <strong>PDF</strong> or <strong>CSV</strong> format. For PDF format, I can select the sheet I want to use. For CSV format, I can select multiple visuals.</p>\n<p><img src=\"https://dev-media.amazoncloud.cn/24b2a342c6e74679ac1d3ee3a8bbfc89_image.png\" alt=\"image.png\" /></p>\n<p>As for the delivery report schedule, I can define the schedule as <strong>Daily, Weekly, Monthly</strong>, or one-time delivery with <strong>Do not repeat</strong>. I can also specify the date and time of delivery, including the time zone.</p>\n<p><img src=\"https://dev-media.amazoncloud.cn/882be1e15b124e66b38467f291927471_image.png\" alt=\"image.png\" /></p>\n<p>Then, I specify the configuration of the email message. In the final section, I can also specify how readers access this report, by using <strong>Download link</strong> or <strong>File attachment</strong>. Once I’m done setting up the schedule, I can <strong>Save</strong> it or send this report according to the schedule by selecting <strong>Save and run now</strong>.</p>\n<p><img src=\"https://dev-media.amazoncloud.cn/9927d2d6cd4f493699d977da6da5cffb_image.png\" alt=\"image.png\" /></p>\n<p><strong>For Readers: Receiving and Accessing Reports</strong><br />\nHere is an example email from the schedule that QuickSight has sent to me as a reader. I can download this report from the email attachment or from the dashboard.</p>\n<p><img src=\"https://dev-media.amazoncloud.cn/7320a15059b24381a9553c0987e925d0_image.png\" alt=\"image.png\" /></p>\n<p>I can also use the provided link in the email to view recent snapshots. The <strong>Recent Snapshots</strong> feature allows me to review previously generated reports.</p>\n<p><img src=\"https://dev-media.amazoncloud.cn/02f81eb48c564e14a54e0d232e0a42df_image.png\" alt=\"image.png\" /></p>\n<p><strong>Things to Know</strong><br />\n<strong>Programmatic API Access</strong> – In addition to using the Amazon QuickSight console, customers can also use the Amazon Web Services API and SDK to interact programmatically with Amazon QuickSight Paginated Reports.</p>\n<p><strong>Amazon Web Services Partners</strong> – To make it easier for customers to migrate their legacy BI solutions to Amazon QuickSight, customers can work with Amazon Web Services partners, Ironside Consulting and Data Terrain. Ironside and Data Terrain offerings are available in the Amazon Web Services Marketplace, with more details at <a href=\"https://aws.amazon.com/quicksight/partners/\" target=\"_blank\">Amazon QuickSight Partners</a> page.</p>\n<p><strong>Availability and Pricing</strong> – Amazon QuickSight Paginated Reports is available as an add-on to the existing Amazon QuickSight Enterprise or Enterprise enabled with Q in all supported Amazon Web Services Regions.</p>\n<p>Visit the <a href=\"https://aws.amazon.com/quicksight/paginated-reports/\" target=\"_blank\">Amazon QuickSight Paginated Reports page</a> to learn more details on how to use this feature, learn how to get started, and understand the pricing.</p>\n<p>Happy building!<br />\n— <a href=\"https://donnie.id/\" target=\"_blank\">Donnie</a></p>\n<p><img src=\"https://dev-media.amazoncloud.cn/fe1837a2f03c40599658edcdb76912dd_image.png\" alt=\"image.png\" /></p>\n<p>Donnie Prakoso<br />\nDonnie Prakoso is a software engineer, self-proclaimed barista, and Principal Developer Advocate at Amazon Web Services. With more than 17 years of experience in the technology industry, from telecommunications, banking to startups. He is now focusing on helping the developers to understand varieties of technology to transform their ideas into execution. He loves coffee and any discussion of any topics from microservices to AI / ML.</p>\n"}
0
目录
关闭
contact-us