Sales dashboard excel
تفاصيل العمل
I designed and organized a sales management database using Excel, which consists of multiple related tables: 1. Customers Table Stores customer information: CustomerID, full name, phone number, country, money transfer method, and email. Includes sample records of customers from different countries (Syria, UAE, Saudi Arabia, Egypt, etc.). 2. Orders Table Contains order details: OrderID, CustomerID, ProductID, quantity, SalesPersonID, order date, status, and total cost. Links customers, products, and employees through their IDs. 3. Employees Table Stores employee details: EmployeeID, full name, email, department, employment status (Full-Time, Part-Time, Contract), hire date, salary, and job rating. 4. Products Table A placeholder for product data (currently empty, but structured to be filled with product information). Key Points: Designed a structured database that connects customers, employees, orders, and products. Established logical relationships using IDs (CustomerID, SalesPersonID, ProductID). Demonstrates how business sales data can be managed and analyzed effectively.
مهارات العمل
بطاقة العمل
طلب عمل مماثل