Skip to content

mehtabPB/ACCIO_JOB_CAPSTONE_PROJECT

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

About

This project presents an interactive Power BI report built on the classic Northwind database. The objective is to provide a visually appealing, user-friendly dashboard that delivers actionable insights into key performance metrics across sales, customer behavior, inventory, and employee performance.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors