AWS Business Intelligence Blog
Category: Intermediate (200)
Build a market basket analysis dashboard using nested filters in Amazon QuickSight
Amazon QuickSight is a scalable, serverless, machine learning (ML)-powered business intelligence (BI) solution. As a fully managed service, QuickSight lets you create and publish interactive dashboards that can be accessed from any device and embedded into your applications, portals, and websites. Traditionally, building market basket analysis dashboards requires data engineering pipelines that can take weeks to implement, because these often depend on ETL (extract, transform, and load) jobs, complex SQL operations, and updates on the data pipeline. The nested filter capability in QuickSight simplifies this process with a no-code interface. In this post, we show you how to configure nested filters in a QuickSight dashboard and how they can aid in different business use cases within market basket analysis. We show how nested filters can provide more advanced filtering to help solve common challenges with market basket analysis dashboards in four different use cases.
Build pixel-perfect reports with ease using Amazon Q in QuickSight
QuickSight users can now use natural language generation to create pixel-perfect reports – a new capability in Amazon Q for QuickSight that simplifies the way users create and distribute visually-rich, highly-formatted reports to their stakeholders. Pixel-perfect reports are crucial because they ensure that every detail of the report, from layout to formatting, is meticulously controlled and aesthetically pleasing. This not only creates a professional data presentation, it also improves comprehension and decision-making among stakeholders.In this post, we cover how to use generative BI capabilities to accelerate pixel-perfect report designing using Amazon Q in the QuickSight console and deliver it to QuickSight users. Pixel-perfect reports can also be delivered to non-QuickSight users in Excel, CSV, or PDF format using Snapshot Export APIs.
Build with cross-sheet filters and controls in Amazon QuickSight
Amazon QuickSight is a cloud-powered, serverless, and embeddable business intelligence (BI) service that makes it straightforward to deliver insights to everyone in your organization. As a fully managed service, QuickSight lets you create and publish interactive dashboards that can then be accessed from any device and embedded into your applications, portals, and websites. QuickSight is expanding filter and control functionality. Previously, a filter could be scoped to a single visual, some visuals, all of the visuals for a dataset on a sheet, or all applicable visuals on a sheet. With the launch of cross-sheet filters and controls, authors can now create, delete, and edit filters that apply to multiple sheets. Previously, cross-sheet filters could be created with parameters in over forty clicks. With the expansion in functionality, they can be created in just five clicks, which shows how much this new feature simplifies setting up filters and controls that impact multiple sheets.
Manage access to insights with an account instance of AWS IAM Identity Center and Amazon QuickSight
Amazon QuickSight is an IAM Identity Center enabled application. Administrators can create a new QuickSight account and use IAM Identity Center for managing QuickSight users and groups. IAM Identity Center can store QuickSight user and group identities within IAM Identity Center itself as an identity store, or they can configure it with a third-party identity provider (IdP) used within their organization. Administrators can use groups in their IdP to assign QuickSight roles (administrator, author, and reader) to users. After they’re successfully authenticated via IdP, users can seamlessly access QuickSight dashboards either from the QuickSight application or as an embedded component within their business applications. Having QuickSight users and groups provisioned in an IdP also helps control authorization to QuickSight resources like dashboards and datasets.In this post, we discuss when you should use which type of instance, the benefits of using IAM Identity Center with QuickSight, how to configure an account instance, and how to use it to access QuickSight.
Run Amazon QuickSight API commands and ask QuickSight questions in Slack
This post delves into integrating QuickSight with Slack through AWS Chatbot. AWS Chatbot serves as a ChatOps tool within AWS, facilitating communication and commands through chat clients. It supports notifications from AWS services to chat channels, streamlining monitoring and issue resolution processes.
Sync users and groups from Okta with Amazon QuickSight
Amazon QuickSight supports identity federation through Security Assertion Markup Language 2.0 (SAML 2.0) in both Standard and Enterprise editions. With federation, you can manage users using your enterprise identity provider (IdP) and pass them to QuickSight at login. IdPs include Microsoft Active Directory Federation Services, Ping One Federation Server, Okta, and more. This post provides steps and code samples to overcome these challenges in a scalable way. We demonstrate the solution using Okta, but you could use other IdPs as well. This is a proven solution and has been used and implemented by several QuickSight customers.
Prevsis safety and sustainability software solutions help customers make informed decisions with Amazon QuickSight
Prevsis aims at caring for workers’ safety, well-being, and corporate sustainability. It focuses on delivering a no-code occupational health and safety (HS) and environmental, social, and governance (ESG) solution with a wide range of data pipelines for robust analytics harvesting with AI capabilities. Users in high-risk industries such as mining, energy, construction, and logistics can digitally manage all their safety and compliance needs through a one-stop interface. As one of the leading digital service providers in the HS/ESG field Latin America, we capitalize on decades of experience to help customers assess and monitor risk levels, enhance operational efficiency, and minimize disruptions across the workplace. In this post, we share how Prevsis used Amazon QuickSight to create more than 700 client dashboards.
Global Mile Exports uses Amazon QuickSight to orchestrate a global transportation and logistics network
Global Mile is a foundational team within Amazon that helps to build, manage, and operate its global transportation network for orders that cross international borders. Global Mile Exports Visibility was set up in 2019 to architect and own the team’s data management, strategy, and underlying platform. In this post, we discuss how Global Mile migrated their BI dashboards and reports to Amazon QuickSight to enhance their operations.
What’s new with data visualization in Amazon QuickSight – 2023 in review
Amazon QuickSight is a fully managed, cloud-native business intelligence (BI) service that you can use to connect to your data and create interactive dashboards that can be shared with tens of thousands of users. The dashboards can be used within QuickSight or embedded in software as a service (SaaS) apps. As we bid farewell to […]
Unlock the power of unified business intelligence with Google Cloud BigQuery and Amazon QuickSight
Amazon QuickSight is a cloud-native, serverless business intelligence (BI) service that lets you build visualizations, perform ad hoc analysis, and gain insights through machine learning (ML) capabilities such as anomaly detection, forecasting, and natural language querying. QuickSight utilizes its robust in-memory engine SPICE (Super-fast, Parallel, In-memory Calculation Engine) to rapidly perform advanced calculations and deliver visuals.BigQuery is Google Cloud’s fully managed, petabyte-scale, cost-effective analytics data warehouse that lets you run analytics over vast amounts of data in near-real time. In this post, we walk you through the permissions and connection details needed in BigQuery to bring BigQuery data into QuickSight through OAuth and create a simple dashboard.