This project presents business performance dashboard for a client created using Power BI and SQL. The dashboard offers actionable insights into key operational metrics across regions, departments, clients, and time periods.
This dashboard enables to:
- Monitor operational efficiency across regions
- Evaluate client satisfaction and revenue contributions
- Track project distribution and performance by department
- Identify top-performing clients and detect risk trends
- Provide recommendations to optimize time, resources, and satisfaction
The result is an interactive dashboard built in Power BI, connected to a 200K-row dataset, with clean design, dynamic filters, and data storytelling that supports executive-level decisions.
The dataset includes historical and active project data with the following fields:
- 📅 Project timeline (StartDate, EndDate)
- 🌍 Region & Department
- 🧾 Project Status: Completed, In Progress, At Risk
- 💰 Revenue
- ⏱ Duration in days
- 😊 Client Satisfaction Score (1–5)
- 👥 Client Name, Consultant Count
- Insight: North America leads in revenue and has the highest satisfaction score.
- ✅ Recommendation: Focus expansion and client retention efforts in this region.
- Insight: APAC shows the lowest satisfaction score despite a comparable number of projects.
⚠️ Recommendation: Conduct qualitative analysis to understand root causes.
- Insight: In Progress and Completed projects average 914 days, while At Risk projects show slight deviation.
- ✅ Recommendation: Improve planning for early-stage projects and review At Risk handling procedures.
- Insight: Top 5 clients contribute the largest revenue portion, with steady performance.
- ✅ Recommendation: Establish tailored communication and VIP management plans for them.
- Insight: Balanced project count across departments, with slight revenue variation.
- ✅ Recommendation: Maintain resource allocation, with slight revenue optimization strategies per team.
- Insight: 33% of projects are flagged "At Risk" — which may indicate overly sensitive classification criteria
- Power BI: Data modeling, DAX calculations, dashboard design
- SQL (MySQL): Subqueries, CTE alternatives, filtering, aggregations
- **Power Query **
- Excel: Data exploration
- Git & GitHub: Version control and publishing
👉 Final version of the interactive dashboard
- Clone this repository
- Open the
.pbixfile in thedashboard/folder using Power BI Desktop - Interact with slicers for:
- 📅 Year
- 📍 Region
- 🏢 Department
- 📊 Project Status
- Explore KPIs, satisfaction metrics, trends, and strategic client insights
- Export visuals or customize the dashboard for internal use
marijatech