News
/
Events

Analytics on FHIR® Recap

November 4, 2024

On October 30, 2024, Health Samurai, Antidote Solution & HL7 organized the “Analytics on FHIR®” online conference.

This event brought together leading industry experts from HL7, Microsoft, Google, Health Samurai, Mayo Clinic, and CSIRO to discuss SQL on FHIR specification & implementations and the future of Analytics on FHIR.

FHIR Analytics & SQL on FHIR: An Introduction by Arjun Sanyal

Arjun Sanyal. Principal Antidote Solutions.

The slides

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.

A Technical Tour of the SQL on FHIR Spec with Ryan Brush

Ryan Brush. Senior Staff Software Engineer at Google

Ryan, a lead editor of SQL on FHIR specifications, will give a deep dive into the technical details of the specifications. This will include a close look at the heart of the spec, the ViewDefinition, and the decisions made during its design.

SQL on FHIR in PostgreSQL. Nikolai Ryzhikov.

Nikolai Ryzhikov. Chief Technology Officer at Health Samurai

The slides

Nikolai will introduce two types of SQL on FHIR View Runners - ETL (in-memory) & ELT (in-database) and demo the ELT implementation for PostgreSQL using Aidbox, open-source ViewDefinition Builder, and Grafana.

Using SQL on FHIR in the HL7 FHIR IG Publisher. Grahame Grieve

Grahame Grieve. Principal Health Intersections Pty Ltd.

The slides

The official HL7 FHIR IG publisher already has a built-in ViewDefinition runner, introduced by Grahame. It can be used to make it easier to generate content on spec pages with SQL queries. This runner is part of the open-source HAPI framework.

Pathling: SQL on FHIR views for Apache Spark. John Grimes.

John Grimes. Principal Research Consultant ‍CSIRO

The slides

John presents Pathling, Apache Spark implementation of ViewDefinition runner.  John shows demo of real-time analytics using FHIR subscriptions, Pathling and Spark streaming, with live-dashboards on PostgreSQL & Superset.

FlatQuack: FHIR resources to SQL tables with DuckDB. Dan Gottlieb

Dan Gottlieb. Principal, Data standards ‍Central Square Solutions

The slides

FlatQuack is a new, open source, View Definition ELT runner that targets DuckDB, a lightweight, high performance database engine. 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.

An Open Approach for Translating FHIR to OMOP. Carl Anderson.

Carl Anderson. Principal Integration Engineer. Mayo Clinic

Carl will share the history and implementation details of FHIR to OMOP  project and will discuss challenges and solutions.

Transforming FHIR for efficient population queries using Open Health Stack. Bashir Sadjad.

Bashir Sadjad. Software Engineer at ‍Google

The slides

Bashir will discuss the evolution of the Google Open Health Stack  (OHS)  Project toward SQL on FHIR v2. OHS can continuously monitor data in an FHIR server and transform it into analytics-friendly formats for population-level queries.

Safhire: Rust-y Ducklings in a Row. Kiran Ayyagari

Kiran Ayyagari. Freelance programmer, Sereen Systems

The slides

Safhire is an analytics engine based on SQL on FHIR specification written in Rust. Processed FHIR data is stored in an embedded DuckDB instance and can be queried using REST API.

What’s next for SQL on FHIR? Roundtable.

Questions:

  • What is the best way for folks who want to get started with SQL on FHIR?
  • How to start working with SQL on FHIR?
  • Demo of SQL on FHIR JavaScript implementation
  • What is the SQL on FHIR group thinking about the next steps of development?
  • What's next for SQL on FHIR in terms of becoming an official HL7 standard?

What to expect

Industry Experts

Engage with leading industry experts as they share their insights and experiences in leveraging SQL on FHIR to transform healthcare data management.

Ongoing Challenges

Explore the most recent challenges faced in implementing SQL on FHIR and learn strategies to effectively address these issues.

Use cases

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.

Best Practices & Solutions

Gain valuable knowledge on best practices and innovative solutions for optimizing the use of SQL on FHIR in your healthcare systems.

Testimonials

