ZAKARIAS MUSA Data Analyst | BI Developer

About Me

np_portfolio

Data Analyst | Turning Complex Data into Business Intelligence | EDA & Data Wrangling Specialist

Languages & Technologies

My favorite languages for systems programming, data wrangling and analysis.

Cloud

amazon Snowflake

My Preferred Cloud Platforms for Streamlined Data Analytics Workflows.

Other Tools

My favorite tools for version control, code editing, and container orchestration.

My Projects

Personal Website

Reseller Performance & Margin Analysis

   

Analyzed 2 years of reseller sales data using SQL and Power BI to identify high-performing territories, product demand trends, margin inefficiencies, and retention risks. Published an interactive dashboard on GitHub Pages, delivering actionable insights to drive revenue growth and profitability.

Check it out!
Valuto: Account Management System

E-Commerce Delivery Performance & Customer Retention Analysis

Using 100,000+ real transactions from Olist, Brazil's largest e-commerce platform, I built an end-to-end analysis uncovering why a business can scale 20x in two years yet remain one late delivery away from losing it all: customers who wait 20+ days give 1-star reviews at nearly twice the rate of those who wait 10, and that single operational metric ripples through satisfaction, retention, and revenue sustainability.

Check it out!
airline-market

Airline Pricing & Market Structure Analysis

Analyzed 31 years of U.S. airline market data (1993–2024) to uncover how competition, route structure, and demand concentration shape pricing power across domestic routes. Using Python (Pandas, Seaborn, Plotly), I identified long-term fare regime shifts, market concentration effects, and post-pandemic recovery patterns—translating complex transportation data into pricing strategy and market intelligence insights.

Check it out!
Perpetual Crusades

Promotional Effectiveness & Demand Response Analysis

   

Evaluated 421K+ weekly retail sales records to assess the true impact of promotional markdowns. Engineered promotional intensity features and applied non-parametric statistical testing to validate significance. Revealed that small discounts fail to shift demand, while deeper markdowns drive measurable sales uplift (p < 0.001). Translated findings into an executive-focused Power BI dashboard to support pricing decisions. Combines statistical rigor with business-driven insight.

Check it out!