Tools Used:
Objective:
Data & Methodology:
Key Visualizations & Insights
- R(time-series analysis, forecasting models), Excel (PivotTables, Summary Statistics), Data Visualization
Objective:
- Developed a time-series forecasting model to predict Lowe's revenue trends over two years, identifying seasonal fluctuations and key business cycles.
- Analyzed quarterly revenue trends from 2010 to 2020.
Data & Methodology:
- Utilized Lowe's historical revenue dataset (2010-2020) to build a linear trend model for forecasting future sales.
- Applied statistical summary calculations in Excel to evaluate revenue minimums, maximums, averages, and standard deviations by year.
- Used R to develop a forecasting model, generating predicted revenue estimates for 2021 & 2022.
Key Visualizations & Insights
- Time Series Revenue Forecast (R)-identified revenue.
- Predicted the highest revenue quarter.
- Forecasted Q4 as the lowest revenue quarter.
Lowe's Revenue Forecasting & Seasonal Trend Analysis
