Skip to content
Gallery
Gwendolyn Ang - BI Portfolio
Share
Explore
Part 2: Querying & Data Analysis

icon picker
Regional Revenue Growth Analysis


Temporary Tables

Revenue Shares

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 (
CtrlP
) instead.