Why Every QA Tester Should Learn Power BI in 2026

-- Jira: run this JQL in issue search, then Export -> CSV
project = SHOP
  AND issuetype = Bug
  AND created >= -90d
ORDER BY created DESC

-- Columns to include in the export:
-- Issue key, Summary, Status, Priority, Severity (custom field),
-- Component/s, Created, Resolved, Reporter, Assignee,
-- Sprint, Labels (e.g. reopened)

test_runs.csv  (exported from the test tool or CI)

run_id,cycle,test_id,module,requirement_id,result,executed_on,tester
R-101,Sprint 14,TC-001,Checkout,REQ-12,Passed,2026-10-20,QA1
R-101,Sprint 14,TC-002,Checkout,REQ-12,Failed,2026-10-20,QA1
R-101,Sprint 14,TC-015,Login,REQ-03,Passed,2026-10-20,QA2
R-102,Sprint 14,TC-002,Checkout,REQ-12,Passed,2026-10-22,QA1
R-102,Sprint 14,TC-030,Payments,REQ-18,Blocked,2026-10-22,QA2

Keep one row per test execution, with a consistent
result value: Passed, Failed, Blocked or Not Run.

let
    Source = Csv.Document(File.Contents("C:\QA\jira_bugs.csv"),
        [Delimiter = ",", Encoding = 65001, QuoteStyle = QuoteStyle.Csv]),
    Promoted = Table.PromoteHeaders(Source, [PromoteAllScalars = true]),
    Typed = Table.TransformColumnTypes(Promoted,
        {{"Created", type datetime}, {"Resolved", type datetime}}, "en-IN"),
    Severity = Table.ReplaceValue(Typed, "Sev1", "Critical",
        Replacer.ReplaceText, {"Severity"}),
    CreatedDate = Table.AddColumn(Severity, "CreatedDate",
        each DateTime.Date([Created]), type date),
    ResolvedDate = Table.AddColumn(CreatedDate, "ResolvedDate",
        each if [Resolved] = null then null else DateTime.Date([Resolved]), type nullable date),
    IsOpen = Table.AddColumn(ResolvedDate, "IsOpen",
        each [Resolved] = null, type logical)
in
    IsOpen

let
    Source = Csv.Document(File.Contents("C:\QA\test_runs.csv"),
        [Delimiter = ",", Encoding = 65001]),
    Promoted = Table.PromoteHeaders(Source, [PromoteAllScalars = true]),
    Typed = Table.TransformColumnTypes(Promoted,
        {{"executed_on", type date}}),
    Sorted = Table.Sort(Typed, {{"executed_on", Order.Descending}}),
    Buffered = Table.Buffer(Sorted),
    // keep the most recent execution of each test in each cycle
    Latest = Table.Distinct(Buffered, {"cycle", "test_id"})
in
    Latest

Executed Tests =
CALCULATE ( COUNTROWS ( TestRuns ), TestRuns[result] IN { "Passed", "Failed" } )

Passed Tests =
CALCULATE ( COUNTROWS ( TestRuns ), TestRuns[result] = "Passed" )

Pass Rate % =
DIVIDE ( [Passed Tests], [Executed Tests] )

Blocked Tests =
CALCULATE ( COUNTROWS ( TestRuns ), TestRuns[result] = "Blocked" )

Requirements Covered =
CALCULATE (
    DISTINCTCOUNT ( TestRuns[requirement_id] ),
    TestRuns[result] = "Passed"
)

Coverage % =
DIVIDE ( [Requirements Covered], COUNTROWS ( Requirements ) )

Open Defects =
CALCULATE ( COUNTROWS ( Defects ), Defects[IsOpen] = TRUE () )

Open Critical =
CALCULATE ( [Open Defects], Defects[Severity] = "Critical" )

Defects Opened =
COUNTROWS ( Defects )   -- relationship: Date[Date] -> Defects[CreatedDate]

Defects Closed =
CALCULATE (
    COUNTROWS ( Defects ),
    USERELATIONSHIP ( 'Date'[Date], Defects[ResolvedDate] )
)   -- inactive relationship on ResolvedDate

Reopen Rate % =
DIVIDE (
    CALCULATE ( COUNTROWS ( Defects ),
        CONTAINSSTRING ( Defects[Labels], "reopened" ) ),
    COUNTROWS ( Defects )
)

QA DASHBOARD — PAGE LAYOUT

Top row (cards):
  Pass Rate %   | Open Critical | Open Defects | Coverage %

Middle row:
  Line: Defects Opened vs Closed by week
  Stacked bar: Open Defects by Module and Severity

Bottom row:
  Matrix: Requirement x Latest Result (Passed/Failed/Blocked)
  Table: Top 10 oldest open defects (key, module, age)

Slicers (left panel): Sprint, Module, Environment, Severity

DATA DICTIONARY (share with the team)

Measure          Definition                            Source
---------------  ------------------------------------  ------------
Executed Tests   Runs with result Passed or Failed      test_runs.csv
Pass Rate %      Passed / Executed (latest per test)    test_runs.csv
Blocked Tests    Runs with result Blocked               test_runs.csv
Open Defects     Bugs with no Resolved date             Jira export
Reopen Rate %    Bugs labelled reopened / all bugs      Jira export
Coverage %       Requirements with a passed test /      Backlog +
                 all requirements in scope              test_runs.csv

Refresh: daily at 9 am  |  Owner: QA lead

RELEASE QUALITY SUMMARY (from the dashboard)

Release     : v3.8   Cycle: Sprint 14
Pass rate   : ___ %  (agreed bar: ___ %)
Coverage    : ___ %  of in-scope requirements
Open bugs   : Critical ___  High ___  Medium ___
Trend       : backlog rising / flat / falling
Riskiest    : module ________ (most failures + reopens)
Not tested  : REQ-__, REQ-__ (reason: ________)

QA view     : Go / Go with known issues / No-go
Evidence    : link to Power BI report page