Skip to content
View Sohila-Khaled-Abbas's full-sized avatar
💭
I may be slow to respond.
💭
I may be slow to respond.
85 followers · 8 following

Block or report Sohila-Khaled-Abbas

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Sohila-Khaled-Abbas/README.md

BI Developer • Analytics Engineer • Data Systems Architect

📡 Analytics Systems Blueprint

Sources → APIs / Files / SQL
       ↓
Python ETL / n8n / Validation
       ↓
Warehouse → PostgreSQL / Snowflake
       ↓
Semantic Layer → Star Schema + DAX
       ↓
Power BI → KPIs / Forecasts / Alerts
       ↓
Business Decisions / Optimization

🎯 Core Value

  • Transform raw data into decision infrastructure
  • Build warehouse-ready analytics pipelines
  • Engineer semantic BI layers
  • Design stakeholder-first KPI systems
  • Convert analytics into strategic actions

🧠 Analytics Engineering Identity

role: BI Developer / Analytics Engineer
focus:
  - Semantic Modeling
  - KPI Engineering
  - ETL Automation
  - Experimentation Analytics
  - Data Storytelling
  - Forecasting Systems
specialty:
  - Power BI optimization
  - SQL performance tuning
  - Python analytics pipelines
  - Executive dashboards

🛠️ Modern Analytics Stack

Semantic BI

Power BI DAX Star Schema

Data Engineering

Python SQL PostgreSQL n8n

Cloud Analytics

Snowflake Databricks

📊 Data Delivery Telemetry

🧬 Contribution Flow Map

🚀 Featured Analytics Repositories

🍎 Apple Stock Market Intelligence

End-to-end financial analytics engineering system

  • historical AAPL data ingestion
  • ETL orchestration pipeline
  • warehouse-ready financial modeling
  • volatility + trend diagnostics
  • investment strategy dashboards

Core stack: Python • SQL • APIs • Power BI • Forecasting

🛒 FMCG Sales Churn & Revenue Drop

Commercial intelligence & retention analytics

  • churn diagnostics
  • revenue leakage detection
  • KPI semantic modeling
  • retention cohort analysis
  • executive Power BI storytelling

Core stack: Power BI • DAX • SQL • Star Schema

🚚 SMART Supply Chain Insights

Operations intelligence & risk analytics

  • fraud anomaly detection
  • logistics KPI monitoring
  • supply chain risk dashboards
  • fulfillment bottleneck diagnostics

Core stack: Python • Statistics • Power BI

🧪 A/B Testing Marketing Conversion

Experimentation analytics & statistical inference

  • hypothesis testing
  • conversion uplift measurement
  • confidence intervals
  • OLS regression
  • pricing optimization insights

Core stack: Python • PostgreSQL • SciPy • Experiment Design

🌍 Leadership & Community Analytics

Treating mentorship as a measurable impact system.

50+ professionals mentored
100+ SQL/Python reviews completed
15+ career transitions enabled
Top data educator recognition in Egypt
Built: The Data Tea analytics community

🤝 Collaboration CTA

Open for High-Impact Work

  • BI platform modernization
  • executive KPI architecture
  • ETL automation systems
  • analytics engineering consulting
  • experimentation frameworks
  • forecasting dashboards

🌐 Connect Layer

LinkedIn Email Portfolio

💡 Operating Principle

The output is not reports. The output is faster, better business decisions powered by trustworthy data systems.

Popular repositories Loading

  1. n8n-production-queue-setup n8n-production-queue-setup Public

    A production-grade, self-hosted n8n deployment with queue-mode scaling, PostgreSQL persistence, and an isolated Python/JavaScript code execution sidecar.

    Python 2 1

  2. healthcare-analytics-dashboard healthcare-analytics-dashboard Public

    Interactive Power BI dashboard for analyzing hospital waitlists, patient demographics, and service trends.

    1

  3. Wuzzuf-Job-Market-Analysis Wuzzuf-Job-Market-Analysis Public

    Wuzzuf Job Market Analysis is a Power BI Dashboard that analyzes job market trends in Egypt using web scraping and data analytics. This project extracts job postings from Wuzzuf.net, cleans the dat…

    1

  4. Obsidian-Vault-Roadmap Obsidian-Vault-Roadmap Public

    Forked from ahmedashraffcih/Obsidian-Vault-Roadmap

    1

  5. marketing_campaigns_analysis marketing_campaigns_analysis Public

    This project explains how data engineering and analytics enable smarter campaign investments. Optimizing marketing spend requires reliable, well-modeled data. We build an end-to-end pipeline from r…

    Jupyter Notebook 1

  6. apple-stock-market-analysis apple-stock-market-analysis Public

    An end-to-end data engineering and analytics project analyzing historical Apple Inc. (AAPL) stock market data up to the present day, to extract actionable business insights and investment strategies.

    Jupyter Notebook 1