DataDirect 2.2 User Guide
2
Contents
• Overview and Access
• Project and Query Setup
• Cohort Selection and Filters
• Filter Logic and Groups
• Report Setup and Execution
• Downloads, Results, and Sharing
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
3
Overview and Access
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
4
DataDirect Overview
• DataDirect is an application that allows users to create queries using data submitted to MPOG for
quality improvement (QI) and research purposes.
• It contains multiple filters that can help easily identify a cohort of patients and access data
following appropriate approvals.
• Researchers can use DataDirect to identify patient, case, and institution counts for the cohort
they are interested in studying.
• Quality Champions can generate a list of patients to audit outcomes or processes of case. As an
example, the Quality Champion for the site may be interested in identifying patients who received
reversal for neuromuscular blockade and compare that to institution reintubation rates to identify
if any correlation exists.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
5
DataDirect Privacy and Access Requirements
• DataDirect contains a limited dataset. Protected Health Information is excluded except for dates
of service.
• However, because DataDirect may contain information regarding hospital level quality indicators
(i.e. hospital mortality), approval from the Department Chair or Head of Practice is required.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
6
Gaining DataDirect Access
• If you would like access to Data Direct, please submit the MPOG Application Access – Attestation Form via
SignNow. Access is granted after the requested user reviews and attests, the site Department Chair co-signs,
and the MPOG Research and/or Quality Team approves access.
• The form is also available on our website, https://mpog.org/downloads/
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
7
MPOG Application Access– Attestation Form
• This new form provides a single, standardized method for requesting access to
MPOG Quality and/or MPOG Research applications.
Application Access by Role
• MPOG Quality Access
• DataDirect
• QI Reporting Tool (Departmental Access)
• MPOG Data Library
• Web Case Viewer
• MPOG Research Access
• DataDirect
• PCRC Project List (MPOG Website)
• MPOG Data Library
• Web Case Viewer
• Combined Quality & Research Access
• Access to all applicable Quality and Research resources listed above
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
8
Project and Query Setup
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
9
Creating a Query
When creating a query, there are three modes you can choose from.
• Cohort Only
• Generates a count to rapidly determine feasibility of a research or QI project. There is no ability to download data,
and no additional approval (e.g. Institutional Review Board) is required for access.
• Public dissemination of counts (e.g. journal publication, conference abstract, invited talk, social media post, etc.) is
NOT allowed. However, counts may be used as preliminary data for multicenter PCRC proposals, and/or shared solely
with authorized individuals.
• Quality Report
• Generates a cohort count, data query, and case list for a specific site. Although DataDirect will display final case
counts, institutions will remain anonymized.
• Research
• Allows for cohort identification across all sites and downloading sample data from your site only.
• Public dissemination of single-center study findings (e.g. journal publication, conference abstract, invited talk, social
media post, etc.) must be first approved by your Authorized Hospital Leader.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
10
Step 1: Define Project
• Choose from Create New, Open Existing, or Edit Current
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
11
Step 1: Creating a New Query
• Enter a name, description (optional), and select a type of project.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
12
Cohort Selection and Filters
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
13
Filtering Data
• Each filter can be individually selected by clicking the + symbol to the right of the item name.
• Once added to the filtering algorithm, additional specifications, such as ranges or categories, may
be added to the filter.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
14
Step 2: Filter Patient Population
• Next, apply filters to define your
cohort and return only cases that
you're interested in. The available
filters are listed on the left sidebar
while the size of your cohort will
be dynamically updated on the
right.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
15
Filter: Population
• This section begins to narrow the
population of cases for your
project. Additionally, based on the
type of project and your role, you
may be able to choose cases for
your institution or for all
institutions in MPOG. Please select
the most relevant starting
population if differing from the
default.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
16
Filter: Demographics
• Patient characteristics from
administrative registration
systems. Data is mostly case-level
and reflects the most recent value
for a given patient (e.g. BMI),
regardless of time period specified
in Cases.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
17
Filter: Cases
• Perioperative case characteristics
from the clinical documentation
and professional fee billing
systems. Some patient
characteristics (ASA status) may
change from one case to another
and reflect the information known
at the time of that case.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
18
Filter: Diagnoses
• MPOG derives diagnoses
information from professional
billing sources, discharge
diagnoses codes, or clinician
entered information in the health
record. In this section you will
primarily see
Elixhauser
Comorbidities
. However, MPOG
has also derived other diagnoses
from diagnoses codes or clinician
entered data.
Use this section to narrow your cohort to the specific
diagnoses you are interested in.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
19
Filter: Diagnosis Codes
• Begin typing the desired diagnosis name (or associated ICD-9 and ICD-10 codes) into the
Diagnosis Code field. ICD-10 codes were required as of October 1, 2015, therefore historical data
may only include ICD-9 codes.
• If you are interested in capturing diagnosis data for a case that occurred before this date, please
choose both ICD-9 and ICD-10 codes. Select the codes you desire, then click Save changes
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
20
Filter: Procedures
• Perioperative procedures activity
identified using Current Procedure
Terminology (CPT) codes,
professional fee charges, or using
free text procedure descriptions.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
21
Filter: Concepts
• MPOG concepts are the raw data
dictionary for MPOG. Variables
from the original electronic health
record are mapped to concepts to
help standardize data across
participating sites. Please note
that due to variability in
documentation practices, sites
may use different MPOG concepts
to describe similar phenomena.
You may need to reference your local Variable Mapping for the
concepts that are used at your site to build an accurate QI report
or data query for your institution.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
22
Filter: Outcomes
• Clinical outcomes derived from
Electronic Health Record and
Administrative Data.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
23
Filter: Laboratories
• Laboratory values in this screen
are curated lab phenotypes,
available for the most common
labs and use cases. These are
distinct from the Laboratory
Concepts that can be selected
from the Concept screen include
all MPOG laboratory data.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
24
Filter: Quality Measures
• MPOG Quality Improvement
measure data, derived from
Electronic Health Record and
Administrative Data. Please review
specification before selecting a
measure from the list.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
25
Edit Filters
Filter Logic and Groups
• This allows you to rearrange the order in which filters are
applied to the cohort.
• Please note that individual filters are joined to one
another using “and” logic. Therefore, cases must meet
all filter criteria in sequential order to be included in the
cohort.
• To rearrange the filter order, click the Edit Filters button
in the right-side panel. A brief on-screen guide will pop-
up that details the functionality. This guide can also be
viewed via the Guide button within the Edit Filters
section.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
26
Adding Filter Groups
• Users can also add filter groups to combine
individual filters using “or” logic from within the
Edit Filters screen.
• Cases meeting any of the criteria within a filter
group are included in the cohort.
• To add a filter group, click the Add a Filter Group
button at the bottom or drag and drop a filter
(using the four-way move icon) next to another
filter.
• Please note that any empty filter groups will be
ignored.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
27
Reordering a Filter
• Reorder a filter by dragging and
dropping its light blue bar or the up-and-
down arrow to the left of its name.
• Filters displaying lock and anchor icons
cannot be reordered.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
28
Individual Filters vs. Filter Groups
This query uses
individual filters
to combine
procedure text
and procedure
codes using
“and” logic →
cases need to
meet both filter
criteria to be
included
This query utilizes the
filter group to combine
procedure text and
procedure codes using
“or” logic → cases can
meet either filter
criteria to be included
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
29
Report Setup and Execution
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
30
Step 3: Select Report Columns
• Now that you've chosen which
cases should be included, you will
need to define which data
elements should be returned in
the result set. This includes pre-
computed MPOG Phenotypes
and
raw MPOG Concepts
.
Learn more in the MPOG Phenotypes
video
.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
31
Step 4: Review and Finalize
• Please review your selections and
other details for your
report/query. Select Run to begin
processing your request.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
32
Downloads, Results, and Sharing
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
33
Query Completion and Download
• When the query is done running, an auto-generated email is sent.
• Click the Download Package button to proceed to the attestation screen.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
34
Download Attestation and Password
• After specifying filename, completing attestations and password-protecting the Excel
Spreadsheet, click the Download Package button.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
35
Saving the Excel Spreadsheet
• Download the Excel Spreadsheet.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
36
Viewing Query Results
• Enter the password previously set to view the spreadsheet.
• A summary of the data, and characteristics of the data queried, are among the tabs available in
the Excel Spreadsheet.
• Due to row limits in Excel, results that exceed 1 million rows are split into multiple numbered
tabs.
• These results will need to be merged into a single file using a text editor to have complete data.
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
37
Sharing DataDirect Queries
• Click Edit Current (Step 1), then click Share this Project
Click the Share button after
selecting a user
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com
38
Summary and Support
• Access and project setup: Complete the required approvals and select the appropriate project
mode.
• Cohort selection: Apply filters and check AND / OR logic to define the cases you need.
• Report and results: Select report columns, review the query, and run it. Complete attestations
and set a password before downloading.
• Sharing: Share a copy of your query with another DataDirect user.
Questions? Contact the MPOG Coordinating Center
support@mpog.zendesk.com
Last Updated: 10/7/2026 Contact: support@mpog.zendesk.com