📊 Retail Construction Project Dashboard

📝 Executive Summary

This Power BI solution is designed to track high-value retail construction projects in real-time. It monitors the lifecycle from Tendering to Execution, providing stakeholders with immediate visibility into Schedule Variance (SV), financial milestones, and S-Curve progress trends.

The dashboard handles complex logic, including automatic timezone adjustments (PKT) and dynamic forecasting based on current delay rates.

---

📷 Dashboard Previews

1. Executive Summary View

High-level overview tracking multiple projects across Retail and Infrastructure sectors with baseline dates, variance calculations, and project status.

2. Project Detail with S-Curve Analysis

Detailed project view showing progress tracking, S-Curve visualization (Planned vs Actual cumulative %), variance metrics, and granular activity breakdown.

(Note: Sensitive project names have been partially obscured for privacy)

---

🚀 Key Features

📅 Advanced Schedule Tracking

• S-Curve Visualization: Plots "Planned (cum.)" vs "Actual (cum.)" to visually detect deviation trends.
• Variance Logic: Automatically flags projects as "Behind Schedule" if the variance exceeds defined thresholds (e.g., -101 Days).
• Forecasted Dates: Dynamically calculates "Expected Finish" dates based on current slip rates.

🧠 Intelligent DAX Logic

• Timezone Awareness: All "Today" calculations automatically adjust to UTC+5 (Pakistan Standard Time) to ensure reporting accuracy relative to the project site.
• Dynamic Statusing: Categorizes projects into pipelines (e.g., "Under Tendering", "On Track", "CB Opened") based on string search algorithms.
• Conditional Formatting: The matrix visual automatically detects "Header" rows vs "Data" rows to apply specific background colors (Grey for headers, White for data).

🏷️ Granular Activity Matrix

• Drill-down capability into specific phases:
  • Construction Phase
  • Execution Phase
  • Survey & Layout
• Tracks % Planned vs % Completed at the individual task level.

---

🛠️ Technical Implementation

Data Model

• Project_schedules: Contains the core Gantt data (Actual Start, Baseline Finish, Days Delayed).
• Project Timeline: Tracks the tendering status and approval gates (LOI, MPC, PO Issued).
• DateTable: Custom date dimension with timezone-aware calculations.

Highlighted Formula: Dynamic Schedule Variance

This measure calculates variance using SUMX for row-level accuracy and adjusts for the PKT timezone.

Schedule Variance (SUM) = 
SUMX(
    'Project_schedules',
    VAR ActualFinishDate = 'Project_schedules'[Actual_Finish]
    VAR BaselineFinishDate = 'Project_schedules'[Baseline_Finish]
    
    -- Adjusting UTC to Pakistan Standard Time (UTC+5)
    VAR TodayInPKT = DATE(YEAR(UTCNOW() + TIME(5, 0, 0)), MONTH(UTCNOW() + TIME(5, 0, 0)), DAY(UTCNOW() + TIME(5, 0, 0)))
    
    RETURN
    IF(
        NOT ISBLANK(ActualFinishDate), 
        DATEDIFF(ActualFinishDate, BaselineFinishDate, DAY), 
        DATEDIFF(TodayInPKT, BaselineFinishDate, DAY)
    )
)

(See docs/measures.md for the full code documentation)

---

💻 How to Use

1. Clone this repository.
2. Open the .pbix file located in the src/ folder.
3. Refresh the dataset (Requires connection to the source SQL/Excel data).

---

📚 Documentation

• DAX Measures Documentation - Complete formula reference
• Data Dictionary - Table and column descriptions
• Integration Workflow - MS Project to Power BI data pipeline

---

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

---

👤 Author

Created as part of a professional Power BI portfolio showcasing advanced DAX techniques, timezone handling, and construction project management expertise.