Overview:
Developed an end-to-end analytics solution for Authentic Stores, integrating multiple retail data sources into a centralized Azure SQL Database. Designed the database schema for sales, inventory, and customer transactions, and implemented ETL pipelines for automated data ingestion and transformation.

Key Deliverables:

Designed normalized and scalable Azure Database schema for retail data.

Built Python/Azure Data Factory pipelines for daily ETL operations.

Developed interactive Power BI dashboards for store performance, sales trends, and inventory tracking.

Delivered automated refresh workflows and role-based data access for management teams.

Impact:
Enabled data-driven decision making through real-time insights into store operations, resulting in improved stock management and sales forecasting accuracy.