Context:
Given the limited two-month data span, I might think of choosing to predict March orders in this specific case using the average daily orders method
rather than the linear regression in the previous slide. This approach is preferred due to the insufficient data points for establishing reliable trends, the
need for a straightforward and transparent method easily understood by all stakeholders, and the practicality of providing a stable estimate for short
-term forecasting.
Key Insights:
Based on the average daily orders in January and February 2020, the predicted number of orders for March 2020 in each country is as follows:
Ghana: Approximately 7,425 orders
Portugal: Approximately 44,916 orders
Methodology:
Data Exploration: Identified relevant columns (Created Date, Country) and their format.
Data Preprocessing: Converted Created Date to datetime format and checked the date range.
Analysis & Model Building: Calculated average daily orders per country and multiplied by 31 (days in March) for the prediction.
Results: Presented the predicted number of orders for each country.