Global Retail 360 - BI & Supply Chain Analytics
End-to-end Business Intelligence solution analyzing the impact of logistics performance on financial profitability using Talend, PostgreSQL, and Power BI.
Designed and implemented a complete BI architecture for 'Global Superstore' to solve a critical business issue: stagnating profit margins despite revenue growth. The project involved integrating heterogeneous data sources—transactional sales (CSV), HR targets (Excel), and semi-structured logistics return logs (XML). I engineered a complex ETL pipeline using Talend Open Studio to parse and merge these datasets into a PostgreSQL Data Warehouse modeled with a Kimball Star Schema. The final output is a suite of interactive Power BI dashboards using advanced DAX calculations to reveal correlations between shipping delays and product return rates, enabling data-driven strategic decisions.
The Problem
The company faced high operational costs and unclear causes for product returns. Data was siloed in disparate formats: ERP exports in CSV, manual HR files in Excel, and complex logistics logs in XML, making it impossible to correlate shipping delays with financial losses.
The Solution
Implemented a centralized Data Warehouse with a robust ETL process capable of parsing XML and handling data quality issues. Created a specialized 'Supply Chain' dashboard in Power BI that identifies specific products ('Top Offenders') and shipping modes causing margin erosion.
Year
2026
Role
Lead Developer responsible for the ETL architecture (Talend), Database Modeling (SQL), and the implementation of DAX measures for Time Intelligence analysis.
Tech Stack
Business IntelligenceETLTalend Open StudioPower BIPostgreSQLData WarehousingXML ParsingDAXPythonStar Schema
Links