📊 Project Management Analysis - Excel Dashboard

This project provides a comprehensive view of project progress, budget management, and task status using an interactive Excel dashboard. The dashboard was created using the Project-Management.xlsx dataset and provides actionable insights for project tracking.

🗝️ Key Features

• Overall Task Progress: Visualizes task completion status (Not Started, In Progress, Completed).
• Project Progress Overview: Displays the progress of five projects (Alpha, Delta, Gemini, Orion, Vega).
• Budget Analysis: Compares Budget vs Actual expenses and shows the percentage spent.
• Time Tracking: Displays Days Completed vs Days Remaining for active projects.
• Project Managers: Highlights project managers (Hirsch, Ladd, McFay, Samora, Wood).

🛠️ Tools and Excel Features Used

• Pivot Tables: Summarized task progress, project status, and budget utilization.
• Slicers: Enabled filtering by project name and manager.
• Pivot Charts: Used bar and pie charts to visualize budget and progress.
• Conditional Formatting: Highlighted completed vs. remaining tasks.
• Excel Formulas: Used SUMIFS for budget calculations and COUNTIFS for task status.

💡 Insights Gained

• Task Status: Most tasks are either In Progress or Not Started, with few fully completed.
• Budget Performance: Projects have spent 42% of the total budget, with some overspending areas.
• Project Progress: Alpha and Gemini are on track, while Orion lags in completion.
• Timeline Status: Projects are 41% through their timelines on average.

💻 Usage Instructions

• Open the Dashboard: Use the provided Project-Management.xlsx file.
• Apply Slicers: Filter by Project Name and Project Manager.
• Explore Insights: Review charts for task status, budget utilization, and progress.

📝 About the Project

• Tool: Microsoft Excel
• Skills Practiced: Project Tracking, Budget Analysis, Data Visualization
• Dataset: Project-Management.xlsx