Live site: kamelaggoun.github.io/portfolio
Personal portfolio site for Kamel Aggoun, a data analyst working in Python, SQL, Excel, and Power BI. Presents six end-to-end analytics projects — from a defined business question through data cleaning, analysis, and a Power BI dashboard — plus experience, education, and certifications.
| Project | Focus | Repo |
|---|---|---|
| HR Analytics | Employee attrition, 1,470 records, 65 cross-validated SQL queries | hr-analytics |
| Customer Segmentation | RFM segmentation on 1.07M transaction lines | customer-segmentation |
| Sales Forecasting | Time-series forecasting, 1M+ records, chronological validation | sales-forecasting |
| SQL Business Analysis | Advanced SQL — CTEs, window functions, cohort/LTV analysis | sql-business-analysis |
| Financial Performance Analysis | Revenue, cost, and margin analysis with SQL window functions | financial-performance-analysis |
| Supply Chain & Inventory Analytics | Inventory, demand, and logistics KPIs | supply-chain-inventory-analytics |
Each project's own repo has the full write-up: business problem, dataset, methodology, SQL/Python cross-validation, and findings. This site is the front door to that work.
- HTML5, CSS3, vanilla JavaScript — no framework, no build step
- Google Fonts — Inter & JetBrains Mono
- GitHub Pages — static hosting, no backend
- Responsive, mobile-first layout
- Dark / light mode, respects OS preference, persisted across visits
- Filterable project cards by technology (Python, SQL, Power BI, Excel)
- Fully accessible — semantic HTML, keyboard focus states, skip link,
prefers-reduced-motionsupport - SEO-ready — meta description, Open Graph tags, JSON-LD,
robots.txt,sitemap.xml
/
├── index.html # The full single-page site
├── README.md # This file
├── LICENSE # MIT license
├── robots.txt
├── sitemap.xml
├── assets/
│ ├── images/ # Project screenshots + Open Graph image
│ ├── icons/ # Favicon
│ └── cv/ # Kamel-Aggoun-CV.pdf
├── css/
│ └── style.css
└── js/
└── script.js
git clone https://github.com/kamelaggoun/portfolio.git
cd portfolio
python3 -m http.server 8000
# visit http://localhost:8000- Email — kamel9aggoun@gmail.com
- LinkedIn — linkedin.com/in/kamelaggoun
- GitHub — github.com/kamelaggoun
MIT — see LICENSE.