Employee Data sales Dashboard

#datascience #dataengineering #python #sql

💼 Employee Sales Dashboard using Power BI

(https://github.com/Ashokkumarrk/Employee_Data_Sales_Dashboard)

📊 Project Overview

This project is an Employee Sales Dashboard built using Power BI, designed to visualize employee performance and sales trends across departments.

It helps businesses make data-driven decisions by identifying top performers and analyzing sales growth patterns.

⚙ Tools & Technologies Used

Power BI – for dashboard design and DAX measures
Excel / CSV dataset – for employee sales data
Power Query – for data transformation and cleaning
DAX – for calculated columns and KPIs

🧩 Dashboard Features

👨‍💼 Employee performance by department
💰 Sales revenue trends (monthly/quarterly/yearly)
🏆 Top-performing employees
📈 Department-wise total sales comparison
📊 Filters for department, region, and performance level

🧮 Key DAX Measures


DAX
Total Sales = SUM(Sales[Amount])
Average Sales = AVERAGE(Sales[Amount])
Total Employees = DISTINCTCOUNT(Employee[EmployeeID])
Performance Score = DIVIDE(SUM(Sales[Amount]), [Average Sales])