Skip to content

Latest commit

 

History

History
54 lines (31 loc) · 2.33 KB

File metadata and controls

54 lines (31 loc) · 2.33 KB

ACCIO_JOB_CAPSTONE_PROJECT

An interactive Power BI dashboard built using the Northwind dataset to provide insights into sales performance, customer behavior, inventory management, and employee productivity. This report is designed to support data-driven decision-making for stakeholders in the wholesale trading business.

📁 Dataset Overview The data is based on the fictional Northwind Traders company, which imports and exports specialty foods globally. It includes several relational tables covering customers, orders, products, employees, suppliers, and more.

Tables Used:- Customers: Customer details and contact info

Employees: Employee profiles and reporting structure

Orders: Order transactions with customer/employee linkage

Order Details: Products and quantities per order

Products: Product specifications and pricing

Suppliers: Supplier details for products

Shippers: Shipping company information

Categories: Product category metadata

🎯 Project Goals Provide an intuitive view of business performance

Highlight trends in sales, customer segments, and inventory

Assess employee contributions and efficiency

Enable interactive exploration with filters and slicers

Empower stakeholders to make informed, data-driven decisions

📌 Key Dashboard Features 📈 Sales Analysis: Track revenue, trends, top customers & regions

🧑‍🤝‍🧑 Customer Segmentation: Group customers by sales value, location, or order frequency

📦 Inventory Trends: Identify best-selling products and monitor stock levels

👨‍💼 Employee Performance: Visualize order fulfillment and sales by employees

🔍 Dynamic Filtering: Drill down with slicers for date, category, region, and more Screenshot 2025-05-05 203047 Screenshot 2025-05-03 200054 Screenshot 2025-05-03 204241

Screenshot 2025-05-03 200546

Screenshot 2025-05-03 202435 Screenshot 2025-05-03 200939