Mostafizur Rahman

Projects

Case studies

Each case study covers the business question, the data, the method, the result, and its limits, with a focus on turning data into decisions.

6 projects

  • Table of top product categories by gross revenue with cumulative share, highlighting the 18th category where cumulative revenue passes 80 percent.
    Business Intelligence

    Olist E-Commerce Business Performance Analysis

    A SQL analysis: 18 of 74 product categories drove 81.26% of revenue, and reviews fell once delivery passed about 14 days.

    PostgreSQL · SQL · Pareto analysis · KPI reporting

  • Line chart comparing monthly sales history with the SARIMA model fit and forecast.
    Predictive Modeling

    Global Superstore: Sales Analysis & Forecasting

    Daily forecasts failed (MAPE about 126%). Monthly SARIMA reached about 19%, a moderate result on a three-month test.

    Python · pandas · Plotly · statsmodels · pmdarima · SARIMA

  • Chart of customer churn by contract type.
    Machine Learning

    Telco Customer Churn: Analysis & Prediction

    Which customers will leave? Tuned LightGBM reached 0.810 recall; short tenure and month-to-month contracts stood out.

    Python · scikit-learn · LightGBM · XGBoost · SHAP

  • Power BI executive dashboard with KPI cards, a monthly sales area chart, a sales-by-state map, and bar charts by retailer and product category.
    Business Intelligence

    Adidas US Commercial Performance Dashboard

    Revenue is concentrated in a few retailers, and top sellers aren't always the most profitable, shown in Power BI.

    Power BI · DAX · Data cleaning

Send me a message

Choose how you'd like to email mostafiz.r.afraim@gmail.com