Interactive Dashboard

Real-time project insights with embedded Power BI

📈 Project Progress Dashboard

Live Data
📊 Progress Tracking
⚠️ Overdue Alerts
👥 Resource Load
🎯 Priority Filter

Methodology

Systematic approach from raw data to insights

1

Data Extraction

Source data from Excel with 100+ task records

  • Excel Workbook connection
  • Multiple project buckets
  • 8 original data fields
2

Power Query Transformation

ETL pipeline using M language

  • Removed Description column
  • Standardized date formats
  • Created Priority dimension
3

DAX Data Modeling

Advanced calculations and relationships

  • Custom Date table with CALENDAR()
  • Active/Inactive relationships
  • Late task detection measure
4

Visualization & Deployment

Interactive dashboard on Azure

  • Responsive web design
  • Multi-select slicers
  • CI/CD with GitHub Actions

Data Architecture

Star schema with role-playing date dimension

Dimensional Model (Star Schema)

FACT: Tasks
🔑 TaskID PK
TaskName
Project
AssignedTo
🔗 PriorityID FK→
📅 DueDate Active→Date
📅 CreatedDate Inactive→Date
📅 CompletedDate Inactive→Date
⚡ Late Calc
▶
Many-to-One
▶
Many-to-One (3x)
DIM: Priority
🔑 PriorityID PK
PriorityName
SortOrder
DIM: Date (Role-Playing)
🔑 Date PK
Year
Month
Quarter
DayName
Used for Due, Created, Completed dates
Active DueDate → Date (Default filtering)
Inactive CreatedDate → Date (USERELATIONSHIP)
Inactive CompletedDate → Date (USERELATIONSHIP)

📐 Key DAX Measures

Date Table Creation 
Date = CALENDAR(
    MIN(Tasks[Start Date]),
    MAX(Tasks[Due Date])
)

Year = YEAR([Date])
Month = FORMAT([Date], "MMMM")
Quarter = "Q" & QUARTER([Date])
Late Task Detection 
Late = 
VAR DueDate = Tasks[Due Date]
VAR CompletedDate = Tasks[Completed Date]
VAR IsCompleted = NOT(ISBLANK(CompletedDate))

RETURN
    IF(
        IsCompleted && CompletedDate > DueDate, TRUE(),
        IF(!IsCompleted && DueDate < TODAY(), TRUE(), FALSE())
    )

Data & Downloads

Explore source data and download the Power BI report

📊 Project Data (Excel)

OneDrive Embedded

Interactive Excel workbook embedded from OneDrive.Explore the source dataset used for this analysis.

📊

Power BI Report

Full .pbix file with complete data model, DAX measures, and visualizations

2.4 MB .pbix
Download Report

🛠️ Technology Stack

☁️

Azure Static Web Apps

Free tier hosting with global CDN

📊

Power BI Embedded

Interactive visualizations

🔄

GitHub Actions

CI/CD automation

💾

OneDrive

Excel embedding & file storage

Get In Touch

Interested in discussing this project?

📧 hugo777dupreez@gmail.com 💼 LinkedIn 🐙 GitHub