Sales Dashboard from OLTB database

Built an interactive Power BI dashboard from OLTP DirectQuery to ensure real-time data updates.

Data was sourced from key tables such as SalesOrderHeader, SalesOrderDetail, SalesPerson, and others.

The data model was structured into a star schema, with tables and columns cleaned and renamed for clarity.

The dashboard visualizes crucial metrics like order counts, sales performance, and top 10 salespersons, providing actionable insights across various dimensions such as order dates, shipment methods, and product categories.