Lesson 50 — Building an SOC Operations Dashboard
Fifty lessons into the Academy, it is time to bring everything together.
Build an evidence-first SOC operations dashboard that highlights open incidents, ownership, trends, ageing cases and data health.

What you will learn
Turn workbook panels into a usable shift dashboard.
Lesson 50 — A milestone worth investigating
Fifty lessons into the Microsoft Sentinel Academy, Agent Foskett has built detections, investigated incidents and created interactive workbooks. Now we bring those skills together into one SOC operations dashboard that helps an analyst decide what to do next.
What you will build
- An operational incident overview for the selected period.
- A current open-incident triage queue.
- An incident creation trend and severity breakdown.
- An ownership and workload view.
- A sign-in activity panel for supporting context.
- A data-health panel that exposes stale or missing telemetry.
- Clear links from summary to underlying incident evidence.
The operating question
Dashboard versus investigation
A dashboard helps prioritise and navigate. It is not a substitute for the Microsoft Sentinel incident record, investigation graph, alerts, entities or evidence notes. Every summary should offer a clear route to the source investigation.
Prepare your workspace
- Open the workbook created in Lessons 47–49 and save a new copy called SOC Operations Dashboard — Lab.
- Confirm access to the Log Analytics workspace and its Microsoft Sentinel data.
- Verify the
SecurityIncidenttable is present and has records. - Keep your tested time-range control from Lesson 48.
- Choose a lab period that contains incidents; do not use production data in public screenshots.
The queries below target SecurityIncident in a Log Analytics workspace. In this table, updates to an incident can produce multiple records. A current-state dashboard must account for that.
Dashboard layout
Important: incident rows are versioned
A naive count() over SecurityIncident can count updates as separate incidents. For current-state views, select the most recent row per incident using arg_max(TimeGenerated, *) by IncidentNumber in the intended workspace. For historical incident-creation trends, use the incident’s creation timestamp from its latest known row and make the reporting scope explicit.
The examples assume one Sentinel workspace. When querying across workspaces, incident identifiers and aggregation keys need additional care.
Step 1 — Inspect the incident schema
- 1
- 2
- 3
- 4
- 5
- 6
SecurityIncident
| where TimeGenerated > ago(30d)
| project TimeGenerated, IncidentNumber,
Title, Severity, Status,
CreatedTime, Owner
| take 20Confirm the table and fields exist in your workspace before building the visuals. If this returns no rows, inspect your workspace selection, permissions and incident history.
Step 2 — Build a current-state base
- 1
- 2
- 3
- 4
- 5
- 6
SecurityIncident
| summarize arg_max(TimeGenerated, *)
by IncidentNumber
| project IncidentNumber, Title, Severity,
Status, CreatedTime, TimeGeneratedNotice that the current-state query does not filter TimeGenerated to the last 24 hours before selecting the latest row. Doing so could silently omit still-open incidents whose last update happened earlier.
Step 3 — Create operational KPI cards
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
SecurityIncident
| summarize arg_max(TimeGenerated, *)
by IncidentNumber
| where Status != "Closed"
| extend OwnerName = tostring(Owner.assignedTo)
| summarize OpenIncidents = count(),
HighSeverityOpen =
countif(Severity == "High"),
UnassignedOpen =
countif(isempty(OwnerName))Add a query component and use a suitable tile, grid or number-style presentation. Clearly label the measures as current known state, not “incidents created in the last 24 hours”.
Owner field structure and naming can differ by ingestion version. Check the observed Owner value and adapt the extraction if required.
Step 4 — Build the open-incident queue
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
SecurityIncident
| summarize arg_max(TimeGenerated, *)
by IncidentNumber
| where Status != "Closed"
| extend OwnerName = tostring(Owner.assignedTo)
| project IncidentNumber, Title, Severity,
Status, OwnerName, CreatedTime
| order by CreatedTime asc
| take 100Display the table below the KPI cards. Configure sorting and incident-opening links in the workbook editor where supported. The queue is capped for responsiveness; clearly disclose that limit and keep the source incident list accessible.
Step 5 — Explain severity and priority
Severity alone does not define operational priority. Analysts should also consider the incident age, evidence quality, affected entities, business context, active containment needs and available ownership. A high-severity incident may already be assigned and progressing; an older medium-severity incident may need urgent review.
Step 6 — Show the creation trend
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
SecurityIncident
| summarize arg_max(TimeGenerated, *)
by IncidentNumber
| where CreatedTime >= ago(14d)
| summarize IncidentsCreated = count()
by bin(CreatedTime, 1d)
| order by CreatedTime ascUse a time chart titled Incidents created per day — last 14 days. This is a fixed-window teaching example; when publishing, bind the intended time range and validate that the chart reflects the same selection.
Step 7 — Open incidents by severity
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
SecurityIncident
| summarize arg_max(TimeGenerated, *)
by IncidentNumber
| where Status != "Closed"
| summarize OpenIncidents = count()
by Severity
| order by OpenIncidents descUse a bar chart for a clear comparison. Keep the zero baseline and label the measure as open incidents, not “security attacks”.
Step 8 — Ownership and workload
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
SecurityIncident
| summarize arg_max(TimeGenerated, *)
by IncidentNumber
| where Status != "Closed"
| extend OwnerName = tostring(Owner.assignedTo)
| extend OwnerName =
iff(isempty(OwnerName), "Unassigned", OwnerName)
| summarize OpenIncidents = count()
by OwnerName
| order by OpenIncidents descA workload view helps a shift lead spot unassigned work and uneven distribution. It is not a productivity ranking: complexity and case age differ.
Step 9 — Find older open incidents
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
SecurityIncident
| summarize arg_max(TimeGenerated, *)
by IncidentNumber
| where Status != "Closed"
| extend AgeDays =
datetime_diff("day", now(), CreatedTime)
| project IncidentNumber, Title, Severity,
Status, AgeDays, CreatedTime
| order by AgeDays desc
| take 50This helps identify work that may need review. The age calculation measures calendar-day difference from creation, not time since assignment or time actively worked.
Step 10 — Add supporting identity context
- 1
- 2
- 3
- 4
- 5
- 6
- 7
SigninLogs
| where TimeGenerated > ago(24h)
| where ResultType != "0"
| summarize FailedSignIns = count()
by bin(TimeGenerated, 1h)
| order by TimeGenerated ascPlace this in a clearly separated Identity signal section. It provides context but is not automatically linked to any particular incident. Do not infer causation from nearby spikes.
Step 11 — Data freshness is operational evidence
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
union isfuzzy=true
(SecurityIncident
| summarize Latest = max(TimeGenerated)
| extend Source = "SecurityIncident"),
(SigninLogs
| summarize Latest = max(TimeGenerated)
| extend Source = "SigninLogs")
| project Source, Latest,
MinutesSinceLatest =
datetime_diff("minute", now(), Latest)A missing table may produce a warning or partial result depending on the environment. Verify both sources separately when troubleshooting. A freshness value is descriptive; set any alert thresholds according to your connector and ingestion expectations.
Step 12 — Distinguish current state from selected period
| Panel | Scope | Important distinction |
|---|---|---|
| Open incident KPIs | Latest known incident state | Not limited to newly updated incidents |
| Open triage queue | Latest known incident state | May include old open incidents |
| Creation trend | Incidents created in chosen window | Not all current incidents |
| Identity trend | Sign-in events in chosen window | Separate data source |
| Data freshness | Latest ingested record per source | Not a guarantee of completeness |
Step 13 — Keep time controls honest
One workbook-level time parameter does not mean every metric should obey it identically. Apply it to event and creation trends. For current-state backlog panels, explicitly show that the query uses the latest known incident record, including incidents older than the selected trend period. Label this distinction in the interface.
Step 14 — Add incident navigation
- In the triage table, select the incident identifier or title column.
- If supported, configure a link action that opens the incident in the appropriate Microsoft Sentinel experience.
- Check that the target incident opens for the signed-in analyst.
- Test with a non-administrator role.
- If your workbook editor does not support a safe dynamic incident link, provide a clear link to the Sentinel incident list instead.
Portal navigation and workbook link-action options can vary; avoid hard-coding unverified incident URLs.
Step 15 — Design for the shift handover
- Put unassigned and older open incidents near the top.
- Make data freshness visible, not hidden in a footer.
- Include a last-reviewed note and a dashboard owner.
- Keep the underlying incident queue one click away.
- Avoid exposing unnecessary personal data on a wall display.
- Use accessible labels and avoid colour-only priority cues.
Step 16 — Validate dashboard totals
| Validation | Expected result |
|---|---|
| Open KPI vs queue | Counts align after accounting for row cap |
| Severity bars vs open KPI | Category totals reconcile |
| Creation trend vs incident list | Creation dates agree for same window |
| Ownership view | Unassigned cases visible |
| Refresh check | Latest data timestamp is plausible |
| Permissions check | Analyst can access source records |
Step 17 — Performance and reliability
Incident snapshots and broad time windows can be expensive. Test realistic data volumes, avoid unnecessarily repeating large queries, cap detail views and consider query optimisation. Where workbook controls offer refresh settings, select a cadence that matches operational need and workspace cost.
Step 18 — Common dashboard mistakes
| Mistake | Why it matters | Fix |
|---|---|---|
| Count every SecurityIncident row | Updates inflate incident counts | Use latest row per incident |
| Filter snapshots to last 24h | Old open incidents disappear | Separate current state and trends |
| No freshness indicator | Stale data looks reassuring | Show source freshness |
| No evidence drill-down | Analyst cannot validate | Link to incident records |
| Overload with charts | Urgent work gets buried | Prioritise action-oriented panels |
| Call failed sign-ins attacks | Overstates the evidence | Use precise labels |
Agent Foskett scenario — The quiet dashboard
At 08:00, the SOC dashboard shows only two new incidents. The shift lead calls it a quiet morning. Agent Foskett opens the backlog panel: nine incidents remain open, three are unassigned and one is several days old. The new-incident trend was correct — but it was never a measure of total outstanding work.
Lesson: a dashboard must separate what arrived from what still needs attention.
Hands-on build exercise
- Create a fresh workbook copy for the SOC Operations Dashboard.
- Add three current-state KPI measures.
- Build an open-incident triage table.
- Add incident creation and severity charts.
- Add an owner workload panel and backlog-age view.
- Add the sign-in signal and data freshness panels.
- Check that current-state views include older open incidents.
- Validate totals and write a short shift-handover summary.
Publishing checklist
- The workbook clearly identifies its workspace and scope.
- Current-state and time-window metrics are distinguished.
- Counts do not double-count incident updates.
- Critical triage work is visible without scrolling excessively.
- Charts have accurate units, labels and limits.
- Data freshness and missing-source behaviour are documented.
- Links open appropriate incident evidence.
- Access follows least privilege.
- The workbook has been tested after save and reload.
Agent Foskett takeaway
A good SOC dashboard does not simply show what happened. It shows what needs attention — and makes the evidence easy to reach.
Fifty lessons down. The logs already knew. The dashboard finally asked the right questions.
