Yearly Sales Trend Analysis
Budget: $10 – $30 USD
I have a set of sales figures that span several years and I need a clear, statistically sound picture of how our performance has evolved year-over-year. The raw data will be shared in Excel/CSV format; it covers revenue, units sold and a handful of categorical attributes (region, product line, channel).
The task is straightforward: clean the files if needed, run a yearly trend analysis, then present the findings in both an editable workbook (with formulas intact) and a concise slide deck or PDF that highlights key movements, anomalies and any seasonality you discover. Visuals—line charts, stacked columns, heat maps—should be included so the leadership team can grasp the story at a glance.
Acceptance criteria
• All source data returned in a tidy, well-labeled workbook
• Year-over-year growth calculations verified with simple audit checks
• At least three clear visualizations accompanied by a brief written interpretation
• Recommendations for next steps (optional but appreciated)
Tools like Excel, Power BI or Python/Pandas are fine as long as the final outputs are easy for non-technical managers to open and explore. Turnaround within one week of file hand-off would be ideal; let me know if you need a different window.
The task is straightforward: clean the files if needed, run a yearly trend analysis, then present the findings in both an editable workbook (with formulas intact) and a concise slide deck or PDF that highlights key movements, anomalies and any seasonality you discover. Visuals—line charts, stacked columns, heat maps—should be included so the leadership team can grasp the story at a glance.
Acceptance criteria
• All source data returned in a tidy, well-labeled workbook
• Year-over-year growth calculations verified with simple audit checks
• At least three clear visualizations accompanied by a brief written interpretation
• Recommendations for next steps (optional but appreciated)
Tools like Excel, Power BI or Python/Pandas are fine as long as the final outputs are easy for non-technical managers to open and explore. Turnaround within one week of file hand-off would be ideal; let me know if you need a different window.