Study guide
8.1 Analytics Tools, Reports, Tables, and Graphs
Certified Professional in Healthcare Information and Management Systems CPHIMS
Track your progress as you read
Finished sections get a check mark.
1 Introduction & Exam Overview
1.1 Current Exam Facts 1.2 Eligibility Pathways and Qualifying Experience 1.3 Scoring, Retakes, and Recertification 1.4 Domain-Weighted Study Strategy
2 Healthcare Organizations and Relationships
2.1 Hospitals, Clinics, Ambulatory, and Community Organizations 2.2 Payers, Regulators, Research, and Academic Organizations 2.3 Interrelationships, HIE, and Continuity of Care 2.4 HIT Professional Roles and Organizational Structures
3 Policy, Accreditation, and Care Trends
3.1 Privacy and Security Law: HIPAA and HITECH 3.2 Interoperability Policy and Information Blocking 3.3 Accreditation, Patient Rights, and Environments of Care 3.4 Telehealth, Portals, Wearables, and Population Health
4 Healthcare Applications
4.1 Clinical Applications 4.2 Administrative and Financial Applications 4.3 Consumer-Facing Applications 4.4 Business Intelligence Applications
5 Technology Infrastructure
5.1 Networks and Communications 5.2 Data Integration Architectures 5.3 Infrastructure Privacy and Security 5.4 Cloud, Devices, and Identity Infrastructure
6 Clinical Language, Terminologies, and Metrics
6.1 Clinical Vocabulary 6.2 Healthcare IT Vocabulary 6.3 Clinical Terminologies: SNOMED CT, LOINC, RxNorm, and ICD 6.4 Clinical Metrics and Operational Measures
7 Clinical Effectiveness and Workflows
7.1 System Functionality for Clinical Effectiveness 7.2 Workflows, Order Sets, and Pathways 7.3 Safety, Quality, and Clinical Informatics Design
8 Informatics Analytics
8.1 Analytics Tools, Reports, Tables, and Graphs 8.2 Interpreting Clinical and Operational Outcomes 8.3 Predictive Models in Care and Operations
9 Clinical Content and Decision Support
9.1 Clinical Content Lifecycle 9.2 Clinical Decision Support Types and Design 9.3 CDS Governance, Alert Management, and Knowledge Maintenance
10 Analysis, SDLC, and Improvement Methods
10.1 Systems Development Life Cycle 10.2 Project Management: Needs, Gap, and Requirements 10.3 Process Improvement: DMAIC and PDCA 10.4 Process Maps, Flow Diagrams, and Gap Analysis
11 Analysis: Solutions and the Business Case
11.1 Disparate Data Sets and Alternate Solutions 11.2 Strategic Alignment and Cost-Benefit Analysis 11.3 Proposals, RFPs, RFIs, SLAs, SOWs, and NDAs
12 Systems Design
12.1 Interoperability of Software, Hardware, Networks, and Devices 12.2 Design Compliance and Incorporating Industry Trends 12.3 Business Continuity and Disaster Recovery Design 12.4 Emerging Technologies and Data Governance
13 Selection, Implementation, Support, and Maintenance
13.1 Solution Selection Activities 13.2 Technical Change Management, Training, and Support 13.3 Implementation: Scope, Schedule, Budget, and Quality 13.4 Maintenance, Operations, and Problem-Trend Analysis
14 Testing, Evaluation, Privacy, and Security
14.1 Testing Methodology and Internal Controls 14.2 Validation and Benefits Realization 14.3 Privacy and Security Policies, Access, and Safeguards 14.4 Vulnerabilities, Roles, Data Controls, and Ongoing Validation
15 Strategy and IT Planning
15.1 Contributing to Organizational Strategic Planning 15.2 Assessing the Organizational Environment 15.3 Forecasting Technical and Information Needs 15.4 IT Strategic Plans and Departmental Objectives
16 Performance, Policy, Ethics, and Analytics
16.1 Evaluating Performance Against SLAs and Indicators 16.2 User Satisfaction and Service Effectiveness 16.3 Policies, Legal Compliance, and Ethical Principles 16.4 Comparative Analytics and Presenting Recommendations
17 Communication, Stakeholders, and Change
17.1 Promoting Stakeholder Understanding of IT Opportunities and Constraints 17.2 Business Communications and Consultative Technology Services 17.3 Facilitating Groups, Consensus, and Conflict Resolution 17.4 Organizational Change Management and Stakeholder Relationships
18 People, Projects, Vendors, and Finance
18.1 HIT Roles, Job Descriptions, and Staff Competency 18.2 Educational Strategies and Maintaining IT Competencies 18.3 Managing Projects and Portfolios 18.4 Vendor Contracts, Budgets, and Risk Management
8.1 Analytics Tools, Reports, Tables, and Graphs
Key Takeaways Explain This Topic AI
Domain 2 task A.5 tests whether you can interpret clinical and operational outcomes with the right analytic artifact: a scheduled report, an operational worklist, a governed dashboard, or a self-service session.
A report is a versioned snapshot. A dashboard is a role-based, filterable view with a declared refresh. Self-service is exploration on a semantic layer. They are not interchangeable.
Choose the visual for the question: tables for exact numerators and mixed units, bars for category comparison, lines for time, run or control charts for process variation. Pies, 3D, and dual axes routinely distort interpretation.
Data lineage is part of the reading: source event, inclusion rules, transform, certified definition, and refresh time. If you cannot walk from pixel back to source, you cannot interpret the outcome.
A polished dashboard is a display. It is not a clinical or operational outcome. Pretty tiles do not create safer care, shorter stays, or fewer infections.
Last updated: August 2026
8.1 Analytics Tools, Reports, Tables, and Graphs
Quick Answer: Domain 2 task A.5 is not “make a prettier dashboard.” It is choosing the right analytic artifact— scheduled report , operational worklist , governed dashboard , or self-service session —then matching table or graph to the question and tracing lineage from source event to pixel. A polished visual is a display. It is not a clinical or operational outcome.
Clinical Informatics is 20% of CPHIMS. Task A.5 sits after you can name census, turnaround time, adherence, and BCMA (section 6.4) and after you can classify warehouses as downstream applications (section 4.4). This section is the interpretive skill: given a board packet, a unit huddle screen, or a self-service workbook, can you say what question the artifact can honestly answer—and what it cannot?
Use free CPHIMS practice questions after this chapter to rehearse application stems. Quality credentials such as CPHQ go deeper on control charts and measure specification. Health-information credentials such as RHIA go deeper on secondary-use integrity. CPHIMS still expects the informatics professional to refuse a 3D pie that “proves” quality and to ask where the tile came from.
Why tool choice is an informatics competency
Executives meet in front of screens. That social fact tempts teams to treat any colorful object as analysis. Task A.5 rewards the opposite habit: name the job of the artifact first . A night charge nurse needs a worklist of overdue STAT labs. A quality committee needs a versioned eCQM table with numerator, denominator, and exclusions. A service-line director needs a 13-month trend with a stable definition. An analyst exploring “why Friday discharges stall” needs a sandbox, not a board-certified tile.
If you hand all four audiences the same nightly warehouse homepage, you have not done analytics. You have decorated a meeting.
Reports, dashboards, and self-service are different jobs
Keep the artifacts distinct even when they share a warehouse:
Artifact Interpretive job Typical form Strength Failure mode
Scheduled / static report Same snapshot everyone can cite later PDF, locked workbook, regulatory file, board packet Versioned, reproducible, auditable Stale if someone treats last month’s file as tonight’s census
Operational report / worklist Run the shift from source or near-real-time replica Outstanding labs, missing scans, unreconciled allergies Actionable now Using last night’s warehouse as a live bed board
Governed dashboard Role-based situational awareness across a few certified measures Unit huddle, clinic medical-director view, quality committee Filters, context, shared definitions Tiles without definitions; “green” treated as an outcome
Self-service BI Explore questions that are not yet certified Semantic layer, row-level security, unpublished sandbox Faster hypothesis generation Shadow PHI marts and conflicting “inpatient” definitions
A report is a claim with a timestamp. When CMS, a registry, or the board will later ask “what did we submit,” you want a frozen file, a run identifier, and the measure version. Interactive clicks that change the denominator after the meeting are not a submission.
A dashboard is a conversation surface. It should declare population, time window, numerator, denominator, exclusions, owner, and refresh. A sparkline with a traffic-light color and no footnote is decoration. Interactivity is useful only when the filters cannot silently redefine the measure (for example, dropping observation stays to make a readmission rate look better).
Self-service is not unrestricted PHI. It is legitimate when analysts work on a governed semantic model, cannot accidentally publish a personal definition as enterprise truth, and cannot export identifiable enterprise extracts “for a quick look.” Exploration belongs in a sandbox. Certification belongs on a publication path.
Chapter 4.4 taught that warehouses are downstream of EHR, ADT, LIS, and BCMA. This section adds: the visual layer does not upgrade the data class . A real-time-looking dashboard on a 24-hour-old extract is still yesterday. An operational worklist that hits the source system is still not an outcome measure just because someone put a green check next to the queue length.
Choose the table or graph that matches the question
Visual choice is not decoration. The wrong geometry changes the interpretation.
Question you are actually asking Honest visual Usually the wrong visual
What are the exact counts, rates, and exclusions? Table (and often a footnote of lineage) A pie or a “single number” hero tile
How do categories compare right now? Bar (sorted with a zero baseline) 3D bar, dual axis, or a pie with more than a few slices
How did one measure move over time? Line or run / control chart A pie per month, or a bar chart that hides seasonality
What share of a single whole? Pie or stacked bar only with few mutually exclusive parts Pie of 12 discharge dispositions or overlapping categories
Do two continuous values move together? Scatter A dual-axis line that forces unrelated scales to look correlated
Is this process stable or special-cause? Run or control chart with a center line A two-point “before/after” arrow on a dashboard
Where is volume concentrated? Heat map or small multiples One overloaded map with no denominator
Tables first when the decision needs arithmetic. eCQM submission, a root-cause huddle that will change an order set, and a medical-staff hearing about a surgeon’s complication count all need exact numerators, denominators, and exclusions . A bar that rounds 11 of 13 to “about 85%” is a teaching slide, not a hearing record.
Bars compare categories; lines compare time. If the stem asks which unit has the higher fall-with-injury rate this quarter, a sorted bar (or a table) is honest. If the stem asks whether laboratory TAT improved after a courier change, a time series is honest. Putting twelve months of TAT into a pie of “on-time versus late” throws away the sequence that would show a two-week outage.
Run and control charts protect you from two-point theater. Quality and operations leaders love a pair of numbers: “LOS was 5.2, now 4.7.” Informatics should ask for the series. A single special-cause week, a holiday, or a documentation blitz can create a before/after story that a run chart would refuse.
Chart crimes that change the interpretation:
Truncated y-axis. A rate that moved from 4.1% to 3.9% can look like a cliff if the axis starts at 3.8. Demand a zero baseline for counts and a declared, stable scale for rates.
Dual axes. Volume on the left, rate on the right, both drawn as lines, is how teams “see” a correlation that is only a scaling trick.
3D and exploded pies. They make equal slices look unequal. CPHIMS does not award style points.
Mixing counts and rates in one visual without labels. A unit with 2 infections on 40 line-days is not “better” than a unit with 6 on 2,000.
Color as the only encoding. Red/yellow/green without thresholds, owners, or definitions trains leaders to manage paint.
Comparing unlike periods. A 28-day February against a 31-day March, or a COVID-era quarter against last week, without annotation.
HIMSS does not publish a CPHIMS official charting statute. The professional test is whether the visual preserves the question . If the question was “did harm fall after we changed the bundle,” a two-color pie of this month’s infections does not answer it.
Data lineage is part of the reading
Lineage is the explainable path from a real-world event to the number on the glass:
Source event — what happened (discharge, scan, culture result, administration).
Captured field — which system recorded it (ADT discharge timestamp, BCMA scan, LIS verification).
Extract and grain — encounter, day, order, or patient; which rows were dropped.
Transform — joins, maps, imputations, “inpatient” rules, time-zone handling.
Certified definition — numerator, denominator, inclusions, exclusions, version.
Visual — aggregation, filter defaults, refresh time.
If two dashboards disagree on 30-day readmissions, the informatics move is not to average the tiles or pick the greener one. It is to walk lineage: claims-based versus EHR-based, planned versus unplanned, observation included or not, death excluded or not, which facility list, which refresh. RHIA colleagues will care that the legal record and the analytic extract did not silently diverge. You should care before you interpret the “outcome.”
Refresh time is a lineage field. A dashboard that looks live but loads at 06:00 cannot referee a 14:00 bed huddle. A weekly infection report cannot prove that today’s central line is safe. Write the as-of time on the visual. If the vendor will not, the artifact is not ready for operational decisions.
Certified versus exploratory. A certified measure is hard to accidentally redefine. An exploratory workbook is hard to accidentally publish. Task A.5 fails when a self-service “inpatient” filter (anyone with an observation order) is pasted into the board packet next to last year’s CMS definition.
A pretty dashboard is not an outcome
This is the sentence to carry into every A.5 stem. Outcomes live in patients, workflows, and operations: fewer preventable infections, completed indicated prophylaxis, a discharge that did not bounce back, a lab result that reached the clinician in time. Dashboards display measures of those things. They do not create them. Painting a tile green by changing the denominator, hiding missing data, or imputing allergies from old claims (the 4.4 trap) is a display change, not an outcome.
If leadership asks IT to “fix the dashboard” when sepsis bundle completion is poor, ask whether they want a prettier picture or a better process. Informatics can do both, but only one is Domain 2 interpretation.
Loading diagram... From source event to pixel: lineage is part of interpretation
Study heuristic: visual and artifact mistakes that break A.5 interpretation (relative emphasis, not official weights)
Scenarios and exam traps
Scenario. A chief nursing officer wants “one screen that proves quality improved” because the colors went green after a vendor restyle. Ask for definitions, lineage, and the underlying series. A restyle is not an outcome.
Scenario. Quality needs exact eCQM numerators before a CMS file leaves the building. An analyst offers a 3D pie of “quality domains.” Give them a governed table with measure version, counts, exclusions, and the run identifier. The pie can wait for a town hall.
Scenario. Night charge nurses need overdue STAT labs now . Leadership also wants a monthly TAT trend. Split the tools: a near-real-time operational worklist from the LIS or EHR for the shift, and a governed trend dashboard or scheduled report for the month. Do not feed both from last night’s warehouse homepage.
Scenario. Two service-line dashboards disagree on 30-day readmissions by four percentage points. Walk lineage before anyone presents “the” rate. One tile may be claims-based all-cause; the other may be EHR unplanned returns to the same campus, excluding observation.
Scenario. A clinic manager wants every physician to download a full identifiable extract each Monday. That is not self-service analytics. Offer a row-secured semantic model and keep certified measures on a publication path.
Watch these traps:
Treating any colorful object as analysis.
Using a nightly warehouse as a live bed board or STAT worklist.
Dual axes, truncated scales, and 3D pies that change the story.
Self-service definitions leaking into board packets.
Missing refresh time and missing lineage.
Calling a green tile a clinical outcome.
If you can say which artifact, which visual, and which source field produced the number—and what question it still cannot answer—you are doing task A.5 at professional level. Mix those stems at /practice/cphims .