E-Commerce Data Engineering Pipeline
Building an end-to-end data engineering pipeline to ingest, clean, transform, and validate e-commerce sales data using Python, SQL, and Microsoft Fabric. Implementing a Lakehouse-based data architecture with PySpark and SQL, designing a star-schema data warehouse with fact and dimension tables, and integrating automated data pipelines with Power BI for business insights and visualization.
Real-Time Retail Data Engineering Pipeline
Building a real-time pipeline for simulated retail transactions using Microsoft Fabric, Python, PySpark, and SQL. Implementing transformation, validation, and aggregation workflows; using Eventhouse and KQL for near real-time analysis; and developing Power BI visualizations for transaction volume, revenue, and product performance.
HR Analytics Dashboard
Built an interactive Microsoft Excel dashboard tracking employee count, attrition rate, average salary, department-wise distribution, and gender ratio. Cleaned and prepared HR data using XLOOKUP, IF, SUMIFS, and COUNTIFS, and built Pivot Tables, Pivot Charts, KPI cards, and Slicers.