Portfolio / Case study 04
A Python and Pandas model that projects revenue from sales history and shows a likely range rather than a single guess.

Project walkthrough

$ start project "Revenue forecasting model"
✓ Brief agreed with Forecasting project
✓ Cleaned and grouped historical sales by month
✓ Tested seasonal and trend-based forecasting methods
✓ Presented a base case with low and high ranges
→ Review with the client…
● Delivered and handed over
The project
Planning relied on last year plus a percentage. Seasonal swings and one-off months made that number unreliable.
Budget conversations started from a realistic range, with the seasonal months called out in advance.
Many small businesses plan by taking last year’s revenue and adding a percentage. It is quick, but it hides the shape of the year. A business with a strong season and a quiet season does not grow evenly, and one unusual month, such as a large one-off order, can push the whole estimate off course.
The aim of this project was not to predict the future perfectly, which no model can do. It was to give planning conversations a more honest starting point, one that shows how uncertain the number really is.
I cleaned the historical sales data and grouped it by month so that the seasonal pattern could be seen clearly. In Python and Pandas I tested seasonal and trend-based methods side by side and compared how each one would have performed on months that were already known. The steps were:
A single forecast number invites an argument about whether it is right. A range changes the discussion to how much risk the business is willing to plan for. The seasonal months were called out in advance, so the budget could allow for them rather than being surprised.
If you are budgeting from last year plus a percentage today, a simple first step is to chart your sales by month for the last two or three years. The pattern you see is usually the pattern your forecast needs to respect.
Gallery and links
Figures are anonymised. Click an image to enlarge it.



Services used
Let's connect
Book a free 30-minute call on Google Meet, or reach me directly.
We use cookies to improve your experience on our site. By using our site, you consent to cookies.
Manage your cookie preferences below:
Essential cookies enable basic functions and are necessary for the proper function of the website.
You can find more information in our Privacy Policy and .