Events
Space shortcuts
Space Tools

Versions Compared

Key

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

...

Section

Presentations

 

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

video

width50%

Video

 

 

presentation
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

video

Column

presentation

 


 

 

Section

i2b2 ETL

 

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

 

Discussion Highlights:

 

  • Eureka Clinical Analytics project at Emory
  • ETL tools used to load from central warehouse into i2b2
  • EMR is Cerner
  • Implemented incremental loading

 

 

Section
Column

video

Column

presentation

 


 

 

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

video

Column

presentation

 


 

 

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

video

Column

presentation

 


 

 

 

Section
Column
width50%

Widget Connector
urlhttps://www.youtube.com/watch?v=xHSepmUBGHY&feature=youtu.be

 

 

Column
width50%

 

View file
nameData Democratization-2.ppsx
height250