.svg)
Visual Tables in QuickSight Visuals | West Loop Strategy
Learn how to create tables in QuickSight visuals with West Loop Strategy. Organize your data & present complex information in a clear, structured format.
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.
You may also like
F.A.Q.
Find answers to common questions about cloud migration and working with West Loop Strategy.
With 30+ years of industry experience and over 20 AWS certifications, we offer data analytics and AWS cloud migration services to seamlessly transition your business to the cloud.
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 West Loop Strategy 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.
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.
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 consultants or utilizingAWS migration tools and resources can help streamline the process and ensure a successfulmigration within a reasonable timeframe.
West Loop Strategy offers comprehensive support throughout the AWS cloud migration process.Our customized migration strategies prioritize your uptime and operational integrity, while theduration of the migration is tailored to the complexity of your infrastructure, ensuring a smoothtransition with minimal disruptions.