HospitalonFHIR - FHIR Camp 2024 – Cascais/Lisbon 🌟 It was a great attending the FHIR Camp 2024, surrounded by passionate professionals and inspiring leaders in the healthcare interoperability space. It was truly an honor to learn from references like Grahame Grieve (and many more), alongside dedicated enthusiasts, all committed to advancing HL7 FHIR standards and fostering better healthcare systems worldwide.

Victor Costa

Membro do conselho na E-Mais - Movimento Associação dos Sistemas de Informação Em Saúde

LInkedin

Had an amazing experience at the FHIR Camp 2024 organized by Health Samurai | Aidbox FHIR® Platform. Inspired by its transformative potential, I look forward to working further in FHIR and hope to see its implementation in Nepal's healthcare system as well.

Manila Bhandari

Electrical Engineer | Researcher

Linkedin

Though a bit delayed but still I don’t want to miss out on talking about the recently concluded #FHIRCamp2024 organized by Health Samurai | Aidbox FHIR® Platform in the beautiful city of Cascais, Portugal.

Gaurav Pradhan

Healthcare & Life-Sciences Consulting | HL7 FHIR® Expert | Digital Transformation Leader

Linkedin

I skipped a lot of recent conferences to prioritize attending FHIR Camp 2024 in Portugal the week before last. It was well worth the trip! It was great to hear Grahame Grieve give the background story on how FHIR came to be an open source effort. The open source angle is really important and unique in that it will require a lot of meaningful collaboration and perhaps unprecedented transparency (things we're not great at in the US) to advance these standards in the coming years. There is and will be a lot of opportunity for people to develop and offer FHIR expertise.

Cindy Throop

Founder, Research Director, Senior Strategic Consultant

Linkedin

It was a pleasure to come to the #FHIR #camp in Cascais as a Hospitals on FHIR ambassador It was a pleasure to exchange our outlook on FHIR #versionning and how to deal with the multiple versions with Grahame Grieve, Lloyd McKenzie, Gino Canessa, Ewout Kramer and Nikolai Ryzhikov I also had the occasion to present the state of FHIR in #France and the work our community is doing to increase adoption And of course, always a pleasure to exchange with friends of the HL7 community.

Luc Chatty

FHIR interoperability expert and architect. CEO of Fyrstain. Hospitals On FHIR ambassador.

Linkedin

FHIR CAMP 2024 in Cascais, Portugal, was filled with excitement and activity. Here are some highlights that I'd love to share. This experience reflected the event's opening message: to connect systems and technologies, we must first connect with each other. It was an incredible day, and I can't wait to see what's next!

Irina Angel

HL7 FHIR® Certified physician-scientist

Linkedin

I'm back from the fantastic experience that was #FHIR Camp 2024 in Cascais, Portugal! I was grateful to reconnect with many of my long-time collaborators and also many new people that bring interesting perspectives that enhance our collective work. I really liked the format - I think it was very conducive to free-flowing conversation about new ideas and approaches. Thank you very much to Nikolai Ryzhikov, Pavel Smirnov and all of Health Samurai | Aidbox FHIR® Platform for the opportunity and the amazing support. I think the event was a great success!

John Grimes

Health Data Interop + Analytics

Linkedin

I had the privilege of attending the FHIR® Camp 2024 🔥 in the beautiful Cascais, Lisbon 🇵🇹 hosted by Health Samurai | Aidbox FHIR® Platform The event brought together some of the brightest minds in the #HL7 #FHIR space, including industry pioneers like Grahame Grieve, Gino Canessa, Lloyd McKenzie, and many others! The sessions were not only inspiring but also directly relevant to the work we do at IgniteData.

Ângelo Ferreira

Tech Product Manager | Healthcare IT | HL7 FHIR

Linkedin

contact us

Get in touch with us today!

By submitting the form you agree to Privacy Policy and Cookie Policy.
Thank you!
We’ll be in touch soon.

In the meantime, you can:
Oops! Something went wrong while submitting the form.
1891 N Gaffey St Ste O, San Pedro, CA 90731
+1 (818) 731-1279
hello@health-samurai.io