Performance of the company

:Using Import Mode in Power BI, I connected to the following tables

vw_DimProducts

vw_DimSalesPersons

vw_DimShipMethods

vw_DimStatuses

vw_DimTerritories

vw_FactOrderDetails

DimDate (created using DAX)

Report Pages:

Overall Company Performance:

Visualized sales across different territories, salespersons, and product categories.

Analyzed order frequency and top-performing products.

Created KPIs to monitor revenue, order count, and sales trends.

Operations Report:

Evaluated sales team performance with metrics comparing current vs. previous month and quarter.

Included visual comparisons of individual salespersons' performance against their peers.

Designed a rewards system based on performance metrics to identify top performers.

Inventory Report:

Provided an in-depth view of product inventory levels.

Analyzed product demand and stock levels to optimize inventory management.

Visuals included stock turnover rates, inventory value over time, and low-stock alerts.

User-Friendly Interface: All visuals were carefully organized and formatted for clarity, making it easy to derive insights at a glance.

Cross-Page Filters: Implemented synced filters across all pages, ensuring a seamless analysis experience. Users can carry their filters (e.g., date ranges, specific products) across different report pages effortlessly.

Responsive Visuals: The report dynamically adjusts to filter selections, offering an interactive and customizable analysis experience.

Designed a Star Schema model to optimize performance and ensure a clean, intuitive data structure.

Used DAX to create calculated columns and measures for more granular analysis.

Leveraged Power BI’s import mode for efficient data processing and visualization.

This project not only demonstrated the power of data visualization but also highlighted the value of integrating operational and inventory insights into strategic decision-making. The final report serves as a comprehensive tool for monitoring company performance, evaluating sales operations, and managing inventory.