Generate wide format tables that can easily be converted to graphs without additional processing.
Compound Yearly and Monthly Growth
Calculate the compound annual growth rate (CAGR) for each year compared to the base year (e.g., from 2021 to 2022, 2021 to 2023, and 2021 to 2024) for each region.
Develop a query to present the compound monthly growth rate for each region from January up to the current month of the year.
Month-on-Month and Year-on-Year Growth
For each region and each month, retrieve the month-on-month growth rate and the year-on-year growth rate to assess performance trends.
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (