Trend Analysis
Last updated
Was this helpful?
Last updated
Was this helpful?
Analyzing time-series data to identify long-term patterns, seasonality, and trends without forecasting future values.
Purpose: Time-series analysis examines how data evolves over time, allowing businesses to track long-term trends, seasonal cycles, and recurring patterns.
Typical Prompts:
"Analyze monthly revenue from January 2020 to June 2023, please include the moving average."
"Show me the 3-month moving average for total orders over the last 24 months."
"What are the quarterly sales for Product X from 2021 to 2023?"
"What is the inventory levels for every month in 2023 along with the 6-month moving average?
Example Output: For item 1001, what is the total sales for each month in 2023, along with the moving average?
Purpose: Comparing across time periods allows businesses to detect second-order trends by comparing changes in metrics over time, such as variance or delta of delta (the rate of change of changes). This approach helps businesses understand deeper shifts in performance, identifying trends not immediately visible through first-order differences alone.
Typical Prompts:
"What are the items that experienced the largest decline in gross profit when comparing the last 3 months to the previous 3 months? Show the delta in gross profit as well as the delta of delta for each item."
"What is the variance in shipping costs between Q1 2023 and Q2 2023, and how has that variance changed compared to the previous year?"
Example Output: What is the top items that had the largest delta between quantity sold vs average quantity in the last 2 months, also what is the largest difference between the delta of previous to past month (delta of delta). Output: Item, Previous Month Quantity Sold, Past Month Quantity Sold, Average Quantity Sold, Delta of Previous Month, Delta of Past month, Delta of Delta.
Example Output: Which products have shown the highest year-over-year growth in sales from 2022 to 2023?