Use Amazon QuickSight level-aware calculations to analyze COVID-19 datasets

This article discusses how to use Amazon QuickSight's level-aware calculations (LAC) to analyze COVID-19 datasets and gain insights into the pandemic's impact across different regions, demographic groups, and other factors. Specifically, the article covers:

• An overview of LAC-A and LAC-W functions in QuickSight
• Analyzing COVID-19 case data across U.S. states, counties, gender, age groups, and symptom statuses using LAC-A functions
• Calculating median and average case reporting intervals across states to identify potential testing inefficiencies
• Comparing state and demographic case averages against national totals
• Deduplicating multiple entries of cases using LAC functions
• Conclusion on the benefits of LAC for in-depth data analysis without complex preprocessing