Spend a day learning about the new SQL on FHIR standard and how it unlocks real-world analytics use cases from industry leaders at HL7, Microsoft, Google, Health Samurai, CSIRO and more.
Join the creators of the SQL on FHIR standard as they share their insights on how it enables a simple, efficient and powerful FHIR analytics ecosystem. Learn how this standards-based approach to transforming FHIR into tabular views helps with use cases such as EMR integration and allows organizations to leverage investments in relational database, analytics and business intelligence platforms.
This event offers a unique opportunity to deepen your understanding of SQL on FHIR and connect with the industry leaders in FHIR analytics. Engage with the experts, ask questions, and explore real-world applications of this game-changing technology.
Principal
Antidote Solutions
Arjun is a health care product and software consultant. Most recently Arjun was Director of Product for NCQA's Information Integrity portfolio (including DAV and FHIR data quality) and supported NCQA's Digital Quality initiatives. At 1up, Arjun oversaw value added analytics products including SQL on FHIR. He started his health care career at Harvard Medical School/Boston Children's Hospital SMART Project lead by Zak Kohane and Ken Mandl (where he authored the first SMART app).
Senior Staff Software Engineer
at Google
Ryan Brush is a software engineer on the Health AI team at Google. He was also an early contributor to various "SQL on FHIR" efforts and has long held an interest in making FHIR work well with the best available analytic and machine learning tools.In his spare time, Ryan enjoys running, sailing, and drinking too much coffee.
Linkedin ->Chief Technology Officer
Health Samurai
Nikolai is a CTO at Health Samurai and technical leader of the Aidbox FHIR Platform with more than 15 years of experience in healthcare IT. Since 2012 has been actively contributing to the FHIR standard, and popular open-source projects like Fhirbase, FHIR.js. Author of the FHIR-first development approach and regular speaker of FHIR events.
Linkedin ->Principal, Data standards
Central Square Solutions
Dan Gottlieb is a clinical informaticist and software consultant with experience leading the design and development of healthcare apps and population health analytic tools for commercial and non-profit organizations. He serves as the senior technical advisor to the SMART on FHIR Project and a subject matter expert for the Argonaut FHIR Accelerator, and is the co-creator and maintainer of the FHIR population data API standard (“FHIR Bulk Data”) which has been deployed by organizations including CMS, Epic, Cerner, Microsoft and Google.
Linkedin ->Principal Research Consultant
CSIRO
John is an engineer and researcher working at the intersection of standards and health data analytics at CSIRO, the Australian national science agency. He is the primary contributor to Pathling, a set of tools for using clinical terminology and FHIR with Apache Spark and a member of the FHIR Analytics collaborative and a key contributor to the SQL on FHIR project
Linkedin ->Principal Integration Engineer
Mayo Clinic
Carl is a Principal Platform Integration Engineer at Mayo Clinic, brings 24 years of software engineering experience, including 10 years in Healthcare Technology. He holds a MS in CS from the University of Chicago, he has worked for diverse organizations including Anaconda, Microsoft, Google, and Health Catalyst. Carl joined the FHIR community in 2019 and is active in the SQL on FHIR working group, leading the OMOP subgroup. At the Mayo Clinic, he works with a proprietary FHIR to OMOP translation process
Linkedin ->Freelance programmer,
Sereen Systems
Kiran is a freelance programmer and currently building a TEFCA gateway, an SQL on FHIR engine and a FHIRPath REPL console. He previously built several products related to Identity and Access Management for NextGen and Zen Healthcare. Kiran has also built several MirthConnect extensions including the SSL Extension that is currently sold by Zen Healthcare.
Linkedin ->Software Engineer at
Google
For the past 14 years, Bashir Sadjad has been a software engineer at Google. Over the past few years, his focus has been on healthcare systems in in low-resource environments and in particular the FHIR Info Gateway and FHIR Data Pipes components of OHS.
Linkedin ->Principal
Health Intersections Pty Ltd
Grahame Grieve is HL7's Product Director for "FHIR" - the leading healthcare data exchange standard of the future. Grahame has a background in laboratory medicine, software vendor development, clinical research, open source development and has also conceived, developed and sold interoperability and clinical document solutions and products in the Australian market and around the world.
Linkedin ->DCSIO at HL7
Owner at Kern-IT SRL
Diego Kaminker is a co-chair of the HL7 International Council and the past chair of HL7 Argentina and a former member of the HL7 International Board of Directors. He is the founder and coordinator of the popular online HL7 Fundamentals Course. He owns KERN-IT S.R.L. located in Buenos Aires, Argentina.
Linkedin ->Engage with leading industry experts as they share their insights and experiences in leveraging SQL on FHIR to transform healthcare data management.
Explore the most recent challenges faced in implementing SQL on FHIR and learn strategies to effectively address these issues.
Discover practical use cases that demonstrate the power of SQL on FHIR in real-world healthcare scenarios, showcasing its impact on data analysis and integration.
Gain valuable knowledge on best practices and innovative solutions for optimizing the use of SQL on FHIR in your healthcare systems.
A high-level introduction to FHIR Analytics and the SQL on FHIR project touching on the motivations, the prior art, SQL on FHIR, use cases, and where we're headed next.
Ryan, a lead author of the SQL on FHIR, will give a deep dive into the technical details of the specification. This will include a close look at the heart of the spec, the ViewDefinition and the decisions made during its design.
Experiences integrating SQL on FHIR into a PostgreSQL-based FHIR server
FlatQuack is a new, open source, SQL on FHIR View Definition to SQL compiler that targets DuckDB, a lightweight, high performance database engine. DuckDB can scale from running as a single executable that queries a directory of FHIR resources on a local machine to a distributed platform that queries across billions of resources in the cloud. By compiling to SQL, FlatQuack can be easily integrated into existing data pipelines that use off-the-shelf orchestration tools like DBT and Apache Airflow.
Pathling leverages Apache Spark to enable scalable, distributed processing of FHIR data and streaming capabilities through multiple language interfaces (e.g. Java, Python, R). This enables interesting architectures for processing FHIR for analytic use cases, and we will cover various ways that this capability can be set up alongside operational systems and integrated with existing analytics and business intelligence tools.
Carl will present on overview of the challenges in translating FHIR to OMOP and will discuss various emerging solutions
Safhire is an analytics engine based on SQL on FHIR specification written in Rust. Operating in standalone mode Safhire does not require an external RDBMS server. Processed FHIR data is stored in an embedded DuckDB instance and can be queried using REST API. Safhire can also be connected with any BI tool that has ability to talk to a service using REST API.
Bashir will present how Google is using the new SQL on FHIR v2 specification to widen the use-cases and infrastructure choices for deploying the OHS Analytics component. Open Health Stack (OHS) is a set of open-source components built around FHIR and other open standards with the goal of easy deployment to digital healthcare systems in low-resource environments (LRE). The Analytics component of OHS consists of pipelines to continuously monitor data in a FHIR server and transform it to analytics-friendly formats and tools to make it easy and efficient to write and run population level queries.
This presentation will describe how the HL7 FHIR IG publisher uses SQL on FHIR ViewDefinitions to make it easier to include content out of the resources in pages in the implementation guide, and show same examples of the kinds of things that can be done with this technique
Admission is free of charge, everyone’s welcome!