QuickSight Visuals - Tables

To continue our AWS Analytics Series, we are going to release a multiple videos focusing on some of the visuals available in QuickSight. To ensure you are capitalizing on all of the features and functionalities available, Dylan will begin by discussing how to best utilize Table visuals.

Home
Resources

Hello, I'm Dylan, a cloud developer at West Loop Strategy, an AWS partner. As part of a learning series for QuickSight Dashboard visuals, today, we are going to discuss the features and functionalities available for tables.

While there are many visual templates at your disposal, everything often boils down to providing a sample of all the meaningful data into a single table that can be filtered through and even exported by the reader into a format of their choice, like Excel or CS V. Now, what do these tables do? One of the newest features added into QuickSight allows tables to function similarly to Excel by freezing certain columns to always display as you scroll through a larger table. You can also hide specific columns to not display in the visualization. This is a feature you would utilize if you either want to improve the display of your table on the sheet while still providing access to the columns, or if the user decides to export the table or you need a certain column in the table to ensure a calculated field is aggregated properly, but you don't want it to display.

A good example of this would be adding a customer ID to your table to make sure there's a row for each distinct customer then hiding it from view to manage the display. You can also click this arrow button to move a column to a new location in the table without tediously adjusting the order within your field wells. Once your table is set up how you want, you can apply styling and conditional formatting. Rather than displaying a column that shows ones and zeros or true and false, you can display green check marks and red X's. Once done, select this check box to ensure the values returned from your field don't display and just the icons are shown.

Thanks for joining us today. To learn more about how we help our clients use AWS cloud technology, check out our website and follow us on LinkedIn.

Continue Series

You may also like

Lorem ipsum dolor sit amet, consectetur adipiscing elit.

View all
Parameter Controlled Filters in QuickSight
Parameter Controlled Filters in QuickSight

As part of the AWS Analytics Expert Series, Duncan is going to walk us through the process of building out filters in QuickSight with parameters. This is an important topic to understand, especially if you eventually want to embed your dashboards, since parameter values can be passed through a URL.

Building Calculated Fields
Building Calculated Fields

For the next video in our AWS Analytics Expert Series, Duncan is going to walk us through the steps required to create calculated fields in QuickSight.

Importing Datasets
Importing Datasets

For the second video in our AWS Analytics Expert Series, join Duncan as he walks through adding Datasets into QuickSight.

F.A.Q.

Find answers to common questions about cloud migration and working with West Loop Strategy.

Why choose West Loop Strategy?

With 30+ years of industry experience and over 10 AWS certifications, we offer proven expertise to seamlessly transition your business to the cloud.

How does cloud migration work?

Cloud migration is the process of moving an organization's data, applications, and infrastructure from on-premises servers to the cloud. Our team of AWS certified Solutions Architects at Company Name is here to guide you through this transition, ensuring it's tailored to your business and its unique requirements. From initial assessment to seamless execution, we'll help you navigate the complexities of cloud migration with confidence.

What are the benefits of cloud migration?

Migrating to the cloud on AWS unlocks near limitless scalability, ensuring businesses can grow seamlessly without the burden of managing physical infrastructure. Coupled with AWS's stringent security measures and compliance certifications, organizations can trust their data is safeguarded at all times. Moreover, by optimizing resources and leveraging AWS's pay-as-you-go pricing model, companies can realize significant cost savings while accelerating innovation and agility.

How long does migration take?

The duration of an AWS cloud migration can vary greatly depending on factors such as the size and complexity of the infrastructure being migrated, the readiness of the organization, the level of expertise available, and the chosen migration strategy.

For smaller, less complex applications, a migration might take a few weeks to a couple of months. However, for larger enterprises with complex systems, the migration process could extend over several months or even years.It's essential to thoroughly plan and execute the migration, considering factors like data transfer, application refactoring, testing, and training.

Additionally, organizations should allocate time for troubleshooting and unforeseen challenges that may arise during the migration process. Working closely with AWS experts or utilizing AWS migration tools and resources can help streamline the process and ensure a successful migration within a reasonable timeframe.

What support does West Loop Strategy provide?

West Loop Strategy offers comprehensive support throughout the cloud migration process. Our customized migration plans prioritize your uptime and operational integrity, while the duration of the migration is tailored to the complexity of your infrastructure, ensuring a smooth transition with minimal disruptions.