Master end-to-end inventory analytics with this hands-on portfolio project built using Microsoft Excel, PostgreSQL, and Power BI.

This project simulates a real business inventory management scenario, guiding you through the complete analytics workflow—from data preparation to dashboard development and business insights.

What You'll Learn

1. Excel data cleaning and validation
2. Importing data into PostgreSQL
3. SQL analysis for inventory reporting
4. Power BI dashboard creation
5. DAX measures and KPI development
6. Interactive slicers and bookmarks
7. Dynamic titles and business insights
8. Inventory health monitoring
9. Professional dashboard design

Dashboard Features

1. 📦 Total Inbound KPI
2. 🚚 Total Outbound KPI
3. 📊 Net Stock KPI
4. 📈 Inventory Status KPI
5. Warehouse Performance Analysis
6. Top Moving Products
7. City-wise Demand Analysis
8. Monthly Inventory Trend
9. Dynamic Dashboard Title
10. Dynamic Insights
11. Interactive Slicers
12. Clear Filters Button

Included Files

1. Power BI (.pbix)
2. Clean Dataset (.csv)
3. PostgreSQL SQL Queries (.sql)
4. Dashboard Screenshot
5. GitHub README
6. Project Report (PDF)

Tools Used

1. Microsoft Excel
2. PostgreSQL
3. Microsoft Power BI
4. DAX

Perfect For

1. Data Analyst Aspirants
2. College Students
3. Job Seekers
4. Portfolio Building
5. Power BI Practice
6. SQL Learning
7. Interview Preparation

📂 Deliverables

1. TechMart_Inventory_Analysis.pbix
2. TechMart_Warehouse_Dataset.csv
3. Techmart_analysis.sql
4. TechMart_Inventory_Analysis_Report.pdf
5. Dashboard_Screenshot.png
6. README.md