KPI dashboards in SCADA systems - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a KPI card showing the current temperature.

SCADA systems

kpi_card = createKPI(title="Temperature", value=[1])

Drag options to blanks, or click blank then click option'

Acurrent_temp

Baverage_temp

Cmax_temp

Dmin_temp

Attempts:

3 left

💡 Hint

Common Mistakes

Using average or max temperature instead of the current value.

Confusing variable names.

The KPI card should display the current temperature, so current_temp is the correct value.

2fill in blank

medium

Complete the code to calculate the uptime percentage for the last 24 hours.

SCADA systems

uptime_percentage = ([1] / total_time) * 100

Drag options to blanks, or click blank then click option'

Aidle_time

Bdowntime

Cmaintenance_time

Duptime

Attempts:

3 left

💡 Hint

Common Mistakes

Using downtime instead of uptime in the calculation.

Forgetting to multiply by 100 to get a percentage.

Uptime percentage is calculated by dividing the uptime by total time, then multiplying by 100.

3fill in blank

hard

Fix the error in the DAX measure to calculate average pressure.

SCADA systems

AveragePressure = AVERAGE([1][Pressure])

Drag options to blanks, or click blank then click option'

ASensors

BPressureReadings

CSensorData

DPressureData

Attempts:

3 left

💡 Hint

Common Mistakes

Using a wrong or non-existent table name.

Misspelling the table name.

The correct table name is SensorData which contains the Pressure column.

4fill in blank

hard

Fill both blanks to create a filter that shows only alarms with severity higher than 3.

SCADA systems

FilteredAlarms = FILTER(Alarms, Alarms[Severity] [1] [2])

Drag options to blanks, or click blank then click option'

A>

B3

C<

D5

Attempts:

3 left

💡 Hint

Common Mistakes

Using less than operator instead of greater than.

Using wrong threshold values.

The filter should select alarms where severity is greater than 3, so use > and 3.

5fill in blank

hard

Fill all three blanks to create a measure that counts faults occurring in the last 7 days.

SCADA systems

FaultCountLast7Days = CALCULATE(COUNT(Faults[ID]), FILTER(Faults, Faults[Date] [1] TODAY() [2] 7 && Faults[Date] [3] TODAY()))

Drag options to blanks, or click blank then click option'

A>=

B-7

C-

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong comparison operators.

Not subtracting 7 days correctly.

Mixing up the order of operators.

The filter checks faults where the date is greater or equal to 7 days ago (TODAY() - 7) and less or equal to today.