lawrykoomson/TechSolutions-Ghana-Analytics

Python data analysis project for TechSolutions Ghana IT consulting firm # 💻 TechSolutions Ghana — IT Consulting Analytics ## Project Overview A complete Python data analytics project analysing 100 IT consulting projects for TechSolutions Ghana — a small IT firm providing software development, cybersecurity, cloud migration and IT infrastructure solutions. Built as a Data Analyst case study to help the CEO improve client retention, optimize project delivery and focus on the most profitable IT services. --- ## 🎯 Business Problem The CEO asked: "How can we use data to improve client retention, optimize project delivery, and focus on the most profitable IT services?" --- ## 📊 Dataset - **Records:** 100 projects - **Columns:** Project ID, Client ID, Service Type, Project Cost, Duration, Client Satisfaction, Repeat Client, Completion Status --- ## 🔍 Key Findings - 💰 **GHS 2,752,500** total revenue across 100 projects - 🔄 Only **48% repeat client rate** — needs improvement - ⚠️ **26% project delay rate** — 1 in 4 projects delayed - 🔴 **Software Dev: 60% delay rate** — critical problem - ⭐ Average satisfaction only **3.58/5** — below target - 🏆 **Data Analytics & IT Support** — best retention at 57.1% - 📉 **Website Development** — worst retention at 35.7% --- ## 🎯 Key Recommendations 1. **Fix Software Dev delays** — Agile + 20% time buffer 2. **Client Loyalty Programme** — 10% discount on return 3. **Improve satisfaction** — post-project surveys + follow-ups 4. **Double down on Data Analytics & IT Support** — best retention 5. **Review Website Development** — reposition or phase out 6. **Real-time project tracking dashboard** — flag delays early --- ## 📁 Project Files | File | Description | |------|-------------| | `TechSolutions_Analysis.ipynb` | Main Python notebook | | `TechSolutions Ghana DataSet.xlsx` | Raw dataset | | `techsolutions_analysis_results.xlsx` | 7-sheet Excel results | | `techsolutions_dashboard.png` | 6-chart visual dashboard | | `TechSolutions_Report.pdf …