Microair Avionics Sales & Operation Dashboard

From sales performance to operational efficiency — a unified view in one dashboard.

This dashboard was built in Power BI to meet stakeholder needs, and is now actively used by the Microair team. It’s accessible both on company TV displays and directly through Business Central.

Dataset Overview

This dashboard was developed in Power BI using data extracted from Microsoft Dynamics 365 Business Central. Six core tables were modeled and joined through a dedicated Date table, enabling consistent time-based analysis. Unique identifiers such as Document No. and Item No. were used to establish relationships across sales, outstanding orders, customers, and product details.

📌Data Quality

✅ Missing Values: Excluded unused columns

✅ Date Consistency: Fixed with dedicated Date table

✅ Data Types: Adjusted accordingly

✅ Duplicates: Removed where necessary

✅ NaN Values: 0

📌 Outlier Detection

Retained as they represent real transactions.

Key Properties

Auto-refresh → Ensures data is always up to date by updating every 2 hours.

Integration → Direct link with Business Central eliminates manual data entry.

Interaction → interactive filters and drill-downs let users explore by date, product, or customer.

🚀 Shows completed sales performance over time, with graphs highlighting seasonality and sales fluctuations.

🚀 Compares sales against budget, revealing areas of underperformance and adjustment needs.

🚀 Identifies most valuable customers and top-selling products, supporting strategic focus.

🚀 Highlights how the operations team is meeting current demands.

🚀 Compares outstanding items against promised delivery dates to track on-time vs late orders.

🚀 Provides an item-level view, supporting better resource allocation and delivery planning.

Recommendations

Sales performance should be aligned more closely with budget expectations while focusing on higher-value customers and products. At the same time, improving delivery timeliness on outstanding orders will strengthen operational efficiency and customer satisfaction.

Page updated

Google Sites

Report abuse