Walid Chibi
Data Analyst | Power BI, Data Studio, SQL, Python, Google Sh
New to Contra
Walid is building their profile!
Five retail sources, 1,070,374 records, 96 automated checks. Biggest defect: 47% of sales predate their product's launch, carrying 46% of $6.17B revenue.
Every row fixed, flagged, or quarantined under a versioned rules contract; never deleted. Revenue reconciled to $0.00 unexplained variance, verified by four independent engines (pandas x2, MySQL, Power Query).
Governed by a 23-entry decision log; least-privilege DB access.
I bring this rigor to client data: audit first, document every change, reconcile to zero.
1
26
Production lead-cleaning pipeline in Google Sheets: turns raw leads from web forms, Meta ads and purchased lists into scored, deduplicated HubSpot contacts.
Includes JSON extraction (4 formats), contact normalization (200+ country phone codes), 0–100 quality scoring, duplicate fingerprinting, human review queue, and HubSpot sync with retry + full audit logs.
Built for big data: batched I/O, chunked processing, re-run-safe stages within Apps Script's 6-minute limit. Ships self-installing setup, one-click menu, demo generator and GitHub docs.
1
11
Case study on 100K+ real e-commerce orders (Olist dataset): why did revenue growth stop? I built a 6-page Power BI diagnostic star schema, 25+ DAX measures (revenue decomposition into volume vs. basket effects, MoM/YoY, CROSSFILTER) plus a plain-English executive report with a 30/60/90 action plan. Key findings: orders flatlined at 6.6K/month; 97% of buyers never return; one region carries 38.4% of revenue; one category hides a 15.7% decline. Full pipeline on GitHub: Python ETL, SQL validation, dashboard, report.
1
15
Interactive Global Ads Performance dashboard analyzing full-year 2024 paid media data across Google, Meta & TikTok for a marketing agency. Consolidates spend, revenue, conversions & efficiency metrics (ROAS, CPA, CTR, CPC) into one view so stakeholders can track KPIs, spot seasonality, compare platforms, and find top industries & countries. Features dynamic filters, MoM KPI trends, funnel analysis, and conditional-formatted tables. Delivered actionable insights on budget reallocation and campaign efficiency, turning raw multi-platform data into a clear decision-making tool.
1
9