data innovations regional user group · 2018-01-10 · datainnovations.com confidential 2 agenda...
TRANSCRIPT
datainnovations.com Confidential datainnovations.com
Data Innovations Regional User GroupApril 12, 2017
datainnovations.com Confidential 2
Agenda – Regional User Group
Introductions –Gina Coughlin
Group exercise – Developing Rules - Jeff Piepenburg09:45 am
11:30 am Recent Releases and Product Roadmap – Tawni Reller
01:00 pm
02:15 pm
04:15 pm
9:00 am9:00 am
Customer Key Topic Discussion
Conclusion
EP / IM Integration Training - Colin Deming
datainnovations.com Confidentialdatainnovations.com Confidential 3
Folder Review
datainnovations.com Confidentialdatainnovations.com Confidential 4
Customer Key Topic Discussion
• Start thinking about the following items below for the group break out session at the end of the day
• With in your group, rank the top five most important things to you under the following categories. You only need to write down 5 total things and they can be placed under any of the topics
1. Direction of Product Development and enhancements
2. Topics for Regional User Groups, regional 2 day user group and Webinars
3. DI processes and procedures (i.e. support request, upgrading versions)
datainnovations.com Confidentialdatainnovations.com Confidential 5
IntroductionsName
Organization
DI Product
LIS
What do you want to get out of today?
datainnovations.com Confidential 6
Agenda – Regional User Group
Introductions –Gina Coughlin
Group exercise – Developing Rules - Jeff Piepenburg09:45 am
11:30 am Recent Releases and Product Roadmap – Tawni Reller
01:00 pm
02:15 pm
04:15 pm
9:00 am
9:45 am
Customer Key Topic Discussion
Conclusion
EP / IM Integration Training - Colin Deming
datainnovations.com Confidential datainnovations.com
Rules Exercise
datainnovations.com Confidentialdatainnovations.com Confidential 8
Rules Scenario #1
• Dr. Jones is at a conference this week but still wants to be contacted on his cell phone for any urgent results for his patients. Since it is only temporary, he does not want the hospital contact list updated to reflect this temporary change.
– Create a rule that adds a Specimen Comment with Dr. Jones’ cell phone number (215-555-1234)
– Dr. Jones is identified within Instrument Manager as 456, Jones, James A as the Ordering Physician
– Use the Extract Component of operator
datainnovations.com Confidentialdatainnovations.com Confidential 9
Using the Extract Component Operator
• The Extract Component Operator looks worse that it really is:
– {Extract Component of} {Ordering Physician} {Using} {Component Delimiter} {From} "1" {To} "1“
– Evaluates the Ordering Physician data element and looks for the “separators” in that field
– 456, Jones, James A 456 is Component 1
The comma is component delimiter or “divider” in this example
Jones is Component 2 in this example
James A is Component 3 in this example
datainnovations.com Confidentialdatainnovations.com Confidential 10
Rules Scenario #2
• The lab really liked the physician’s contact information being visible in Instrument Manager and is now requesting that all physician’s contact information be listed in Instrument Manager.
– Convert your existing rule in to a rule that uses a value list
– Additional physicians are: 3485, Smith, James M. (215-555-1212)
449, Morgan, Jenny E. (267-867-5309)
888, Bonaire, Vincent L. (317-288-0010)
datainnovations.com Confidential 11
Agenda – Regional User Group
Introductions –Gina Coughlin
Group exercise – Developing Rules - Jeff Piepenburg09:45 am
11:30 am Recent Releases and Product Roadmap – Tawni Reller
01:00 pm
02:15 pm
04:15 pm
9:00 am
11:30 am
Customer Key Topic Discussion
Conclusion
EP / IM Integration Training - Colin Deming
datainnovations.com Confidential datainnovations.com
Product RoadmapsApril 2017
datainnovations.com Confidentialdatainnovations.com Confidential 13
Instrument Manager Overview• Release timelines
Current target is every one major release/launch annually, with a maintenance release 6 – 9 months after the major release
Timing of maintenance release incorporates beta site, early adopter feedback
• Working on 3- and 5-year roadmaps
– Addressing all features/functions within IM Specimen Management, Lab Intel, Moving Averages, Maintenance Manager, etc.
– PERL process/customer-requested enhancements
– User interface enhancements/changes Beginning with Moving Averages in IM v8.16
User requirements for Chemistry and Hematology Workspaces, followed by microbiology/molecular and immunohematology
– Customer-based discussions, market problems
datainnovations.com Confidentialdatainnovations.com Confidential 14
2016 Roadmap – Instrument Manager• Release 8.15 – Architecture (Q2 2017 – Launch)
– Mirroring Automatic failover – Cache 2015 update
Failover/Async members
– Lab Intel Look/feel updates
• search capability
• Filters in separate widget
Setup
• Listing groups (use across pivots)
• Detail listing updates (columns line up)
New default dashboards available
post-launch
– Additional changes Simplified Traceability - SEL/SMW
SSL communication with client server
SM Index updates (speed improvements –CPU/Disk)
SMW result entry – force select from dropdown for coded entries
Windows 10 support
– APIs Framework, Structure, Security (SSL)
Moving Averages
datainnovations.com Confidentialdatainnovations.com Confidential 15
2016 Roadmap – Instrument Manager• Release 8.16 (Estimated Q4 2017 – Launch)
– Moving Averages Edit filters across multiple protocols
More default protocols
UI updates
• time on x-axis
• flashing when out of range
• Scroll back in time
• Cleaner, more modern look and feel
Data/documentation in support of launching MA from ‘scratch’
• How to set up protocols, ‘get started’ data on ranges
• How to select tests for use in MA
– FDA 510(k) submission planned
datainnovations.com Confidentialdatainnovations.com Confidential 16
EP Evaluator Overview• Release timelines
Current target is every 9 months for a release/launch
• Working on 3- and 5-year roadmaps
– Continue incorporating CLSI guidelines as appropriate
– PERL process/customer-requested enhancements
– User interface enhancements/changes? Streamline workflow?
Follow UI changes in IM?
– Customer-based discussions, market problems
datainnovations.com Confidentialdatainnovations.com Confidential 17
2016 Roadmap – EP Evaluator• Release 12.0 (Q2 2017)
Introduces a new statistical module for Method Comparison that supports the updated CLSI EP9 A3 guideline with the following key features
– 4 different analytical modes depending on intended end user usage: MER, MCV, CCL, WMC
– Allows entry of up to 1 to 5 replicates for X and Y
– Scatter plots Weighted and unweighted OLS Regression
Weighted and unweighted Deming Regression
Passing Bablok
• X with Zero Uncertainty
• X with Nonzero Uncertainty
datainnovations.com Confidentialdatainnovations.com Confidential 18
2016 Roadmap – EP Evaluator• Release 12.0 Continued
– Bias plots with an optionally displayed mini-histogram
– Outlier detection by extreme studentized deviate technique
– Confidence intervals by Jackknife or Bootstrap sampling
– Preliminary Data Evaluation alerts Prompt user with potential issues with experiment data – whether data has constant SD or
CV, more than 5% outliers, too few specimens, etc.
datainnovations.com Confidentialdatainnovations.com Confidential 19
2017 Roadmap – EP Evaluator• Release 12.1 (Q4 2017/Q1 2018)
Updates to EP Evaluator based on the most up to date CLSI documents EP05 A3 (Complex Precision) and EP15 A3 (Trueness)
– A new module to support both EP15 A3 and EP05 A3 CLSI EP15 A3 has been updated to be compatible with EP05 single-site study designs
Bias calculations on the same samples used for precision studies
Flexible analysis of variance (ANOVA) to accommodate different experimental designs
• 20 days, 2 runs, 2 reps
• 3 sites, 5 days, 5 reps
– Support studies for Multisite Precision (3 site minimum) for between instrument precision
– Precision verification value = claimed SD Goal plus statistical tolerance limit
Integration with IM for
datainnovations.com Confidentialdatainnovations.com Confidential 20
2017 and beyond for EP Evaluator
• Release 12.2 (Q3 2018) and beyond
– Continued updates supporting published CLSI documents, including: EP28-A3c: Defining, Establishing, and Verifying Reference Intervals in the Clinical Laboratory;
Approved Guideline—Third Edition
EP10-A3-AMD: Preliminary Evaluation of Quantitative Clinical Laboratory Measurement Procedures; Approved Guideline—Third Edition
datainnovations.com Confidentialdatainnovations.com Confidential 21
Other Roadmap-related Projects, Products
• Product Strategy formalized within Data Innovations
– Outside of R&D team
– Pragmatic Marketing model, focusing on market problems
• Evaluation of market/market problems related to POCT
• Collaboration with DI customers
– Onsite visits
– Observation of routine, daily lab workflows, including: use of DI products by lab techs, lab supervisors/managers, lab directors
use of LIS in conjunction with Instrument Manager (Specimen Workspaces, Moving Averages, Lab Intel, etc.)
1:1 in-person discussions between DI Product Strategy and various Lab and IT staff
datainnovations.com Confidentialdatainnovations.com Confidential 22
Questions?Thank you for your time!
datainnovations.com Confidential datainnovations.com
Lunch BreakStart back at 1:00 pm
datainnovations.com Confidential 24
Agenda – Regional User Group
Introductions –Gina Coughlin
Group exercise – Developing Rules - Jeff Piepenburg09:45 am
11:30 am Recent Releases and Product Roadmap – Tawni Reller
01:00 pm
02:15 pm
04:15 pm
9:00 am
1:00 pm
Customer Key Topic Discussion
Conclusion
EP / IM Integration Training - Colin Deming
datainnovations.com
ODBC Data Acquisition ProcessUsing EE to connect to IM
datainnovations.com Confidentialdatainnovations.com Confidential 26
Objectives
1 Configuration and setup required in IM
2 Configuration and setup required in EE
3 A walk through the query wizard in EE
4 Policies and Parameters and printing a report
datainnovations.com Confidentialdatainnovations.com Confidential 27
A few terms
• ODBC – Open Database Connectivity
– A protocol that allows transfer of data between two databases, even if those databases are not the same
• IM – Instrument Manager. Version 8.14.10 in the demonstration and in these slides
• EE – EP Evaluator. Version 11.3 in the demonstration and in these slides using the “professional” version license
• RRE – Rapid Results Entry (functionality in EE)
datainnovations.com Confidentialdatainnovations.com Confidential 28
Configuring Instrument Manager
• In order to establish the ODBC connection between EE and IM, user(s) with proper permissions to access IM via an ODBC connection must be set up
• Since EE users are not always IM users it may make sense to set up users for the specific purpose of using ODBC in EE that do not have access to IM functionality
• The next few slides will detail how to add a new security group and to create a user and assign them to that group
– The user created will be used in EE during ODBC Setup
• Please note the setup for new users or groups only typically needs to occur once and not each time the system is used
datainnovations.com Confidentialdatainnovations.com Confidential 29
Open the Security Menu
datainnovations.com Confidentialdatainnovations.com Confidential 30
Open the Users and Groups Menu Item
datainnovations.com Confidentialdatainnovations.com Confidential 31
Open the Group Configuration Settings
datainnovations.com Confidentialdatainnovations.com Confidential 32
Add a New Group to Group Configuration
Fill in a group name and description (if desired) then press Enter
datainnovations.com Confidentialdatainnovations.com Confidential 33
Add a New Group to Group Configuration
1) Select the newly added group entry in the list.
2) Then, click on the ODBC Tab (lower right) and
3)“Check” each options giving the group access to ODBC
1
2
3
datainnovations.com Confidentialdatainnovations.com Confidential 34
Add a New User
Fill in a desired user name as well as any additional information under Full Name, Description, Email address and then press Enter
datainnovations.com Confidentialdatainnovations.com Confidential 35
Add a New User
1) Select the new user from the list and then 2) assign the user as a member of the new group we created -EEODBC
1
2
datainnovations.com Confidentialdatainnovations.com Confidential 36
Add a New User
1) Right click the new user and then 2) click “Set Password” and 3) assign a password to the accountthen select OK
1
2
3
Note: leave “Change on Logon” unchecked
datainnovations.com Confidentialdatainnovations.com Confidential 37
Transition to EE
• Once a user is created and assigned to a group with ODBC permissions, additional setup in EE needs to occur
• The next few slides will go over setup in EE
• Please note that this is typically a 1-time setup and not intended to occur each time the system is used
datainnovations.com Confidentialdatainnovations.com Confidential 38
Open a Statmod in EE
datainnovations.com Confidentialdatainnovations.com Confidential 39
Select “ODBC” Data Acquisition
datainnovations.com Confidentialdatainnovations.com Confidential 40
Select “ODBC” Data Acquisition
datainnovations.com Confidentialdatainnovations.com Confidential 41
Select the DSN button, Click on System DSN tab
datainnovations.com Confidentialdatainnovations.com Confidential 42
Add a new item, select circled item and then finish
datainnovations.com Confidentialdatainnovations.com Confidential 43
Configure the Data Source screen
1) Fill out a name and description (Name can’t have spaces)
2) The default configuration is intended for systems where IM and EE are installed on the same server or computer, do not change unless required. Add an “IM” to the Cache Namespace section
3) Fill out the ODBC user name we created in IM along with the password we assigned it
1
2
3
5
5) Once steps 1-4 are completed, test the connection to make sure we can connect to IM
4
4) Check this box
datainnovations.com Confidentialdatainnovations.com Confidential 44
Test the Connection
Once steps 1-4 are completed from the previous slide, test the connection to make sure we can connect to IM. Then click “OK” on the test screen and the main screen
datainnovations.com Confidentialdatainnovations.com Confidential 45
Collecting Data from IM using EE
• While the previous slides went over a setup and configuration process that likely will not be repeated very often, the next slides go over activity that will likely be repeated numerous times
• The next few slides explain the process of pulling data from IM and into EE using the “RRE” functionality in EE
• RRE interacts with Policies set up on EE. Some of the concepts behind Policies will be discussed at the end of this presentation
datainnovations.com Confidentialdatainnovations.com Confidential 46
Select “ODBC” Data Acquisition
datainnovations.com Confidentialdatainnovations.com Confidential 47
Run the Query Wizard
1) Select IM Connection from the first drop down
2) Select the Connection we just created in the middle drop down
3) You may select either Live or Archive data depending on where you want to pull data in IM from in the last drop down
12
3 After 1-3 are done, select the Run Query Wizard button
datainnovations.com Confidentialdatainnovations.com Confidential 48
Select a date range and other options
Set a date range to encompass the dates of the specimen results to be imported into EE Some additional settings
may be enabled here to further filter specimens that will be imported into EE
datainnovations.com Confidentialdatainnovations.com Confidential 49
Select the connection(s) to import data from
Select the connection in IM to import results from
datainnovations.com Confidentialdatainnovations.com Confidential 50
Connections
As shown, the list in the EE Query wizard is pulled from the connection list in IM
datainnovations.com Confidentialdatainnovations.com Confidential 51
Load test codes to import into EE from IM
1
2
There are two options to select the test codes to import into EE
1- load from a panel (requires some pre-configuration in EE)
Or
2) Load all test codes associated with the connections configuration
datainnovations.com Confidentialdatainnovations.com Confidential 52
Selecting test codes loaded from configuration
datainnovations.com Confidentialdatainnovations.com Confidential 53
Specimen filter / selection screen
Certain filters can be applied to import Specimen results that are applicable.
If Specimen required to be imported into EE follow a certain pattern, such as the SpecimenID starts with a value (shown), then these filters can be applied to the query into the IM database.
datainnovations.com Confidentialdatainnovations.com Confidential 54
Finish the query
datainnovations.com Confidentialdatainnovations.com Confidential 55
Send the gathered data to EE
The imported data may be reviewed on this screen.
Individual specimen, groups of specimen, or all specimens may be sent to the EE Module on this screen using the ‘Send to SP’ button
datainnovations.com Confidentialdatainnovations.com Confidential 56
Select an instrument class
datainnovations.com Confidentialdatainnovations.com Confidential 57
Select the Sample Names
datainnovations.com Confidentialdatainnovations.com Confidential 58
(optional) Define Reagent/Calibrator information
Note: The values from this screen will appear on the report for the experiment if filled in.
The data can also be filled in later in the Parameters screen inside one of the imported analyte experiments.
datainnovations.com Confidentialdatainnovations.com Confidential 59
Add an Analyst and a date
Note: The Analyst name and Experiment Date will appear on the report for the experiment.
The values can be modified later in the Parameters screen for an individual experiment if desired.
datainnovations.com Confidentialdatainnovations.com Confidential 60
Add an optional comment
Note: The comment field will appear on the report and can be modified in the Parameters screen for the experiment at a later time if desired
datainnovations.com Confidentialdatainnovations.com Confidential 61
The data has been added to EENote: The data has been imported but needs to be “recalculated” to show pass/fail criteria as well as the Number of Samples, Mean, SD, and CV.
The pass/fail criteria is based on settings for an analyte that are either set up in policy definitions or added individually to an experiment via parameters.
Double click an experiment to open it
datainnovations.com Confidentialdatainnovations.com Confidential 62
Recalculating, Params and Reports
• Now that all of the data has been imported into EE, the individual experiments can be reviewed
• Parameters can be reviewed or edited
• And a report can be printed of either all of the experiments or individually for each experiment
datainnovations.com Confidentialdatainnovations.com Confidential 63
Opening an Experiment (add or confirm Params)
datainnovations.com Confidentialdatainnovations.com Confidential 64
Parameters
1
2
3
4
1) The Analyst and Date values were pulled in from the Analyst and Date settings configured during the ODBC acquisition process
2) The pass/fail criteria can either be set manually per experiment or be defined with Policies for instruments/analytes
3) The QC Material settings are optionally added during ODBC Data acquisition
4) The comment is optionally added during ODBC Data acquisition
datainnovations.com Confidentialdatainnovations.com Confidential 65
Go back to the overview screen
datainnovations.com Confidentialdatainnovations.com Confidential 66
Recalculate the imported data
Once pass/fail criteria and other Parameters have been set or confirmed, the imported data needs to be recalculated.
datainnovations.com Confidentialdatainnovations.com Confidential 67
After Recalculation – pass/fail and other metrics are shown
datainnovations.com Confidentialdatainnovations.com Confidential 68
After Recalculation – Print a report of the new experiments
datainnovations.com Confidentialdatainnovations.com Confidential 69
Printed report example
datainnovations.com Confidential 70
Sanford Health
• Ability to easily & selectively import data from IM into EP Evaluator.
• Reduce time for data entry from days to seconds• Instrument-to-Instrument comparison
from 10 hours to 3 seconds
• Total time to import data, the analysis and printing of reports only a few minutes
• EP Evaluator • Produces ‘inspector-ready’ reports that
are clear and concise • Reports are easy to interpret by the
regulatory agencies’ laboratory inspection team.
Profile:
Type: Non-profit, integrated health care delivery system
Specialties: • Top 100 for Cardiac Care• Nationally ranked Children’s Hospital• Level II trauma center Bed
Size: • 43 hospitals and 250 clinics • 600 Beds• 4 Reference (core) laboratories
Discipline: Chemistry
Volume: 4 million tests annually3 million in clinical chemistry
Instrumentation: Abbott Architect
Time to import, the analysis & printing of regulatory reports is minutes vs. days
datainnovations.com Confidentialdatainnovations.com Confidential 71
Questions?Thank you for your time!
datainnovations.com Confidential 72
Agenda – Regional User Group
Introductions –Gina Coughlin
Group exercise – Developing Rules - Jeff Piepenburg09:45 am
11:30 am Recent Releases and Product Roadmap – Tawni Reller
01:00 pm
02:15 pm
04:15 pm
9:00 am
2:15 pm Customer Key Topic Discussion
Conclusion
EP / IM Integration Training - Colin Deming
datainnovations.com Confidentialdatainnovations.com Confidential 73
Customer Key Topic Discussion
• Start thinking about the following items below for the group break out session at the end of the day
• With in your group, rank the top five most important things to you under the following categories. You only need to write down 5 total things and they can be placed under any of the topics
1. Direction of Product Development and enhancements
2. Topics for Regional User Groups, regional 2 day user group and Webinars
3. DI processes and procedures (i.e. support request, upgrading versions)
datainnovations.com Confidential 74
Agenda – Regional User Group
Introductions –Gina Coughlin
Group exercise – Developing Rules - Jeff Piepenburg09:45 am
11:30 am Recent Releases and Product Roadmap – Tawni Reller
01:00 pm
02:15 pm
04:15 pm
9:00 am
4:15 pm
Customer Key Topic Discussion
Conclusion
EP / IM Integration Training - Colin Deming
datainnovations.com Confidentialdatainnovations.com Confidential 75
Thank you for attending
Please fill out the survey in your folder and leave on the table to be collected