Shutdown / Turnaround / Outage Dashboard

Description: Asset intensive organizations (utilities) can leverage this dashboard to track activities scheduled, performed, resources assigned, etc. in a very granular format during shutdown, turnaround, outage periods.

Number of Canvases: 2

Default Canvas: By Resource (Dropdown)

Canvas/Dashboard Name: Shutdown/Turnaround/Outage

Data Source(s): P6 - EPPM

Subject Area: P6 – Activity

Datasets: Not applicable

Dashboards

Shutdown Turnaround Outage By Reource Dropdown

Figure 22: Shutdown / Turnaround / Outage Dashboard - By Resource (Dropdown)

Shutdown Turnaround Outage Dashboard By Reource Trellis

Figure 23: Shutdown / Turnaround / Outage Dashboard - By Resource (Trellis)

Table 27: Shutdown / Turnaround / Outage - Dimensions

Canvas

Dimension / Attribute

Subject Area / Dataset

All Canvas

Calendar Date

P6 – Burn Down

All Canvas

Activity > Finish

P6 – Burn Down

All Canvas

Primary Resource

P6 – Burn Down

All Canvas

Project > Workdown Date

P6 – Burn Down

Table 28: Shutdown / Turnaround / Outage – Measures

Canvas

Fact / Measure

Measure Type

Subject Area / Dataset

All Canvas

Emergent Remaining Units Burn

Fact

P6 – Burn down

Table 29: Shutdown / Turnaround / Outage – Filters

Canvas

Filter Type

Is Expression Filter

Dimension / Attribute / Measure

Subject Area / Dataset

All Canvas

Dashboard

No

Project Name

P6 – Burn down

All Canvas

Dashboard

No

Primary Resource

P6 – Burn down

All Canvas

Dashboard

No

Week Name

P6 – Burn down

All Canvas

Visual

Yes

CASE WHEN "Primavera - Burn Down"."Dates - (Activity)"."Finish" > "Primavera - Burn Down"."Dates - (Project)"."Workdown Date" THEN 1 ELSE 0 END = 1

P6 – Burn down

Table 30: Shutdown / Turnaround / Outage – Calculated Members

Calculated Member

Expression

Source

Subject Area / Dataset

Original Remaining (hours)

CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Burn Down"."Calendar"."Calendar Date", "Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN "Primavera - Burn Down"."Units"."Non-Emergent Remaining Units Burn" + CASE WHEN TIMESTAMPDIFF(SQL_TSI_DAY, "Primavera - Burn Down"."Calendar"."Calendar Date", "Primavera - Burn Down"."Dates - (Project)"."Data Date") = 0 AND "Primavera - Burn Down"."Metrics"."New Record Count" = 0 THEN "Primavera - Burn Down"."Units"."Remaining Units" ELSE 0 END ELSE NULL END

 

Derived From Fact

P6 - Burn Down

Emergent Remaining (hours)

CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Burn Down"."Calendar"."Calendar Date", "Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN "Primavera - Burn Down"."Units"."Emergent Remaining Units Burn" + CASE WHEN TIMESTAMPDIFF(SQL_TSI_DAY, "Primavera - Burn Down"."Calendar"."Calendar Date", "Primavera - Burn Down"."Dates - (Project)"."Data Date") = 0 AND "Primavera - Burn Down"."Metrics"."New Record Count" > 0 THEN "Primavera - Burn Down"."Units"."Remaining Units" ELSE 0 END ELSE NULL END

 

Derived From Fact

P6 – Burn down

Original and Emergent Remaining (hours)

(CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Burn Down"."Calendar"."Calendar Date", "Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN "Primavera - Burn Down"."Units"."Non-Emergent Remaining Units Burn" + CASE WHEN TIMESTAMPDIFF(SQL_TSI_DAY, "Primavera - Burn Down"."Calendar"."Calendar Date", "Primavera - Burn Down"."Dates - (Project)"."Data Date") = 0 AND "Primavera - Burn Down"."Metrics"."New Record Count" = 0 THEN "Primavera - Burn Down"."Units"."Remaining Units" ELSE 0 END ELSE NULL END)+ (CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Burn Down"."Calendar"."Calendar Date", "Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN "Primavera - Burn Down"."Units"."Emergent Remaining Units Burn" + CASE WHEN TIMESTAMPDIFF(SQL_TSI_DAY, "Primavera - Burn Down"."Calendar"."Calendar Date", "Primavera - Burn Down"."Dates - (Project)"."Data Date") = 0 AND "Primavera - Burn Down"."Metrics"."New Record Count" > 0 THEN "Primavera - Burn Down"."Units"."Remaining Units" ELSE 0 END ELSE NULL END)

Derived From Fact

P6 – Burn down

Baseline Work Down

"Primavera - Burn Down"."Units"."Baseline Units Burn"

 

P6 – Burn down

Total Man Hours

CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR,"Primavera - Burn Down"."Calendar"."Calendar Date","Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN "Primavera - Burn Down"."Units"."Remaining Units Burn" + "Primavera - Burn Down"."Units"."Actual Units Burn" + CASE WHEN TIMESTAMPDIFF(SQL_TSI_DAY,"Primavera - Burn Down"."Calendar"."Day Date","Primavera - Burn Down"."Dates - (Project)"."Data Date") = 0 AND HOUR("Primavera - Burn Down"."Dates - (Project)"."Data Date") <> 0 THEN "Primavera - Burn Down"."Units"."Remaining Units" ELSE ("Primavera - Burn Down"."Units"."Actual Period Units" - "Primavera - Burn Down"."Units"."Actual Units") END ELSE NULL END

 

P6 – Burn down

Current Work Down

CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR,"Primavera - Burn Down"."Calendar"."Calendar Date","Primavera - Burn Down"."Dates - (Project)"."Data Date") <= 0 THEN "Primavera - Burn Down"."Units"."Remaining Units Burn" ELSE NULL END

Derived From Fact

P6 – Burn down

Original Remaining (count)

CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Burn Down"."Calendar"."Day Date","Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN "Primavera - Burn Down"."Metrics"."Non-Emergent Remaining Count" ELSE NULL END

Derived From Fact

P6 – Burn down

Emergent Remaining (count)

CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Burn Down"."Calendar"."Day Date","Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN "Primavera - Burn Down"."Metrics"."Emergent Remaining Count" ELSE NULL END

Derived From Fact

P6 – Burn down

Original and Emergent Remaining (count)

(CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Burn Down"."Calendar"."Day Date","Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN "Primavera - Burn Down"."Metrics"."Non-Emergent Remaining Count" ELSE NULL END)+(CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR, "Primavera - Burn Down"."Calendar"."Day Date","Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN "Primavera - Burn Down"."Metrics"."Emergent Remaining Count" ELSE NULL END)

Derived From Fact

P6 – Burn down

Baseline Work Down (count)

"Primavera - Burn Down"."Metrics"."Baseline Not Started Count" + "Primavera - Burn Down"."Metrics"."Baseline In Progress Count"

Derived From Fact

P6 – Burn down

Current Work Down (count)

SUM(CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR,"Primavera - Burn Down"."Calendar"."Calendar Date","Primavera - Burn Down"."Dates - (Project)"."Data Date") <= 0 THEN CASE WHEN TIMESTAMPDIFF(SQL_TSI_MINUTE,"Primavera - Burn Down"."Calendar"."Calendar Date","Primavera - Burn Down"."Dates - (Activity)"."Planned Finish") > 1440 AND "Primavera - Burn Down"."General - (Activity)"."Activity Status" <> 'Completed' THEN 1 ELSE 0 END ELSE NULL END)

Derived From Fact

P6 – Burn down

Total # of Activities

SUM(CASE WHEN TIMESTAMPDIFF(SQL_TSI_HOUR,"Primavera - Burn Down"."Calendar"."Calendar Date","Primavera - Burn Down"."Dates - (Project)"."Data Date") > 0 THEN 1 ELSE NULL END)

Derived From Fact

P6 – Burn down

Original Schedule and Completed

"Primavera - Burn Down"."Metrics"."Scheduled and Completed Count"

Derived From Fact

P6 – Burn down

Original Schedule and Not Completed

"Primavera - Burn Down"."Metrics"."Scheduled and Not Completed Count"

Derived From Fact

P6 – Burn down

Emergent and Completed

"Primavera - Burn Down"."Metrics"."Not Scheduled and Completed Count"

Derived From Fact

P6 – Burn down

Total Scheduled

"Primavera - Burn Down"."Metrics"."Scheduled and Completed Count"+"Primavera - Burn Down"."Metrics"."Scheduled and Not Completed Count"

Derived From Fact

P6 – Burn down

Original Schedule Compliance %

CASE WHEN ("Primavera - Burn Down"."Metrics"."Scheduled and Completed Count"/("Primavera - Burn Down"."Metrics"."Scheduled and Completed Count"+"Primavera - Burn Down"."Metrics"."Scheduled and Not Completed Count")) IS NULL THEN 0 ELSE ("Primavera - Burn Down"."Metrics"."Scheduled and Completed Count"/("Primavera - Burn Down"."Metrics"."Scheduled and Completed Count"+"Primavera - Burn Down"."Metrics"."Scheduled and Not Completed Count")) END

Derived From Fact

P6 – Burn down

Related Topics

Data Visualizations Using P6 EPPM Data

Cost Overview Dashboard

Earned Value and Risk Analysis Dashboard

Overview - Portfolio, Risk, EV

Key Milestones Tracking Dashboard

Integrated Schedule Delivery KPI Dashboard

Activity Look Ahead Dashboard

Labor Units History Dashboard

CPI, SPI, and Labor Units Dashboard

Project Risk - Cost Overview Dashboard

Project Health Assessment Dashboard


Last Published Friday, December 8, 2023