Data Analysis: Project Overview Dashboard

The goal of this project was to create a Project Overview Dashboard to help the client manage their workforce, monitor project health, and understand financial risks. The dashboard was designed to provide insights into which projects and departments were at risk of being over budget or underperforming, enabling stakeholders to take corrective actions.

Dear Data Analyst,

Your expertise is needed in organizing the data and developing the dashboard will be key to helping us manage our workforce, understand financial risks, and monitor project health more effectively. We are looking to answer the following key question: Which projects and departments are at risk of being over budget or underperforming? Note that department budgets are set at 2-year intervals. We want to know if a year can cover all expenses

Manager.

1. Build a Database

2. Develop SQL Queries

3. Connect Power BI to DB

4. Build a Dashboard in Power BI

At-Risk Projects and Departments: The dashboard successfully identified projects and departments that were over budget or underperforming, allowing stakeholders to take corrective actions. For example, it highlighted departments where the annual budget was insufficient to cover expenses within the 2-year cycle.

Budget Utilization: The dashboard provided a clear view of budget utilization across departments, helping the client understand where funds were being over or underutilized.

Employee Performance: Insights into employee performance and salary distribution were visualized, enabling the client to optimize workforce allocation and address any discrepancies.

Project Health Monitoring: The dashboard allowed stakeholders to monitor the overall health of projects, including timelines, resource allocation, and financial performance.

At-Risk Projects: A section of the dashboard highlighted projects that were over budget or underperforming, color-coded for easy identification

Department Budgets: The dashboard displayed budget utilization by department, showing whether the annual budget was sufficient to cover expenses within the 2-year cycle.

Employee Performance: Metrics related to employee performance and salary distribution were visualized, helping the client optimize workforce management.

Interactive Filters: Users could filter data by department, project, or time period to focus on specific areas of interest.

The Project Overview Dashboard provided the client with a powerful tool to monitor project health, manage budgets, and optimize workforce allocation. By identifying at-risk projects and departments, the dashboard enabled stakeholders to take timely corrective actions, ensuring better financial control and project management. The interactive and visually intuitive design of the dashboard made it easy for stakeholders to access and interpret key insights, improving overall decision-making.