ALL CASE FILES
★
2025
RetailIQ — E-Commerce Sales Intelligence
SLUGretailiq-ecommerce-bi
> C-suite BI on 100K+ Olist orders — SQL/dbt on BigQuery, Airflow ETL, Power BI dashboards driving an 18% drop in late delivery.
// OVERVIEW.MD3 BLOCKS
$ RetailIQ is an executive analytics suite I built on the Olist E-Commerce dataset (100K+ orders). I modeled the data with SQL and dbt on BigQuery, orchestrated ETL pipelines with Airflow plus data-governance checks, and identified 3 underperforming categories driving 23% of returns.
Designed a C-suite Power BI dashboard with DAX KPI measures, Power Query transforms, trend & variance analysis, and segmentation — delivering recommendations that reduced late delivery rate by 18%.
Pure data storytelling: from raw warehouse to actionable boardroom narrative.
// WHAT_IT_DOES6 BEATS
- 01> 100K+ orders modeled with SQL + dbt on BigQuery
- 02> Airflow ETL with data-governance checks
- 03> Power BI dashboard with DAX KPI measures
- 04> Trend, variance & segmentation analysis
- 05> Identified 3 categories driving 23% of returns
- 06> Delivered an 18% reduction in late delivery rate
