Popular repositories Loading

1. PigmentSquad-Products-DA-PBI PigmentSquad-Products-DA-PBI Public

   End-to-end Power BI reporting system for a retail startup, using R for data cleaning and custom DAX logic to classify 200+ products, reveal seasonal demand patterns, and guide data-driven restockin…

   R 1

2. PigmentSquad-StoreHours-DWH-SQL PigmentSquad-StoreHours-DWH-SQL Public

   Building a modern data warehouse with SQL Server, including ETL pipelines (bronze → silver → gold) and data modeling for POS sales data.

   TSQL

3. PigmentSquad-StoreHours-DA-PBI PigmentSquad-StoreHours-DA-PBI Public

   This project analyzes Pigment Squad’s store hours (Jan–Jul 2025) to model staffing cost scenarios and recommend adjustments that save money without hurting sales.

4. Personal-Transactions-DA-PBI Personal-Transactions-DA-PBI Public

   A personal finance analytics project built with SQL, focused on turning raw bank transaction data (Jan–Aug 2025) into structured, meaningful insights.

5. PigmentSquad-StoreHours-DWH-Azure PigmentSquad-StoreHours-DWH-Azure Public

   Cloud-based POS data warehouse built with Azure and Databricks, demonstrating raw data ingestion, layered modelling (Bronze/Silver/Gold), and analytics-ready outputs.

   Jupyter Notebook

6. Personal-Transactions-DWH-Azure-pub Personal-Transactions-DWH-Azure-pub Public

   Azure-based personal transaction data warehouse using Bronze–Silver–Gold architecture, Azure Data Factory, Databricks (PySpark), and Power BI for monthly financial analytics.

   Jupyter Notebook