This Power BI project presents a real-time inventory and stock monitoring solution powered by automated reporting and robust data integration. Built for dynamic business environments, this dashboard helps track stock levels, monitor movement, and trigger restocking alerts.
- 🔄 Realtime ETL Workflow: Leveraged Azure Data Factory to automate data ingestion and transformation across multiple sources and branches.
- 🗃️ SQL Integration: Backend SQL queries power performance-optimized views and supply chain insights.
- 🧮 DAX & Power Query: Used for advanced calculations, data shaping, and transformation inside Power BI.
- 📈 Automated Dashboards: Refresh-enabled reports with filters for branches, states, and SKUs.
- Overview of current stock positions
- Trendlines for inflow/outflow
- Stock aging and turnover visuals
📷 
- Performance comparison across multiple branches
- Drilldown to product categories and stock value
- Helps regional teams manage local inventory health
📷 
- State-level granularity for warehouse and product analytics
- Identifies geographical overstocking/shortage patterns
📷 
- Power BI Desktop
- Azure Data Factory (ETL pipeline automation)
- SQL Server (Database + Views)
- DAX / Power Query (Calculations & Data Shaping)