Power BI for IT and Operations Teams: Dashboards, DAX, and Real Operational Insights
“Kill the Excel SLA Report. Build the Dashboard That Runs Itself.”
Replace your manual Excel SLA report with a live Power BI dashboard that auto-refreshes daily from ServiceNow, JIRA, and Splunk data — built solo, no data team required.
One-time · Lifetime access · Certificate included
- ✓6 modules of content
- ✓48 concept slides
- ✓18 practical exercises
- ✓24 quiz questions
- ✓Capstone project
- ✓LearnAspire certificate
Learning Outcomes
What you'll learn
The day after you finish
The day after completing this course, you will open Power BI Desktop, connect directly to your organisation's ServiceNow instance via the REST API, load the incident table, apply the M transformations you built in this course to fix datetime fields and null assignment groups, write a CALCULATE-based DAX measure for SLA breach percentage, publish the report to Power BI Service, and send your manager a browser link to a live dashboard that replaces the Excel file you were manually updating every week.
Who this is for
- Primary: IT Operations Analyst or Systems Operations Engineer with 2–5 years in Ops who currently produces SLA and incident reports manually in Excel from ServiceNow and Splunk exports
- Secondary: NOC Engineer or Platform Engineer who owns incident response metrics and needs a repeatable reporting pipeline without relying on a BI or data team
- Tertiary: IT Manager or Operations Team Lead who will consume the dashboards produced in this course and wants their analyst to build them independently
Prerequisites
- Able to write a basic SQL SELECT with a JOIN — you do not need to write SQL in this course, but query logic is used to explain Power Query transformations
- Has exported a CSV from ServiceNow, JIRA, or Splunk at least once — you should know what those tools are and have hands-on access to at least one of them
- Comfortable with Excel pivot tables — this course replaces that workflow, not introduces it
Curriculum
6 modules · full breakdown
Capstone Project
Pulseware Live Operations Dashboard — SLA, Incident Triage, and Capacity in One .pbix
Using the provided Pulseware Technologies dataset (1,200 synthetic ServiceNow incident records with correct field names including sys_created_on, resolved_at, assignment_group, priority, u_resolution_code; a JIRA engineering escalation CSV with 340 rows; and a Splunk alert log CSV with 90 days of system health events across 8 services), learners build a complete Power BI .pbix file containing four report pages and two operational data alerts — delivered under the constraint that the file must connect to a provided cloud-hosted data endpoint and refresh without a local gateway
What you'll deliver
A deployed Power BI .pbix file published to Power BI Service containing: (1) Incident Triage dashboard — open P1/P2 counts by assignment group with drill-through to individual ticket records; (2) SLA Trends dashboard — 30-day rolling SLA breach rate by priority tier with conditional formatting threshold at 10% breach; (3) Capacity Forecast page — alert volume by system over 90 days with a 7-day moving average trendline; (4) Team Performance scorecard — MTTR by assignment group compared against SLA target using a bullet chart; plus two configured Power BI Service data alerts: one firing when SLA breach rate exceeds 10%, one firing when open P1 count exceeds 3 — all measures implemented in DAX using CALCULATE, FILTER, DATEDIFF, DATESINPERIOD, and DIVIDE
Portfolio value
Build a production-ready Power BI operational dashboard integrating ServiceNow, JIRA, and Splunk data with advanced DAX metrics (MTTR, SLA breach rates), automated alerts, and RLS—proving the ability to architect and deploy enterprise incident intelligence solutions independently.