Industrial Sales & Logistics Intelligence

This project involved developing a centralized business intelligence solution to monitor sales performance across multiple industrial brands. I managed the end-to-end data pipeline, transforming raw transactional logs into a strategic dashboard for supply chain and sales leadership.

Data Cleaning & Preprocessing:

Standardization: Cleaned and normalized "Line Description" entries to resolve inconsistencies in product naming and part numbers.

Data Integrity: Handled missing values and outliers in quantity and revenue fields to ensure a reliable "single source of truth."

Schema Design: Structured siloed brand data into a unified relational model to allow for cross-brand performance comparisons.

Answering Business Questions:

Brand Performance: Identified which manufacturer brands drive the majority of company revenue and where growth opportunities exist.

Inventory Velocity: Determined which specific parts have the highest turnover rates to assist in warehouse space optimization.

Market Segmentation: Analyzed sales distribution across different customer types (Corporate, Dealer, Govt) to refine B2B marketing strategies.