🎓 BI Skills Matrix
Legend: ⭐ Expert · ✅ Advanced · 🔹 Working
Languages & Engines
| Skill |
Level |
Used In |
| SQL (MySQL 8 — CTEs, window fns, generated cols) |
⭐ |
ETL Guide, KPI Framework |
| Python (pandas, ETL, cron, matplotlib/plotly) |
✅ |
PY-01/PY-02 automations |
| JavaScript / Google Apps Script (JDBC, Drive, MailApp) |
✅ |
Report Automation |
| C# (retail/Shopify sync tools) |
✅ |
Source extraction |
| DAX / M (Power BI) · Looker Studio expressions |
✅ |
Dashboards |
| YAML/Markdown (MkDocs) · Bash/cron · Git |
✅ |
This library + CI/CD |
| Tool |
Level |
Used In |
| Power BI · Tableau · Looker Studio · Advanced Excel |
⭐ |
BI delivery |
| MySQL · PostgreSQL (Zammad) · Elasticsearch · Redis |
✅ |
Source & ops awareness |
| DigitalOcean MySQL · Cloudflare Workers/Access · GitHub Actions |
✅ |
Hosting & deploy |
| Zammad REST API |
🔹 |
Epic 5 |
Practices
| Practice |
Evidence |
| Star-schema & dimensional modeling |
fact_saless + dim_* |
| Master Data Management (golden record, bridge mapping) |
Epic 3 |
| UOM conversion & unified SKU design |
Epic 3 |
| Data quality & anti-pattern auditing |
Epic 1 |
| SLA / OKR / KPI frameworks · ESG reporting |
Epic 4, Sustainability |
| Governance, RBAC & change control |
Data Governance |