Analyzing reinforcement bar (rebar) sales in the Ethiopian market (2020–2026), built to showcase end-to-end data analysis skills relevant to steel manufacturing and diversified industrial groups.
- Monthly revenue & average selling price trends
- 12-month revenue forecast (Prophet)
- Breakdown by product, region & customer type
- Seasonality analysis (Dry vs Wet season)
- Interactive Plotly charts
- Business insights & recommendations panel
- Total simulated revenue ≈ 12.88 billion ETB
- Average selling price ≈ 247 ETB/kg
- Average estimated margin ≈ 25.0%
- Dominant region — Addis Ababa (~41%)
- Most valuable customer segment — Large Contractor (~22%)
- Dry season (Nov–May) contributes ~67% of revenue
- Top-selling product — Rebar 16mm Imported (Turkey) (~16%)
Strategic recommendations summary
- Prioritize Addis Ababa & Oromia (~70%+ combined share)
- Focus relationship management on large contractors & government projects
- Align inventory & promotions with dry-season peaks
- Evaluate local production of high-demand imported grades to improve margins
- Monitor price–volume elasticity carefully
| Layer | Tools |
|---|---|
| Language | Python 3.10+ |
| Data processing | pandas, numpy |
| Visualization | Plotly & Plotly Express |
| Forecasting | Prophet |
| EDA & static plots | Matplotlib, Seaborn |
| Notebooks | Jupyter |