Hello, my name is Duncan. I'm a data engineer with West Loop Strategy an AWS Partner. Today for our AWS Analytics Expert Series, I'm going to be talking about using KPIs in your QuickSight dashboard.

KPIs, or Key Performance Indicators, these visuals are a really simple and effective way to communicate a multitude of metrics in your dashboard. For us and our clients, we really love being able to use them and customize them to fit into many different niches for our business needs or our client's business needs.

So for example, I have my KPI metric here. I can easily go from having a metric that just shows total sales to being able to show week over week or even month over month and I haven't had to create any sort of calculated field to do that. All I need to do is go into the field well and then change the date aggregate.

Another key customizability aspect is the ability to change how our metric or the value of our metric is being shown, measured, or defined.  So what I can do is in the properties menu, I can go to the KPI options, decide whether I want my primary value to be the actual value or maybe a comparison value. We can update that value to show as a percent or difference as a percent. I also can include a Sparkline visual at the bottom with a tool tip that adds more capabilities and adds more customizability options on just a single visual. Colors can also be changed and I can actually change how the threshold works so that maybe a specific number means that's good, no change, or lower. I can make all those changes right here in the conditional formatting menu.

Thanks for joining me today. To find out more about how we help our clients use AWS Cloud Technology or to schedule your own QuickSight training session with us, visit our website or follow us on LinkedIn.

Continue Series

You may also like

Lorem ipsum dolor sit amet, consectetur adipiscing elit.

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.