E-Commerce Sales Intelligence
End-to-end Power BI dashboard tracking revenue, AOV, returns and category performance with drill-downs across products, customers and quarters.
Revenue tracked
$36.9M
KPIs
12+
Drill levels
4
I'm Basma Shaban — a Data Analyst & BI Developer. I help teams unlock insights, automate workflows, and make smarter decisions with Power BI, SQL, Python and AI-powered analytics.
Toolkit
Revenue
$0.0K
Customers
0.0
Conversion
0.0%
AOV
$0.0
Revenue trend
9 mo
Channel mix
0+
Projects delivered
0+
Dashboards built
0%
Avg. time saved
0+
Certifications
About

Based in
Minia, Egypt · Remote 🌍
I work at the intersection of mathematics, statistics and software — turning raw, messy data into clean models, clear dashboards and decisions that move the business forward.
My background blends a STEM education, hands-on training with the Digital Pioneers (Digilians) program, and real-world experience analyzing customer behavior, performance and operations — including measurable wins like +30% report accuracy, −40% manual processing time, and a 25% faster reporting turnaround.
"Numbers only matter when they change a decision."
B.Ed. in Chemistry — STEM Program
2021–2025Minia University · Interdisciplinary math, research & data
1st Place — Ibdaa National Competition
2024 & 2025Back-to-back wins in engineering innovations
Data Analyst — Digital Pioneers (Digilians)
2026 – PresentPython · SQL · Power BI · Tableau · 5+ dashboards
Open to Analytics, BI & Automation roles
NowFreelance & full-time · Worldwide
Services
From raw data to boardroom-ready insight. Pick a single engagement or combine them.
Executive-ready dashboards with DAX, drill-downs and row-level security.
Clean models, automated pipelines and KPI reports your team can trust.
Statistical analysis, trends and forecasts that drive real decisions.
AI-powered workflows that cut manual work and accelerate reporting.
Predictive models for churn, demand and segmentation — explained simply.
Coach teams to be data-literate — Excel, SQL and BI foundations.
Selected work
End-to-end Power BI dashboard tracking revenue, AOV, returns and category performance with drill-downs across products, customers and quarters.
Revenue tracked
$36.9M
KPIs
12+
Drill levels
4
HR dashboard surfacing headcount, gender split, hiring trends and active/inactive ratios across companies with slicers and time-series.
Employees
1,518
Companies
13
Years
11
Processed large solar datasets in Python — null handling, outlier detection and anomaly analysis — to surface trends for non-technical audiences.
Records
1M+
Anomalies
Detected
Accuracy
+30%
Automated data preparation and ETL with Python + SQL, cutting reporting turnaround by 25% and reducing manual processing time by 40%.
Turnaround
−25%
Manual time
−40%
Pipelines
5+
Statistical study of platform adoption patterns with quantitative analysis and visual reports for educators and stakeholders.
Respondents
200+
Variables
30+
Reports
Published
Analyzed customer behavior and market demand for El Mohandes Real Estate, driving a 15% increase in qualified leads via campaign analytics.
Qualified leads
+15%
Campaigns
12
Segments
6
Live BI Demo
A taste of the kind of executive dashboards I build — fully interactive, with filters, drill-downs and live cross-filtering. Try it.
Total Revenue
$1,221,000
Categories
5
Top Category
Electronics
Avg / Cat
$244,200
Revenue trend by category
Revenue share %
Revenue by category
Forecast — total revenue
Skills
Analytics & BI
Languages
Libraries
Data & ETL
AI & Automation
Office & Tools
Experience & Credentials
The Digital Pioneers Initiative (Digilians)
Minia University
El Mohandes Real Estate
Certifications & Awards
Honor
🏆 Back-to-back 1st Place — Ibdaa National Engineering Competition (2024 & 2025)
Testimonials
What collaborators, mentors and clients say about working with me.
"Basma transformed our reporting process. Her Power BI dashboards cut our weekly reporting time by 40% and gave leadership clarity we didn't know was possible."
Operations Lead
Retail Analytics Client
"Sharp analytical mind paired with real business sense. She doesn't just deliver charts — she delivers decisions. A pleasure to work with on every iteration."
Ahmed K.
Project Manager, Digilians
"From messy raw data to a clean, automated pipeline in under two weeks. Basma's SQL and Python work saved us hours every single day."
Mariam S.
Data Team Collaborator
"One of the most reliable and detail-oriented analysts I've mentored. She turns complex problems into elegant, measurable solutions."
STEM Program Mentor
Ibdaa National Competition
Moments
Competitions, capstones, workshops and recognition — a glimpse into the journey.

STEM School — National Recognition
Honored among Egypt's leading STEM students

USAID STEM Delegation Visit
Showcasing engineering projects in sustainability and technology

Smart Irrigation Capstone
Cross-functional team showcase — Ibdaa National Competition

Presenting the Methodology
Smart Irrigation monitoring & controlling system

Workshop — Bloom's Digital Taxonomy
Teaching analytical thinking with digital tools
Engineering capstone
An IoT-based dual-axis solar tracking system that continuously orients PV panels toward peak irradiance — a practical application of embedded engineering, sensor fusion and real-time control to maximize clean energy yield.
Yield gain
+25%
Platform
IoT / MCU
Telemetry
Real-time
Let's build
Tell me about your project — dashboards, analysis, ETL, or AI automation. I usually reply within 24 hours.