Events
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Section

Presentations (5)

 

Section

i2b2 Foundation Update

 

Presenter: Diane Keogh, Managing Director, i2b2 Foundation

 

Discussion Highlights:

  • Accomplishments to date
  • Source code repositories
  • Sharing i2b2 plugins
  • Community Support Efforts – Educational webinar series
  • Exploring partnership between i2b2 and tranSMART foundations

 

Section
Column
width50%

 

 

 

Column
width50%

Presentation Slides

 

View file
namei2b2Update-AMIA-Nov2016-DIANE.ppsx
height250

 

 

 


 

 

Section

Enhancing interoperation: an i2b2 ETL schema for Epic EHRs

 

Presenter: James R. Campbell, MD, University of Nebraska

 

Discussion Highlights:

      • ETL Library for Epic EHRs
      • Organizing i2b2 for interoperation
      • i2b2 ETL architecture for Epic EHRs
      • Data warehouse extracts vs CCDA vs FHIR interface for transportability of code

 

Section
Column

Presentation Video

 

 

Widget Connector
urlhttps://www.youtube.com/watch?v=FIfmXZlfw2U

 

Column

Presentation Slides

 

View file
namei2b2EpicETLs-AMIA-Nov2016-JIM.ppsx
height250

 

 


 

 

Section

i2b2 ETL - Eureka Clinical Analytics Project at Emory University

 

Presenter: Andrew Post, MD, PhD, Atlanta Clinical & Translational Science Institute

 

Discussion Highlights:

  • ETL tools used to load from central warehouse into i2b2
  • EMR is Cerner
  • Implemented incremental loading

 

 

Section
Column

Presentation Video

 

Widget Connector
urlhttps://www.youtube.com/watch?v=jbJEA3mVx_w

 

Column

Presentation Slides

 

View file
namePostEurekaETL-AMIA-Nov2016-ANDREW.ppsx
height250

 

 


 

 

Section

HERON ETL for i2b2 and Discussion on how we might support reproducible science as a community

 

Presenter: Russ Waitman, PhD, University of Kansas Medical Center

 

Discussion Highlights:

  • HERON ETL Data Flow
  • Jenkins used to automate the ETL process
  • Data Sources:
    • REDCap
    • Clarity
    • IDX
    • University Health system consortium data

 

 

Section
Column

Presentation Video

 

Widget Connector
urlhttps://www.youtube.com/watch?v=LZzh6p1uiEs

 

Column

Presentation Slides

 

View file
nameHERONi2b2ETLNov2016-RUSS.ppsx
height250

 

 


 

 

Section

ETL with Business Intelligence Development Studio (BIDS)

 

Presenter: Mike Mendis, Partners HealthCare – i2b2

 

Discussion Highlights:

  • BIDS is Visual Studio development environment

  • Microsoft offers SQL Server and Business Intelligence stack provides

    • SQL Server / T-SQL query engine
    • Integration Services provide ETL tools
    • Analysis Services provides tools to build multidimensional databases…
    • Reporting Services provides tools to build reports and a portal to deploy reports

 

  • i2b2 ETLsMicrosoft Connectors available for Oracle database support

    • Can be used to populate i2b2 data marts
    • Run stored procedure to convert to standard format

 

Section
Column

Presentation Video

 

Widget Connector
urlhttps://www.youtube.com/watch?v=WT4aXjW3oNU

 

Column

Presentation Slides

 

View file
nameETLwithBI-AMIA-Nov2016-MIKE.ppsx
height250