Developed a 6-page Power BI dashboard analyzing sales, budget, forecast, inventory, production, and logistics performance. Designed a star schema connecting 7 fact tables to shared dimensions and resolved relationship mismatches with a custom Year-Month bridge table.
From the README
Built a 6-page Power BI dashboard analyzing sales, budget, forecast, inventory, production, and logistics performance from a 7-fact-table dataset (Sales, Budget, Forecast, Production, Shipment, Returns, Inventory) spanning 2023–2026. Key work: Designed a star schema connecting 7 fact tables to shared dimensions (Product, Customer, Region, Salesperson, Warehouse, Plant, Transport), including a custom Year-Month bridge table to resolve relationship mismatches between Budget/Forecast (Year+MonthNo grain) and the Date dimension. Diagnosed and fixed a relationship fan-out bug causing Budget figures to be double-counted by region. Identified and resolved ambiguous relationship paths (two...
