Business Intelligence Dashboards
Power BI dashboards across sales, warehouse, order, and telecom operations
Four Power BI dashboards, each modeling a different operational domain end to end: data import, DAX measures, and an interactive multi-page report built around a specific decision-maker’s KPIs.
Sales Analysis
Revenue, unit, and customer-segmentation tracking (active/inactive/new) alongside shipment performance (on-time vs. late %), returned-order analysis, top-selling items by salesperson, and yearly sales/profit trends.
Code: github.com/awais-de/SalesAnalysis
Order Overview Analysis
Order volume, units dispatched, and revenue gauges against in-house vs. outsourced production breakdown, order-inquiry status (in consideration / processing / completed), top-10 products by inquiry, and city-wise order distribution.
Code: github.com/awais-de/OrderOverviewAnalysis
Warehouse Analysis
Top-25 shipped customers, inventory levels against order fulfillment, delivery-method breakdown (courier / delivery / collect), a waterfall of return reasons, and on-time vs. late shipment rates.
Code: github.com/awais-de/WarehouseAnalysis
Mobile Network (Telecom) Analysis
Four-tab report — thorough analysis, personal details, quick insights, detailed view — covering total calls/SMS/data usage, peak calling times, device/network popularity, and geographic call-intensity distribution across a 100k-row call-detail-record dataset.
Code: github.com/awais-de/TelecomAnalysis
Stack
Power BI Desktop, DAX, Power Query.
Status
Complete.