Hi Michael, Forwarding this thread to the GPC dev group; many of whom also provide BI services for various parts of their medical centers.
We’re building more reports out of R that are easy to use and very focused. R itself is daunting to novices. Vince on our team (Vince Leonardo) is probably the best person to do a taste test comparison of approaches. So far Qlikview for university reporting has been reasonably responsive. We probably will have some long term concerns with a large spaghetti code QVD qlikview object that makes maintenance potentially tricky. QV also has a more complex licensing model(s) in that you can have seat, concurrent users, and document licenses. At this point for the GPC, all the software is open source/free (i2b2, REDCap, R). If we did need to provide a BI platform, we’d probably sort that out as a group and it would likely depend on where the data are hosted. Russ On Jul 21, 2014, at 11:08 AM, MICHAEL RANDALL <[email protected]<mailto:[email protected]>> wrote: Dear Russ: Please forward as you suggest. That will be a great start. We are using i2b2 as well. Do you find that R works well for you with regard to self-service BI tools such as dashboards and the like? We have Oracle as well. Are you pleased with its performance as well as QlickView’s (they are a candidate for this project)? Do you have or are you aware of any of an OEM (per site) license for ClickView or other with sublicensing to members? Do you handle all of the licensing for GPC and sublicense to your user members or other (maybe simpler with i2b2 and R)? This is a fascinating subject and I really appreciate your input and your help with all of this. Very best regards, Mike <image001.png> Good Health Made PossibleTM Michael Randall, Ph.D., MBA Chief Economic Development Officer [email protected]<mailto:[email protected]> 864-608-1047 www.HealthSciencesSC.org<http://www.healthsciencessc.org/> <image002.png><https://www.linkedin.com/company/health-sciences-south-carolina> <image003.png><https://www.facebook.com/HealthSciencesSouthCarolina> <image004.png><https://twitter.com/HSSCtweets> From: Russ Waitman [mailto:[email protected]<mailto:[email protected]>] Sent: Monday, July 21, 2014 11:27 AM To: MICHAEL RANDALL Subject: Re: Request Hi Michael, I am not sure about how easy it is to get the whole GPC’s input on a call but we’d love to help share approaches. I think it’s fairly heterogeneous and depends a lot on how informatics is structured at each place. Would you like me to share your request to the leaders at each site? We could have people email back their approaches and then you might follow up with the ones you find most interesting. Here at KUMC our team’s role is separate from the hospital but increasingly supporting it. We use i2b2 plus R for general research needs and are now piloting its use for the health system’s population health needs. On the KUMC institutional reporting side (finance, university functions) we stage data or have views other Oracle systems like PeopleSoft and then serve up the information using Qlikview. For PCORI through the GPC, we will be using i2b2 at each site and proposed and will use R for preliminary analyses. We’ll serve datasets to people as well in REDCap. That’s how we do things at KUMC. Since award from PCORI we’ve learned we also need to support the MiniSentinel data model so that will require transforming the data into that data model so it can have SAS based scripts run against it. So, we need to be flexible. Let me know Russ On Jul 21, 2014, at 8:30 AM, MICHAEL RANDALL <[email protected]<mailto:[email protected]>> wrote: Greetings Russ: I hope that are doing well and that GPC is flourishing. I have a favor to ask of you. Health Sciences South Carolina (HSSC: http://healthsciencessc.org/), a statewide health research collaborative, is in the process of selecting a self-service BI/analytics toolset that we can offer to our membership in conjunction with our clinical data warehouse and research services. We feel that this system will be very helpful to local and institutional quality improvement efforts and that it will help our members to better understand and benchmark their respective care capabilities. In planning for this system, we have discussed licensing and sustainability models for incorporation of the new self-service BI/analytics tool into our system, as a tool for our members to use to benefit healthcare in South Carolina, and we thought that it would be a good idea to reach out to other multi-institution collaboratives like yours in order to understand how you offer analytics products to your members (sublicenses or other, as well as other important factors to consider, etc.?) as well as how your business models for sustainability of these types of systems are structured and work. Would GPC be willing to share its experience and suggestions with regard to multi-institutional software selection, licensing and business model? We would greatly appreciate the benefit of your experience. Thank you so much in advance for your help and input. Very best regards, Michael <image001.png> Good Health Made PossibleTM Michael Randall, Ph.D., MBA Chief Economic Development Officer [email protected]<mailto:[email protected]> 864-608-1047 www.HealthSciencesSC.org<http://www.healthsciencessc.org/> <image002.png><https://www.linkedin.com/company/health-sciences-south-carolina> <image003.png><https://www.facebook.com/HealthSciencesSouthCarolina> <image004.png><https://twitter.com/HSSCtweets>
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
